consignment and ers vendor

Consignment Vendors

ZAP_01_RKWA BELNR

EQ 0FI_AP_4BELNR

ZAP_01_RKWA GJAHR

EQ 0FI_AP_4GJAHR

ZAP_01_RKWA BUZEI

EQ 0FI_AP_4BUZEI

Sr. No. Columns Field Name Extractor SAP Field Name SAP Table Name

T.Code Comments

1 A Company Code ZAP_01_RKWA BUKRS RKWA MRKO 2 B Vendor ZAP_01_RKWA LIFNR LFA1 FK03 3 C Vendor Name - 1 ZAP_01_RKWA NAME1 LFA1 FK03

4 XX.1 Vendor Name - 2 ZAP_01_RKWA NAME2 LFA1 FK03 Will be added by Standard Extractor



7 D Plant ZAP_01_RKWA WERKS RKWA MRKO 8 E Material ZAP_01_RKWA MATNR RKWA MRKO 9 F Material Description ZAP_01_RKWA MAKTX RKWA MARA

10 G SPT No Need as per Lindsey's Input11 H Vendor ASN ? ? ? ? Requires Lindsey's Input12 I Vendor Packing List ? ? ? ? Requires Lindsey's Input

13 J Vendor Document Number

? ? ? ? Requires Lindsey's Input

14 K Quantity ZAP_01_RKWA BSTMG RKWA MRKO 15 L UoM ZAP_01_RKWA BSTME RKWA MRKO

16 M Reference 0FI_AP_4 XBLNR BSIK/BSAK FBL1N

For NORMAL/ERS Vendors, the XBLNR will be {Col M} Reference field i.e. their Invoice/Packing Slip number. If {Col M} is filled, then

{Col N} Folio Number Field will be BLANK

17 N Folio Number 0FI_AP_4 XBLNR BSIK/BSAK FBL1N

For Consignment Vendors, the XBLNR will be {Col N} Folio Number & {Col M} Reference field will be Blank and

18 O FI - Document Number 0FI_AP_4 BELNR BSIK/BSAK FBL1N 19 P FI - Document Type 0FI_AP_4 BLART BSIK/BSAK FBL1N 20 Q FI - Fiscal Year/Period 0FI_AP_4 FISCPER BSIK/BSAK FBL1N

21 XX.4 FI - Fiscal Year 0FI_AP_4GJAHR

BSIK/BSAK FBL1N Will be added by Standard Extractor

22 XX.5 FI - Line Item 0FI_AP_4 BUZEI BSIK/BSAK FBL1N Will be added by Standard Extractor

23 XX.6 FI - Posting Key 0FI_AP_4 BSCHL BSIK/BSAK FBL1N Will be added by Standard Extractor

24 XX.7 FI - Fiscal Year Variant 0FI_AP_4 FISCVAR BSIK/BSAK FBL1N Will be added by Standard Extractor

25 XX.8 FI - Posting Date 0FI_AP_4 BUDAT BSIK/BSAK FBL1N Will be added by Standard Extractor

26 R FI - Document Date 0FI_AP_4 BLDAT BSIK/BSAK FBL1N 27 S FI - Baseline Date 0FI_AP_4 ZFBDT BSIK/BSAK FBL1N

28 T FI - Amount ZAP_01_RKWA - Amount

0FI_AP_4 DMSHB BSIK/BSAK FBL1N

There was 2 Line Items in ZFI_01_RKWA, that should be used to display the amount, and not the 0FI_AP_4, as there will be only 1 line item, which can be issue due to Cardinality

29 U Discount 0FI_AP_4 SKNTO or Calculated Field

BSIK/BSAK FBL1N

SKNTO (Try it), if it does not work, then use below Formula/Logic

Calculated based on Terms listed in Column Y{Col U}Discount = {Col T}Amount x {Lookup values from Discount Table}/100

30 V Amount Paid 0FI_AP_4 ZWRBTR BSIK/BSAK FBL1N {Col V}Amount Paid = {Col T}Amount - {Col U}Discount

31 W FI - Currency 0FI_AP_4 LCURR or WAERS

BSIK/BSAK FBL1N

32 X FI - Tax Code 0FI_AP_4MWSKZ

BSIK/BSAK FBL1N Enhanced the CI_BSIK include in Extractor Structure - DTFIAP_3

