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
⤷ 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 |