SAP ABAP Table PTDART_ITEMS (DART Fileds : XML file)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-LOC (Application Component) Localization
⤷ ID-FI-PT (Package) Add-On Development - FI - Portugal
⤷ FI-LOC (Application Component) Localization
⤷ ID-FI-PT (Package) Add-On Development - FI - Portugal
Basic Data
Table Category | INTTAB | Structure |
Structure | PTDART_ITEMS | Table Relationship Diagram |
Short Description | DART Fileds : XML file |
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 | FILE_VERSION | TEXT1 | TEXT50 | CHAR | 50 | 0 | Text | ||
2 | COMPANY_ID | TEXT1 | TEXT50 | CHAR | 50 | 0 | Text | ||
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
4 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
5 | TAX_ACC_BASIS | TEXT1 | TEXT50 | CHAR | 50 | 0 | Text | ||
6 | BUTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
7 | STRAS_GP | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
8 | ORT01_GP | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
9 | PSTLZ_BAS | PSTLZ_BAS | PSTLZ | CHAR | 10 | 0 | Postal code | ||
10 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
11 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
12 | START_DATE | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
13 | END_DATE | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
14 | CURR_CODE | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
15 | DATE_CREATED | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
16 | PRODUCTCOMPANYTAXID | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
17 | SOFTWARECERTIFICATENUMBER | TEXT1 | TEXT50 | CHAR | 50 | 0 | Text | ||
18 | COMPONENT | DLVUNIT | DLVUNIT | CHAR | 30 | 0 | Software Component | * | |
19 | R3RELEASE | SAPRELEASE | CHAR10 | CHAR | 10 | 0 | SAP Release | ||
20 | RACCT | RACCT | SAKNR | CHAR | 10 | 0 | Account Number | * | |
21 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
22 | ACC_DESC | TXT50 | TEXT50 | CHAR | 50 | 0 | Text | ||
23 | OPEN_DEBIT_BAL | WERTV8 | WERTV8 | CURR | 15 | 2 | 8(15)-character value field with 2 decimal places | ||
24 | OPEN_CREDIT_BAL | WERTV8 | WERTV8 | CURR | 15 | 2 | 8(15)-character value field with 2 decimal places | ||
25 | KUNNR | CHAR | 30 | 0 | |||||
26 | RECON_ACCT | RACCT | SAKNR | CHAR | 10 | 0 | Account Number | * | |
27 | CSTCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
28 | CNAME1_GP | CHAR | 40 | 0 | |||||
29 | CCONTACT | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
30 | CNAME1 | CHAR | 50 | 0 | |||||
31 | CSTRAS | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
32 | CORT01 | CHAR | 50 | 0 | |||||
33 | CPSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
34 | CLAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
35 | CSHP_STRAS | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
36 | CSHP_ORT01 | CHAR | 50 | 0 | |||||
37 | CSHP_PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
38 | CSHP_LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
39 | CTELF1 | TELF1 | TEXT16 | CHAR | 16 | 0 | First telephone number | ||
40 | CTELFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
41 | CAD_SMTPADR | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
42 | CAD_URI | AD_URI | AD_URI | LCHR | 2048 | 0 | Universal Resource Identifier (URI) | ||
43 | SELFBILLINGIND | S_INDICATOR | CHAR1 | CHAR | 1 | 0 | SelfBilling Indicator | ||
44 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
45 | SSTCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
46 | NAME1_GP | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
47 | SKNVK | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
48 | SSTRAS | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
49 | SORT01 | TEXT50 | TEXT50 | CHAR | 50 | 0 | Text Field | ||
50 | SPSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
51 | SLAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
52 | SSHP_STRAS | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
53 | SSHP_ORT01 | ORT01 | TEXT25 | CHAR | 25 | 0 | City | ||
54 | SSHP_PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
55 | SSHP_LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
56 | STELF1 | TELF1 | TEXT16 | CHAR | 16 | 0 | First telephone number | ||
57 | STELFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
58 | SAD_SMTPADR | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
59 | SAD_URI | AD_URI | AD_URI | LCHR | 2048 | 0 | Universal Resource Identifier (URI) | ||
60 | MTREF | MTREF | MAREF | CHAR | 4 | 0 | Reference material type | ||
61 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
62 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
63 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
64 | EAN11 | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
65 | MD_TAX_TYPE | TAXTYPE_PT | TEXT10 | CHAR | 10 | 0 | Tax Type | ||
66 | MD_TAX_DESC1 | TEXT255 | TEXT255 | CHAR | 255 | 0 | Text, 255 Characters | ||
67 | TAX_CODE_DETAILS | TEXT1 | TEXT50 | CHAR | 50 | 0 | Text | ||
68 | MD_TAXCOUNTRYREGION | TAXCOUN_REG | PT_REGION | CHAR | 5 | 0 | Country or Region | ||
69 | MD_TAX_CODE | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
70 | MD_TAX_DESC2 | TEXT255 | TEXT255 | CHAR | 255 | 0 | Text, 255 Characters | ||
71 | MD_TAX_PERCNTG | TXW_KBETR | CHAR16 | CHAR | 16 | 0 | Rate (condition amount or percentage) | ||
72 | MD_TAX_AMOUNT | LWSTE_BSET | WERT7 | CURR | 13 | 2 | Tax Amount in Country Currency | ||
73 | MD_TAX_EXEMPT_REASON | EXEMPTREASON | EXEMPTREASON | CHAR | 60 | 0 | Tax Exemption Reason | ||
74 | MD_TAX_EXP_DATE | TAXEXPDATE | DATS | DATS | 8 | 0 | Tax Expiry Date | ||
75 | NO_OF_ENTRIES | TEXT10 | TEXT10 | CHAR | 10 | 0 | Text (10 Characters) | ||
76 | TOTAL_DEBIT | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
77 | TOTAL_CREDIT | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
78 | JOURNAL_ID | BLART | BLART | CHAR | 2 | 0 | Document type | * | |
79 | JR_DESC | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
80 | GL_DESC | LTEXT | TEXT40 | CHAR | 40 | 0 | Long Text | ||
81 | BELNR | PTTRANSID | PTTRANSID | CHAR | 70 | 0 | SAFT_PT: Transaction ID (G/L) | ||
82 | MONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
83 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
84 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
85 | SR_DESC | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
86 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
87 | TRANS_TYPE | PT_TRANSTYPE | TRANSTYP | CHAR | 1 | 0 | SAFT PT: G/L Transaction Type | ||
88 | DOCARCHIVALNUMBER | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
89 | GLLIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
90 | GLSGTXT | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
91 | GLVBELN | PT_TEXT | TEXT30 | CHAR | 30 | 0 | Long Text | ||
92 | GLHKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
93 | GLBUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
94 | GLSHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
95 | GLKUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
96 | GLTOTAL_LINES | TEXT10 | TEXT10 | CHAR | 10 | 0 | Text (10 Characters) | ||
97 | GLDEBIT_AMT | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
98 | GLCREDIT_AMT | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
99 | GL_SYS_ENDAT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
100 | POST_DT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
101 | SD_NO_OF_ENTRIES | TEXT1 | TEXT50 | CHAR | 50 | 0 | Text | ||
102 | SD_TOTAL_DEBIT | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
103 | SD_TOTAL_CREDIT | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
104 | FKART | FKART | FKART | CHAR | 4 | 0 | Billing Type | * | |
105 | INV_NO | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
106 | INV_STAT | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
107 | INV_PERIOD | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
108 | HASH | TEXT200 | TEXT200 | CHAR | 200 | 0 | Text for translation | ||
109 | HASHCONTROL | TEXT200 | TEXT200 | CHAR | 200 | 0 | Text for translation | ||
110 | FKDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
111 | INV_TYPE | CHAR2 | CHAR2 | CHAR | 2 | 0 | Version Number Component | ||
112 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
113 | FKSTO | FKSTO | XFELD | CHAR | 1 | 0 | Billing document is cancelled | ||
114 | PTTRANSID | PTTRANSID | PTTRANSID | CHAR | 70 | 0 | SAFT_PT: Transaction ID (G/L) | ||
115 | KUNAG | CHAR | 30 | 0 | |||||
116 | ST_VBELN | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
117 | ST_LFDAT | LFDAT_V | DATUM | DATS | 8 | 0 | Delivery Date | ||
118 | ST_STRAS | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
119 | ST_ORT01 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
120 | ST_PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
121 | ST_LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
122 | SF_VBELN | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
123 | SF_LFDAT | LFDAT_V | DATUM | DATS | 8 | 0 | Delivery Date | ||
124 | SF_STRAS | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
125 | SF_ORT01 | ORT01 | TEXT25 | CHAR | 25 | 0 | City | ||
126 | SF_PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
127 | SF_LAND1 | ALAND | LAND1 | CHAR | 3 | 0 | Departure country (country from which the goods are sent) | * | |
128 | LINE | TEXT10 | TEXT10 | CHAR | 10 | 0 | Text (10 Characters) | ||
129 | POSNR | POSNR | POSNR | NUMC | 6 | 0 | Item number of the SD document | * | |
130 | ORG_ON | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | * | |
131 | AUDAT | AUDAT | DATUM | DATS | 8 | 0 | Document Date (Date Received/Sent) | ||
132 | SD_MATNR | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
133 | SD_ARKTX | CHAR | 60 | 0 | |||||
134 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
135 | FKIMG | FKIMG | MENG13 | QUAN | 13 | 3 | Actual billed quantity | ||
136 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
137 | TXW_NETBTR | TXW_NETBTR | CHAR16 | CHAR | 16 | 0 | Net value of the order item in document currency | ||
138 | TAX_POINT_DATE | AUDAT | DATUM | DATS | 8 | 0 | Document Date (Date Received/Sent) | ||
139 | SD_DESC | ARKTX | TEXT40 | CHAR | 40 | 0 | Short text for sales order item | ||
140 | SD_DR_AMOUNT | WERTV8 | WERTV8 | CURR | 15 | 2 | 8(15)-character value field with 2 decimal places | ||
141 | SD_CR_AMOUNT | WERTV8 | WERTV8 | CURR | 15 | 2 | 8(15)-character value field with 2 decimal places | ||
142 | TXW_MWSBP | WERTV8 | WERTV8 | CURR | 15 | 2 | 8(15)-character value field with 2 decimal places | ||
143 | EXTGRUNO | EXTGRUNO | EXTGRUNO | CHAR | 10 | 0 | External Group Number for Tax Amounts | * | |
144 | TAX_CODE | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
145 | SDTAX_PERCENT | KBETR | WERTV6 | CURR | 11 | 2 | Rate (condition amount or percentage) | ||
146 | LIN_SET_AMOUNT | KWERT | WERTV7 | CURR | 13 | 2 | Condition Value | ||
147 | DOC_TOTAL | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
148 | TAX_PAYABLE | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
149 | NET_TOTAL | WERTV8 | WERTV8 | CURR | 15 | 2 | 8(15)-character value field with 2 decimal places | ||
150 | GROSS_TOTAL | WERTV8 | WERTV8 | CURR | 15 | 2 | 8(15)-character value field with 2 decimal places | ||
151 | CURRENCY | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
152 | CURRENCY_CODE | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
153 | CURR_CR_AMOUNT | NETWR | WERTV8 | CURR | 15 | 2 | Net Value in Document Currency | ||
154 | CURR_DR_AMOUNT | NETWR | WERTV8 | CURR | 15 | 2 | Net Value in Document Currency | ||
155 | TERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
156 | SETTLE_DISCOUNT | TEXT1 | TEXT50 | CHAR | 50 | 0 | Text | ||
157 | SETTLE_AMOUNT | KWERT | WERTV7 | CURR | 13 | 2 | Condition Value | ||
158 | LSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | * | |
159 | SD_SETL_DATE | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
160 | SD_PAY_MECH | CHAR2 | CHAR2 | CHAR | 2 | 0 | Version Number Component | ||
161 | SDRFE_CREDNOTE | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
162 | SD_CREDREF | TEXT10 | TEXT10 | CHAR | 10 | 0 | Text (10 Characters) | ||
163 | SDREF_REASON | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
164 | KLAND_NAME | LANDX50 | TEXT50 | CHAR | 50 | 0 | Country Name (Max. 50 Characters) | ||
165 | VLAND_NAME | LANDX50 | TEXT50 | CHAR | 50 | 0 | Country Name (Max. 50 Characters) | ||
166 | POSTL_CODE | TEXT20 | TEXT20 | CHAR | 20 | 0 | Text (20 Characters) | ||
167 | COUNTRY | TEXT20 | TEXT20 | CHAR | 20 | 0 | Text (20 Characters) | ||
168 | SLAND_NAME | LANDX50 | TEXT50 | CHAR | 50 | 0 | Country Name (Max. 50 Characters) | ||
169 | MOV_START_TIME | DATUM | DATUM | DATS | 8 | 0 | Date | ||
170 | MOV_END_TIME | DATUM | DATUM | DATS | 8 | 0 | Date | ||
171 | ATDOCCODEID | TEXT200 | TEXT200 | CHAR | 200 | 0 | Text for translation | ||
172 | STATE_CHANGE_RSN | TEXT50 | TEXT50 | CHAR | 50 | 0 | Text Field | ||
173 | WTH_TAXTYPE | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
174 | WTH_AMOUNT | WT_BS | WERTV8 | CURR | 15 | 2 | Withholding tax base amount (local currency) | ||
175 | WTH_DESC | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
176 | EXCH_RATE | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
177 | CLOSE_DEBIT_BAL | WERTV8 | WERTV8 | CURR | 15 | 2 | 8(15)-character value field with 2 decimal places | ||
178 | CLOSE_CREDIT_BAL | WERTV8 | WERTV8 | CURR | 15 | 2 | 8(15)-character value field with 2 decimal places | ||
179 | GRP_CODE | CHAR | 6 | 0 | |||||
180 | GRP_CATG | CHAR | 2 | 0 |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 605 |