SAP table INVOICING (Generated Table for View)

SAP table INVOICING has 22 primary key fields being MANDT,EBELN,EBELP,BUKRS,WERKS,FPLNR,REPOS,LOEKZ,EREKZ,XERSY,MEMORY,LIFNR,TXZ01,MENGE,MWSKZ,PSTYP,WEPOS,WEUNB,WEBRE,TXJCD,RETPO,FPLTR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
BUKRS Company Code CHAR 4 0 T001 BUKRS
WERKS Plant CHAR 4 0 T001W EWERK
FPLNR Invoicing plan number CHAR 10 0 IPLNR
REPOS Invoice receipt indicator CHAR 1 0 REPOS
LOEKZ Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
EREKZ Final Invoice Indicator CHAR 1 0 EREKZ
XERSY Evaluated Receipt Settlement (ERS) CHAR 1 0 XERSY
MEMORY Purchase order not yet complete CHAR 1 0 MEMER
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
TXZ01 Short Text CHAR 40 0 TXZ01
MENGE Purchase Order Quantity QUAN 13 3 BSTMG
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
PSTYP Item category in purchasing document CHAR 1 0 T163 PSTYP
WEPOS Goods Receipt Indicator CHAR 1 0 WEPOS
WEUNB Goods Receipt, Non-Valuated CHAR 1 0 WEUNB
WEBRE Indicator: GR-Based Invoice Verification CHAR 1 0 WEBRE
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
RETPO Returns Item CHAR 1 0 RETPO
FPLTR Item for billing plan/invoice plan/payment cards NUMC 6 0 FPLTR
FKDAT Settlement date for deadline DATS 8 0 BFDAT
FAREG Rule in billing plan/invoice plan CHAR 1 0 FAREG
1 Milestone billing on a percentage basis
2 Milestone billing on a value basis
3 Closing invoice in milestone billing
4 Down payment in milestone billing on percentage basis
5 Down payment in milestone billing on a value basis
6 Periodic billing (rent)
FAKWR Value to be billed/calc. on date in billing/invoice plan CURR 15 2 FAKWR
FAKSP Billing block for billing plan/invoice plan dates CHAR 2 0 TVFS FAKSP_FP
WAERS2 Currency Key CUKY 5 0 TCURC WAERS
WAERS Currency Key CUKY 5 0 TCURC WAERS
KUFIX Indicator for Fixed Exchange Rate CHAR 1 0 KUFIX
WKURS Exchange Rate DEC 9 5 WKURS
ZTERM Terms of payment key CHAR 4 0 DZTERM
LIFRE Different Invoicing Party CHAR 10 0 LFA1 LIFRE
MEINS Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
FRGRL Release Not Yet Completely Effected CHAR 1 0 FRGRL
AFDAT Billing Date DATS 8 0 FKDAT

INVOICING foreign key relationships

Table Field Check Table Check Field
0 INVOICING BUKRS T001 Company Codes BUKRS
1 INVOICING EBELN EKKO Purchasing Document Header EBELN
0 INVOICING FAKSP TVFS Billing: Reasons for Blocking FAKSP
1 INVOICING LIFNR LFA1 Supplier Master (General Section) MANDT
1 INVOICING LIFNR LFA1 Supplier Master (General Section) LIFNR
0 INVOICING LIFRE LFA1 Supplier Master (General Section) MANDT
0 INVOICING LIFRE LFA1 Supplier Master (General Section) LIFNR
1 INVOICING MANDT T000 Clients MANDT
0 INVOICING MEINS T006 Units of Measurement MANDT
0 INVOICING MEINS T006 Units of Measurement MSEHI
1 INVOICING MWSKZ T007A Tax Keys KALSM
1 INVOICING MWSKZ T007A Tax Keys MWSKZ
0 INVOICING PSTYP T163 Item Categories in Purchasing Document MANDT
0 INVOICING PSTYP T163 Item Categories in Purchasing Document PSTYP
1 INVOICING TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
1 INVOICING TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
0 INVOICING WAERS TCURC Currency Codes MANDT
0 INVOICING WAERS TCURC Currency Codes WAERS
1 INVOICING WAERS2 TCURC Currency Codes MANDT
1 INVOICING WAERS2 TCURC Currency Codes WAERS
0 INVOICING WERKS T001W Plants/Branches MANDT
0 INVOICING WERKS T001W Plants/Branches WERKS