SAP ABAP Table INVOICING (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	INVOICING	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
4	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	WERKS	☑	EWERK	WERKS	CHAR	4	0	Plant	T001W
6	FPLNR	☑	IPLNR	CHAR10	CHAR	10	0	Invoicing plan number
7	REPOS	☑	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
8	LOEKZ	☑	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
9	EREKZ	☑	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
10	XERSY	☑	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
11	MEMORY	☑	MEMER	XFELD	CHAR	1	0	Purchase order not yet complete
12	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
13	TXZ01	☑	TXZ01	TEXT40	CHAR	40	0	Short Text
14	MENGE	☑	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
15	MWSKZ	☑	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
16	PSTYP	☑	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
17	WEPOS	☑	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
18	WEUNB	☑	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
19	WEBRE	☑	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
20	TXJCD	☑	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
21	RETPO	☑	RETPO	XFELD	CHAR	1	0	Returns Item
22	FPLTR	☑	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards
23	FKDAT	☐	BFDAT	DATUM	DATS	8	0	Settlement Date for Deadline
24	FAREG	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
25	FAKWR	☐	FAKWR	WERTV8	CURR	15	2	Value to be billed/calc. on date in billing/invoice plan
26	FAKSP	☐	FAKSP_FP	FAKSP	CHAR	2	0	Billing block for billing plan/invoice plan dates	TVFS
27	WAERS2	☐	WAERS_CP	WAERS	CUKY	5	0	Currency Key of Credit Control Area	TCURC
28	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
29	KUFIX	☐	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
30	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
31	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
32	LIFRE	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	LFA1
33	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
34	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
35	AFDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	INVOICING	BUKRS	T001	BUKRS	REF	1	N
2	INVOICING	EBELN	EKKO	EBELN	KEY	1	N
3	INVOICING	FAKSP	TVFS	FAKSP	REF	C	CN
4	INVOICING	LIFNR	LFA1	LIFNR	REF	1	N
5	INVOICING	LIFRE	LFA1	LIFNR	REF	1	N
6	INVOICING	MANDT	T000	MANDT	KEY	1	N
7	INVOICING	MEINS	T006	MSEHI	REF	1	N
8	INVOICING	MWSKZ	T007A	MWSKZ	KEY	1	CN
9	INVOICING	PSTYP	T163	PSTYP	REF	1	N
10	INVOICING	TXJCD	TTXJ	TXJCD	REF	1	CN
11	INVOICING	WAERS	TCURC	WAERS	REF	1	N
12	INVOICING	WAERS2	TCURC	WAERS	REF	C	CN
13	INVOICING	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in