33 Y FI - Payment Terms 0FI_AP_4 ZTERM BSIK/BSAK FBL1N 34 Z FI - Net Due Date 0FI_AP_4 NETDT BSIK/BSAK FBL1N 35 AA Clrng doc. 0FI_AP_4 AUGBL BSIK/BSAK FBL1N 36 AB Clearing Date 0FI_AP_4 AUGDT BSIK/BSAK FBL1N

37 XX.9 FI - Withholding Tax Base Amount

0FI_AP_4 QSSHB BSIK/BSAK FBL1N Will be added by Standard Extractor

38 XX.10 FI - Withholding Tax Code 0FI_AP_4 QSSKZ BSIK/BSAK FBL1N Will be added by Standard Extractor

39 XX.11 FI - Withholding Tax-Exempt Amount

0FI_AP_4 QSFBT BSIK/BSAK FBL1N Will be added by Standard Extractor

40 XX.12 Invoice ref. 0FI_AP_4 REBZG BSIK/BSAK FBL1N Will be added by Standard Extractor

41 XX.13 Fiscal year 0FI_AP_4 REBZJ BSIK/BSAK FBL1N Will be added by Standard Extractor

42 XX.14 Line item 0FI_AP_4 REBZZ BSIK/BSAK FBL1N Will be added by Standard Extractor

43 XX.15 Sales Document 0FI_AP_4 VBELN BSIK/BSAK FBL1N Will be added by Standard Extractor

44 XX.16 Transact.type 0FI_AP_4 UMSKS BSIK/BSAK FBL1N Will be added by Standard Extractor

45 XX.17 Assignment 0FI_AP_4 ZUONR BSIK/BSAK FBL1N Will be added by Standard Extractor

46 XX.18 G/L 0FI_AP_4 HKONT BSIK/BSAK FBL1N Will be added by Standard Extractor

47 XX.19 G/L Account 0FI_AP_4 SAKNR BSIK/BSAK FBL1N Will be added by Standard Extractor

ERS Vendor Invoice

For the ERS Vendors, we have to execute the Transaction – MRRL.

Initially when the MRRL is executed in TEST run, we get the following set of data, which does not populate the FI Documents or Invoice Document data.

To populate the data for FI Documents and Invoice Document, we have to run the T.Code – MRRL, without TEST Run and with option “Settle Goods Items + Planned Delivery Costs”, and then only these 2 columns will be displayed.

1. Reference Document (Material Documents) – 1.1. T.Code - MIGO.1.2. Table – EKBE1.3. Field – LFBNR1.4. BW Extractor – 2LIS_06_INV ; Field – LFBNR | Year – LFGJA | Line Item – LFPOS

2. Purchasing Document – ME33L (PO / Agreement Document) – 2.1. T.Code – ME33L2.2. Table – EKBE2.3. Field – EBELN2.4. BW Extractor – 2LIS_06_INV ; Field – EBELN | Line Item – EBELP

3. Invoice Documents – 3.1. T.Code – MIR43.2. Table – EKBE3.3. Field – BELNR3.4. Extractor – 2LIS_06_INV, Field – BELNR | Line Item – BUZEI | Year - GJAHR

4. FI (Accounting) Documents – 4.1. T.Code - FB03.

4.2. Table – BKPF/BSEG4.3. Field - BELNR4.4. Extractor – 0FI_AP_4 , Field – BELNR | Line Item – BUZEI | Year – GJAHR

4.4.1.Logic – Select the Data based on below logic from extractor 0FI_AP_44.4.1.1. 0FI_AP_4-BUKRS = 2LIS_06_INV-BUKRS (Company Code)4.4.1.2. 0FI_AP_4-BELNR = << To find – FI Document Number >>4.4.1.3. 0FI_AP_4-GJAHR = << To find – FI Document Fiscal Year >> 4.4.1.4. 0FI_AP_4-BUZEI = << To find – FI Document Line Item >>4.4.1.5. 0FI_AP_4-AWTYP (Reference Type)

4.4.1.5.1. ‘RMRP’ 4.4.1.6. 0FI_AP_4-AWKEY (Reference Key)

4.4.1.6.1.1. Concatenate Inv. Doc (2LIS_06_INV-BELNR) & Fiscal Year (2LIS_06_INV-GJAHR)4.4.1.7. 0FI_AP_4-BSCHL (Posting Key)

4.4.1.7.1. Invoice – 314.4.1.7.2. Credit Memos – 214.4.1.7.3. Reverse Invoice – 22 4.4.1.7.4. Reverse Credit Memos – 32

4.4.1.8. 0FI_AP_4-KOART (Account Type)4.4.1.8.1. ‘K’ ( Vendors )

