Standard extractors for J_1BNFDOC, RBKP and others

[Former Member]

I'm using standard extractors 2LIS_11, 2LIS_13, 2LIS_12 and 2LIS_08 for Sales Order, it's OK until now.

Also using 2LIS_02 for Purchase Orders.

I'd like to use standard extractors for other documents, so I'm asking for help.

No problem using generic DataSources if necessary, but I prefer using the standard, specially because of delta handling.

1) Tables J_1BNFDOC and J_1BNFLIN (Nota Fiscal - Billing Brazil)

2LIS_13 DataSources extract billing documents from tables VBRK and VBRP.

But how can I extract Nota Fiscal (Billing Brazil) from tables J_1BNFDOC (Header) and J_1BNFLIN (Items) ???

I saw in an SAP Note that updates to J_1BNFLIN would be recorded in MCEX13 delta queue.

Can I understand that 2LIS_13 can extract also Notas Fiscais ???

If so, is there any configuration ???

2) Tables RBKP and RSEG (Billing Documents for Purchase Orders)

Billing documents for Purchase Orders are saved in tables RBKP and RSEG.

So I can't get them using 2LIS_13 DataSources.

Is there any standard DataSources that I can use to get these documents ???

3) LE Shipping (2LIS_12)

I can get all shipping documents (tables LIKP and LIPS) for Sales Orders.

But can't get these documents for Purchase Orders.

Is it correct ??? Do I need to set any configuration for these DataSources ???

4) Transfer Orders (tables LTAK and LTAP)

Is there any standard DataSources for these documents ???

5) Stock data for MM and WM (tables MARD and LQUA)

Is there any standard DataSources for these documents ???

Thanks in advance.

César Menezes

[former_member225701]

Hi Cesar,

did you find out if there any standard extractors for  Tables J_1BNFDOC and J_1BNFLIN (Nota Fiscal - Billing Brazil).

I have to pull this info to BW and exploring whether the standard 2LIS_13 extractors can be configured to pull Nota Fiscal information or do we have to create generic extractors on these tables.

[Former Member]

Hi Saurabh

I found some of them.

1) J_1BNFDOC (Nota Fiscal Header)

    Data Source: 0ID_BR_NF_1

    DSO: 0NF_DS01

2) J_1BNFLIN (Nota Fiscal Lines)

    Data Source: 0ID_BR_NF_2

    DSO: 0NF_DS02

They are country-specific (Brasil).

You have Data Sources  from 0ID_BR_NF_1 through 0ID_BR_NF_6, but I used only these two.

3) RBKP (Invoice Receipt)

    Data Source: 2LIS_06_INV

    DSO: 0LIV_DS01

It's quite recent, available only in the last BW versions.

If you find any information about the other tables please publish it.

Regards

César

[former_member225701]

that is the same information that I found as well.

http://help.sap.com/saphelp_nw70/helpdata/en/6d/b8523bbcb45f6ee10000000a11402f/frameset.htm

do you know if 0ID_BR_NF_1, 0ID_BR_NF_2 are full or delta...documentation says that they are full loads which is very surprising to me.