SAP ABAP Table AFIEUD_SDINV_I (Change Document Structure SAF-T: SD Item Data (FIEUD_SDINV_I)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ GLO_REFX_PT (Package) Localization Flexible Real Estate Portugal

Basic Data

Table Category	INTTAB	Structure
Structure	AFIEUD_SDINV_I	Table Relationship Diagram
Short Description	Change Document Structure SAF-T: SD Item Data (FIEUD_SDINV_I

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

Foreign Keys

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

History

Last changed by/on	SAP	20140121
SAP Release Created in