Below is the complete list of the Extractors that will be used in SAP BW System.

0FI_AP_4 BUKRS EQ 2LIS_06_INV BUKRS0FI_AP_4 AWTYP EQ CONSTANT RMRP0FI_AP_4 AWKEY EQ CONCATENATE 2LIS_06_INV-BELNR + 2LIS_06_INV-GJAHR0FI_AP_4 BSCHL EQ CONSTANT 31 INVOICE0FI_AP_4 BSCHL EQ CONSTANT 21 CREDIT MEMO0FI_AP_4 BSCHL EQ CONSTANT 22 REVERSE INVOICE0FI_AP_4 BSCHL EQ CONSTANT 32 REVERSE CREDIT MEMOS

Sr. No. Columns Field Name Extractor SAP Field Name SAP Table Name

T.Code Comments

1 A Company Code 2LIS_06_INV BUKRS 2 B Vendor 2LIS_06_INV LIFNR LFA1 FK03 3 C Vendor Name - 1 0VENDOR NAME1 LFA1 FK03

4 XX.1 Vendor Name - 2 0VENDOR NAME2 LFA1 FK03 Will be added by Standard Extractor



7 D Plant 2LIS_06_INV WERKS 8 E Material 2LIS_06_INV MATNR 9 F Material Description 0MATERIAL MAKTX

10 G SPT No Need as per Lindsey11 H Vendor ASN ? ? ? ? Requires Lindsey's Input12 I Vendor Packing List ? ? ? ? Requires Lindsey's Input13 J Vendor Document Number ? ? ? ? Requires Lindsey's Input14 K Quantity 2LIS_06_INV MENGE EKBE MIR4 15 L UoM 2LIS_06_INV MEINS EKBE MIR4

16 XX.4 Material Document No. 2LIS_06_INV LFBNR EKBE MIGO Will be added by Standard Extractor

17 XX.5 Material Document Year 2LIS_06_INV LFGJA EKBE MIGO Will be added by Standard Extractor

18 XX.6 Material Document Line Item 2LIS_06_INV LFPOS EKBE MIGO Will be added by Standard Extractor

19 XX.7 Purchasing Document No. 2LIS_06_INV EBELN EKBE ME33L Will be added by Standard Extractor

20 XX.8 Purchasing Document Line Item 2LIS_06_INV EBELP EKBE ME33L Will be added by Standard Extractor

21 XX.9 Invoice Document no. 2LIS_06_INV BELNR EKBE MIR4 Will be added by Standard Extractor

22 XX.10 Invoice Document Year 2LIS_06_INV GJAHR EKBE MIR4 Will be added by Standard Extractor

23 XX.11 Invoice Document Line Item 2LIS_06_INV BUZEI EKBE MIR4

Will be added by Standard Extractor

Make sure BUZEI is NOT INITIAL

24 XX.12 Reversal document number 2LIS_06_INV STBLG MIR4 Will be added by Standard Extractor

25 XX.13 Fiscal year of reversal document 2LIS_06_INV STJAH MIR4 Will be added by Standard Extractor

26 XX.14 Origin of a Logistics Invoice Verification Document

2LIS_06_INV IVTYP MIR4


Distinguished ERS(Value = 1) from Consignment Vendors

27 XX.15GR/IR account clearing value in local currency 2LIS_06_INV AREWR MIR4


Gross Amount Inclusive of TAX

28 XX.16 Currency Key 2LIS_06_INV WAERS MIR4 Will be added by Standard Extractor

29 XX.17 Tax Amount in Document Currency with +/- Sign

2LIS_06_INV WMWST1 MIR4 WMWST1 = { AREWR - REFWR }

30 XX.18 Invoice Value in Foreign Currency

2LIS_06_INVREFWR

MIR4 REFWR = ( MENGE x NETPR ) / PEINH

31 XX.19Net Price in Purchasing Document (in Document Currency)

2LIS_06_INV NETPR MIR4 Will be added by Standard Extractor

32 XX.20 Cost Unit of Measure 2LIS_06_INV PEINH MIR4 Will be added by Standard Extractor

33 XX.21 Purchasing Group 2LIS_06_INV EKGRP MIR4 Will be added by Standard Extractor

34 XX.22 Purchasing Organization 2LIS_06_INV EKORG MIR4 Will be added by Standard Extractor

35 XX.23Short Text

2LIS_06_INVTXZ01

MIR4 Will be added by Standard Extractor

36 M Reference 0FI_AP_4 XBLNR BKPF/BSEG FBL1N

