SAP Table INVOICING
Generated Table for View
INVOICING (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link INVOICING to other SAP tables.
INVOICING table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
| EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 | 0 | ||||||||||||||
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | 0 | |||||||||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||
| WERKS | Plant | EWERK | T001W | CHAR | 4 | 0 | ||||||||||||||
| FPLNR | Invoicing plan number | IPLNR | CHAR | 10 | 0 | |||||||||||||||
| REPOS | Invoice Receipt Indicator | REPOS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LOEKZ | Deletion Indicator in Purchasing Document | ELOEK | CHAR | 1 | 0 | |||||||||||||||
| EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| MEMORY | Purchase order not yet complete | MEMER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LIFNR | Vendor Account Number | ELIFN | LFA1 | CHAR | 10 | 0 | ||||||||||||||
| TXZ01 | Short Text | TXZ01 | CHAR | 40 | 0 | |||||||||||||||
| MENGE | Purchase Order Quantity | BSTMG | QUAN | 13 | 3 | |||||||||||||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 | 0 | ||||||||||||||
| PSTYP | Item Category in Purchasing Document | PSTYP | T163 | CHAR | 1 | 0 | ||||||||||||||
| WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR | 15 | 0 | ||||||||||||||
| RETPO | Returns Item | RETPO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | NUMC | 6 | 0 | |||||||||||||||
| FKDAT | Settlement date for deadline | BFDAT | DATS | 8 | 0 | |||||||||||||||
| FAREG | Rule in billing plan/invoice plan | FAREG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| FAKWR | Value to be billed/calc. on date in billing/invoice plan | FAKWR | CURR | 15 | 2 | |||||||||||||||
| FAKSP | Billing block for billing plan/invoice plan dates | FAKSP_FP | TVFS | CHAR | 2 | 0 | ||||||||||||||
| WAERS2 | Currency Key of Credit Control Area | WAERS_CP | TCURC | CUKY | 5 | 0 | ||||||||||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||
| KUFIX | Indicator: Fixing of Exchange Rate | KUFIX | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| WKURS | Exchange Rate | WKURS | DEC | 9 | 5 | |||||||||||||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | 0 | |||||||||||||||
| LIFRE | Different Invoicing Party | LIFRE | LFA1 | CHAR | 10 | 0 | ||||||||||||||
| MEINS | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 | 0 | ||||||||||||||
| FRGRL | Release Not Yet Completely Effected | FRGRL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| AFDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | 0 | |||||||||||||||
INVOICING foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| INVOICING | BUKRS | INVOICING | BUKRS | T001 | Company Codes | BUKRS |
| INVOICING | BUKRS | INVOICING | MANDT | T001 | Company Codes | MANDT |
| INVOICING | EBELN | INVOICING | MANDT | EKKO | Purchasing Document Header | MANDT |
| INVOICING | EBELN | INVOICING | EBELN | EKKO | Purchasing Document Header | EBELN |
| INVOICING | FAKSP | INVOICING | MANDT | TVFS | Billing: Reasons for Blocking | MANDT |
| INVOICING | FAKSP | INVOICING | FAKSP | TVFS | Billing: Reasons for Blocking | FAKSP |
| INVOICING | LIFNR | INVOICING | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| INVOICING | LIFNR | INVOICING | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| INVOICING | LIFRE | INVOICING | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| INVOICING | LIFRE | INVOICING | LIFRE | LFA1 | Vendor Master (General Section) | LIFNR |
| INVOICING | MANDT | INVOICING | MANDT | T000 | Clients | MANDT |
| INVOICING | MEINS | INVOICING | MANDT | T006 | Units of Measurement | MANDT |
| INVOICING | MEINS | INVOICING | MEINS | T006 | Units of Measurement | MSEHI |
| INVOICING | MWSKZ | T005 | KALSM | T007A | Tax Keys | KALSM |
| INVOICING | MWSKZ | INVOICING | MWSKZ | T007A | Tax Keys | MWSKZ |
| INVOICING | MWSKZ | INVOICING | MANDT | T007A | Tax Keys | MANDT |
| INVOICING | PSTYP | INVOICING | MANDT | T163 | Item Categories in Purchasing Document | MANDT |
| INVOICING | PSTYP | INVOICING | PSTYP | T163 | Item Categories in Purchasing Document | PSTYP |
| INVOICING | TXJCD | INVOICING | TXJCD | TTXJ | Check Table for Tax Jurisdiction | TXJCD |
| INVOICING | TXJCD | INVOICING | MANDT | TTXJ | Check Table for Tax Jurisdiction | MANDT |
| INVOICING | TXJCD | T005 | KALSM | TTXJ | Check Table for Tax Jurisdiction | KALSM |
| INVOICING | WAERS | INVOICING | WAERS | TCURC | Currency Codes | WAERS |
| INVOICING | WAERS | INVOICING | MANDT | TCURC | Currency Codes | MANDT |
| INVOICING | WAERS2 | INVOICING | MANDT | TCURC | Currency Codes | MANDT |
| INVOICING | WAERS2 | INVOICING | WAERS2 | TCURC | Currency Codes | WAERS |
| INVOICING | WERKS | INVOICING | MANDT | T001W | Plants/Branches | MANDT |
| INVOICING | WERKS | INVOICING | WERKS | T001W | Plants/Branches | WERKS |
