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 | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
LOEKZ
Deletion Indicator in Purchasing Document
|
ELOEK |
CHAR
|
1 | 0 | ||||||||||||||||
|
EREKZ
Final Invoice Indicator
|
EREKZ |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
XERSY
Evaluated Receipt Settlement (ERS)
|
XERSY |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
MEMORY
Purchase order not yet complete
|
MEMER |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
WEUNB
Goods Receipt, Non-Valuated
|
WEUNB |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
WEBRE
Indicator: GR-Based Invoice Verification
|
WEBRE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD | TTXJ |
CHAR
|
15 | 0 | |||||||||||||||
|
RETPO
Returns Item
|
RETPO |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | MANDT |
T001
Company Codes
|
MANDT |
| INVOICING | BUKRS | INVOICING | BUKRS |
T001
Company Codes
|
BUKRS |
| 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 | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| INVOICING | LIFNR | INVOICING | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| 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 | INVOICING | MANDT |
T007A
Tax Keys
|
MANDT |
| INVOICING | MWSKZ | T005 | KALSM |
T007A
Tax Keys
|
KALSM |
| INVOICING | MWSKZ | INVOICING | MWSKZ |
T007A
Tax Keys
|
MWSKZ |
| 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 | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| INVOICING | TXJCD | T005 | KALSM |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM |
| INVOICING | TXJCD | INVOICING | TXJCD |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |
| INVOICING | WAERS | INVOICING | MANDT |
TCURC
Currency Codes
|
MANDT |
| INVOICING | WAERS | INVOICING | WAERS |
TCURC
Currency Codes
|
WAERS |
| 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 |