For NORMAL/ERS Vendors, the XBLNR will be {Col M} Reference field i.e. their Invoice/Packing Slip number.

37 N Folio Number 0FI_AP_4 XBLNR BSIK/BSAK FBL1N It will be BLANK38 O FI - Document Number 0FI_AP_4 BELNR BSIK/BSAK FBL1N 39 P FI - Document Type 0FI_AP_4 BLART BSIK/BSAK FBL1N 40 Q FI - Fiscal Year/Period 0FI_AP_4 FISCPER BSIK/BSAK FBL1N

41 XX.24 FI - Line Item 0FI_AP_4 BUZEI BSIK/BSAK FBL1N Will be added by Standard Extractor

42 XX.25 FI - Reference Type 0FI_AP_4 AWTYP BKPF/BSEG FBL1N Will be added by Standard Extractor

43 XX.26 FI - Reference Key 0FI_AP_4 AWKEY BKPF/BSEG FBL1N Will be added by Standard Extractor

44 XX.27 FI - Posting Key 0FI_AP_4 BSCHL BSIK/BSAK FBL1N Will be added by Standard Extractor

45 XX.28 FI - Fiscal Year Variant 0FI_AP_4 FISCVAR BSIK/BSAK FBL1N Will be added by Standard Extractor

46 XX.29 FI - Posting Date 0FI_AP_4 BUDAT BSIK/BSAK FBL1N Will be added by Standard Extractor

47 R FI - Document Date 0FI_AP_4 BLDAT BSIK/BSAK FBL1N 48 S FI - Baseline Date 0FI_AP_4 ZFBDT BSIK/BSAK FBL1N 49 T FI - Amount 0FI_AP_4 DMSHB BSIK/BSAK FBL1N

50 U Discount 0FI_AP_4 SKNTO or Calculated Field

BSIK/BSAK FBL1N

SKNTO (Try it), if it does not work, then use below Formula/Logic

Calculated based on Terms listed in Column Y{Col U}Discount = {Col T}Amount x {Lookup values from Discount Table}/100

51 V Amount Paid 0FI_AP_4 ZWRBTR BSIK/BSAK FBL1N{Col V}Amount Paid = {Col T}Amount - {Col U}Discount

52 W FI - Currency 0FI_AP_4 LCURR or WAERS

BSIK/BSAK FBL1N

53 X FI - Tax Code 0FI_AP_4MWSKZ

BSIK/BSAK FBL1NEnhanced the CI_BSIK include in Extractor Structure - DTFIAP_3

54 Y FI - Payment Terms 0FI_AP_4 ZTERM BSIK/BSAK FBL1N 55 Z FI - Net Due Date 0FI_AP_4 NETDT BSIK/BSAK FBL1N 56 AA Clrng doc. 0FI_AP_4 AUGBL BSIK/BSAK FBL1N 57 AB Clearing Date 0FI_AP_4 AUGDT BSIK/BSAK FBL1N

58 XX.30 FI - Withholding Tax Base Amount

0FI_AP_4 QSSHB BSIK/BSAK FBL1N Will be added by Standard Extractor

59 XX.31 FI - Withholding Tax Code 0FI_AP_4 QSSKZ BSIK/BSAK FBL1N Will be added by Standard Extractor

60 XX.32 FI - Withholding Tax-Exempt Amount

0FI_AP_4 QSFBT BSIK/BSAK FBL1N Will be added by Standard Extractor

61 XX.33 Invoice ref. 0FI_AP_4 REBZG BSIK/BSAK FBL1N Will be added by Standard Extractor

62 XX.34 Fiscal year 0FI_AP_4 REBZJ BSIK/BSAK FBL1N Will be added by Standard Extractor

63 XX.35 Line item 0FI_AP_4 REBZZ BSIK/BSAK FBL1N Will be added by Standard Extractor

64 XX.36 Sales Document 0FI_AP_4 VBELN BSIK/BSAK FBL1N Will be added by Standard Extractor

65 XX.37 Transact.type 0FI_AP_4 UMSKS BSIK/BSAK FBL1N Will be added by Standard Extractor

66 XX.38 Assignment 0FI_AP_4 ZUONR BSIK/BSAK FBL1N Will be added by Standard Extractor

67 XX.39 G/L 0FI_AP_4 HKONT BSIK/BSAK FBL1N Will be added by Standard Extractor

68 XX.40 G/L Account 0FI_AP_4 SAKNR BSIK/BSAK FBL1N Will be added by Standard Extractor