SAP ABAP Table FIEUD_SDINV_I (SAFT: Invoices from SD module(Item))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-SAFT (Package) SAF-T Reporting (generic parts)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FIEUD_SDINV_I	Table Relationship Diagram
Short Description	SAFT: Invoices from SD module(Item)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	INVOICE_NO	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
4	INV_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
6	INV_DATE	☑	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
7	EXT_UUID	☑	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
8	ORG_ON	☐	FIPT_ORGON	TEXT30	CHAR	30	0	SAFT PT : Originating ON
9	ORG_DATE	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
10	PRODUCTCODE	☐	FIEU_MATNR		CHAR	30	0	SAFT :Product Code
11	PRODUCTDESC	☐	FIEU_MAKT		CHAR	200	0	SAFT : Product Description
12	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
13	UNITOFMEASURE	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
14	UNITPRICE	☐	WERTV9	WERTV9	CURR	17	2	9(17)-character value field with 2 decimal places
15	DOCUMNTTYPE	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
16	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
17	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
18	TAXPOINTDATE	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
19	CRED_NOTE_REF	☐	FIEU_XBLNR		CHAR	60	0	SAFT : Reference Document
20	CRED_NOTE_REA	☐	FIEU_REASON		CHAR	50	0	SAFT : Reason
21	DESCRIPTION_LINE	☐	FIEU_DESCR		CHAR	60	0	Description
22	DOCUMENT_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
23	DEBIT_AMOUNT	☐	WERTV9	WERTV9	CURR	17	2	9(17)-character value field with 2 decimal places
24	CREDIT_AMOUNT	☐	WERTV9	WERTV9	CURR	17	2	9(17)-character value field with 2 decimal places
25	TAXCODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
26	TAXPERCENT	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
27	TAXAMOUNT	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
28	SHKZG	☐	SHKZG_VF	SHKZG_VF	CHAR	1	0	Returns item
29	EXCHANGERATE	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
30	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
31	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
32	KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
33	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
34	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
35	KAWRT	☐	KAWRT	WERTV8	CURR	15	2	Condition Basis
36	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
37	TAXLIKE_MAT_IND	☐	FIPT_TLMIND		CHAR	1	0	SAFT PT : Tax Like Materials Indicator
38	DISCOUNT_AMT	☐	WERTV9	WERTV9	CURR	17	2	9(17)-character value field with 2 decimal places
39	SALES_ORDER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
40	SORDER_POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
41	SETLMNT_AGRMNT	☐	TEXT1_052	TEXT50	CHAR	50	0	Own Explanation of Term of Payment
42	CURRR_DEBIT_AMT	☐	WERTV13	WERTV13	CURR	25	2	Value field 13(25) characters with 2 decimal places
43	CURR_CREDIT_AMT	☐	WERTV13	WERTV13	CURR	25	2	Value field 13(25) characters with 2 decimal places
44	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
45	WITH_TAXCODE	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
46	WITH_TAXTYPE	☐	FIPT_WITHTYPE		CHAR	3	0	SAFT PT : Withholding Tax Type
47	WITH_TAXDESC	☐	FIPT_WTTAXDESC		CHAR	60	0	SAFT PT : Withholding tax type description
48	WITH_AMOUNT	☐	FIPT_WTAMOUNT	WERTV9	CURR	17	2	SAFT PT : Withholding Tax Amount
49	DISCOUNT_AGRMNT	☐	FIEU_DISCAGRMNT		CHAR	30	0	SAFT PT : Discount Agreements
50	DISCOUNT_DATE	☐	FIEU_DISCDATE	DATS	DATS	8	0	SAFT : Discount Agreement Date
51	EACCODE	☐	FIEU_CAECODE		CHAR	5	0	SAFT PT : CAE code of Company
52	PAYMENTTERM	☐	FIEU_PAYTERM		CHAR	100	0	SAFT : Payment Terms
53	PAYMENTAMT	☐	FIEU_PAYAMT	WERTV9	CURR	17	2	Payment Amount
54	PAYMENTDATE	☐	DZALDT_ZHL	DATUM	DATS	8	0	Posting date of the payment document
55	PAYCURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FIEUD_SDINV_I	BUKRS	T001	BUKRS
2	FIEUD_SDINV_I	MANDT	T000	MANDT

History

Last changed by/on	SAP	20140121
SAP Release Created in	617