PTDART_ITEMS SAP (DART Fileds : XML file) Structure details
Description: DART Fileds : XML file
Structure field list including key, data, relationships and ABAP select examples
PTDART_ITEMS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DART Fileds : XML file" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_PTDART_ITEMS TYPE PTDART_ITEMS.
The PTDART_ITEMS table consists of various fields, each holding specific information or linking keys about DART Fileds : XML file data available in SAP. These include COMPANY_ID (Text), BUKRS (Company Code), STCEG (VAT Registration Number), TAX_ACC_BASIS (Text).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP PTDART_ITEMS structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
FILE_VERSION | Text | TEXT1 | CHAR | 50 | TEXT50 | ||||
COMPANY_ID | Text | TEXT1 | CHAR | 50 | TEXT50 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
TAX_ACC_BASIS | Text | TEXT1 | CHAR | 50 | TEXT50 | ||||
BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | TEXT25 | ||||
STRAS_GP | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
ORT01_GP | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
PSTLZ_BAS | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
START_DATE | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
END_DATE | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CURR_CODE | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
DATE_CREATED | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
PRODUCTCOMPANYTAXID | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
SOFTWARECERTIFICATENUMBER | Text | TEXT1 | CHAR | 50 | TEXT50 | ||||
COMPONENT | Software Component | DLVUNIT | CHAR | 30 | Assigned to domain | DLVUNIT | H_CVERS | ||
R3RELEASE | SAP Release | SAPRELEASE | CHAR | 10 | CHAR10 | ||||
RACCT | Account Number | RACCT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ACC | |
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
ACC_DESC | Text | TXT50 | CHAR | 50 | TEXT50 | ||||
OPEN_DEBIT_BAL | 8(15)-character value field with 2 decimal places | WERTV8 | CURR | 15(2) | WERTV8 | ||||
OPEN_CREDIT_BAL | 8(15)-character value field with 2 decimal places | WERTV8 | CURR | 15(2) | WERTV8 | ||||
KUNNR | Customer Number | 0 | |||||||
RECON_ACCT | Account Number | RACCT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ACC | |
CSTCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
CNAME1_GP | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
CCONTACT | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
CNAME1 | Name | 0 | |||||||
CSTRAS | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
CORT01 | City | 0 | |||||||
CPSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
CLAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
CSHP_STRAS | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
CSHP_ORT01 | City | 0 | |||||||
CSHP_PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
CSHP_LAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
CTELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
CTELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
CAD_SMTPADR | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
CAD_URI | Universal Resource Identifier (URI) | AD_URI | LCHR | 2048 | AD_URI | ||||
SELFBILLINGIND | SelfBilling Indicator | S_INDICATOR | CHAR | 1 | CHAR1 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
SSTCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
NAME1_GP | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
SKNVK | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
SSTRAS | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
SORT01 | Text Field | TEXT50 | CHAR | 50 | TEXT50 | ||||
SPSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
SLAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
SSHP_STRAS | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
SSHP_ORT01 | City | ORT01 | CHAR | 25 | TEXT25 | ||||
SSHP_PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
SSHP_LAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
STELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
STELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
SAD_SMTPADR | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
SAD_URI | Universal Resource Identifier (URI) | AD_URI | LCHR | 2048 | AD_URI | ||||
MTREF | Reference material type | MTREF | CHAR | 4 | MAREF | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
MD_TAX_TYPE | Tax Type | TAXTYPE_PT | CHAR | 10 | TEXT10 | ||||
MD_TAX_DESC1 | Text, 255 Characters | TEXT255 | CHAR | 255 | TEXT255 | ||||
TAX_CODE_DETAILS | Text | TEXT1 | CHAR | 50 | TEXT50 | ||||
MD_TAXCOUNTRYREGION | Country or Region | TAXCOUN_REG | CHAR | 5 | PT_REGION | ||||
MD_TAX_CODE | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
MD_TAX_DESC2 | Text, 255 Characters | TEXT255 | CHAR | 255 | TEXT255 | ||||
MD_TAX_PERCNTG | Rate (condition amount or percentage) | TXW_KBETR | CHAR | 16 | CHAR16 | ||||
MD_TAX_AMOUNT | Tax Amount in Country Currency | LWSTE_BSET | CURR | 13(2) | WERT7 | ||||
MD_TAX_EXEMPT_REASON | Tax Exemption Reason | EXEMPTREASON | CHAR | 60 | EXEMPTREASON | ||||
MD_TAX_EXP_DATE | Tax Expiry Date | TAXEXPDATE | DATS | 8 | DATS | ||||
NO_OF_ENTRIES | Text (10 Characters) | TEXT10 | CHAR | 10 | TEXT10 | ||||
TOTAL_DEBIT | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
TOTAL_CREDIT | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
JOURNAL_ID | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
JR_DESC | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
GL_DESC | Long Text | LTEXT | CHAR | 40 | TEXT40 | ||||
BELNR | SAFT_PT: Transaction ID (G/L) | PTTRANSID | CHAR | 70 | PTTRANSID | ||||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
USNAM | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
SR_DESC | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
TRANS_TYPE | SAFT_pt: G/L Transaction Type | PT_TRANSTYPE | CHAR | 1 | TRANSTYP | ||||
DOCARCHIVALNUMBER | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GLLIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
GLSGTXT | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
GLVBELN | Long Text | PT_TEXT | CHAR | 30 | TEXT30 | ||||
GLHKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
GLBUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
GLSHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
GLKUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
GLTOTAL_LINES | Text (10 Characters) | TEXT10 | CHAR | 10 | TEXT10 | ||||
GLDEBIT_AMT | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
GLCREDIT_AMT | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
GL_SYS_ENDAT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
POST_DT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
SD_NO_OF_ENTRIES | Text | TEXT1 | CHAR | 50 | TEXT50 | ||||
SD_TOTAL_DEBIT | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
SD_TOTAL_CREDIT | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
FKART | Billing Type | FKART | CHAR | 4 | Assigned to domain | FKART | |||
INV_NO | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
INV_STAT | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
INV_PERIOD | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
HASH | Text for translation | TEXT200 | CHAR | 200 | TEXT200 | ||||
HASHCONTROL | Text for translation | TEXT200 | CHAR | 200 | TEXT200 | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
INV_TYPE | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
FKSTO | Billing document is cancelled | FKSTO | CHAR | 1 | XFELD | ||||
PTTRANSID | SAFT_PT: Transaction ID (G/L) | PTTRANSID | CHAR | 70 | PTTRANSID | ||||
KUNAG | Sold-to Party | 0 | |||||||
ST_VBELN | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
ST_LFDAT | Delivery Date | LFDAT_V | DATS | 8 | DATUM | ||||
ST_STRAS | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
ST_ORT01 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
ST_PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ST_LAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
SF_VBELN | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
SF_LFDAT | Delivery Date | LFDAT_V | DATS | 8 | DATUM | ||||
SF_STRAS | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
SF_ORT01 | City | ORT01 | CHAR | 25 | TEXT25 | ||||
SF_PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
SF_LAND1 | Departure country (country from which the goods are sent) | ALAND | CHAR | 3 | Assigned to domain | LAND1 | VAL | ||
LINE | Text (10 Characters) | TEXT10 | CHAR | 10 | TEXT10 | ||||
POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
ORG_ON | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
SD_MATNR | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
SD_ARKTX | Description | 0 | |||||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FKIMG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TXW_NETBTR | Net value of the order item in document currency | TXW_NETBTR | CHAR | 16 | CHAR16 | ||||
TAX_POINT_DATE | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
SD_DESC | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
SD_DR_AMOUNT | 8(15)-character value field with 2 decimal places | WERTV8 | CURR | 15(2) | WERTV8 | ||||
SD_CR_AMOUNT | 8(15)-character value field with 2 decimal places | WERTV8 | CURR | 15(2) | WERTV8 | ||||
TXW_MWSBP | 8(15)-character value field with 2 decimal places | WERTV8 | CURR | 15(2) | WERTV8 | ||||
EXTGRUNO | External Group Number for Tax Amounts | EXTGRUNO | CHAR | 10 | Assigned to domain | EXTGRUNO | |||
TAX_CODE | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
SDTAX_PERCENT | Rate (condition amount or percentage) | KBETR | CURR | 11(2) | WERTV6 | ||||
LIN_SET_AMOUNT | Condition value | KWERT | CURR | 13(2) | WERTV7 | ||||
DOC_TOTAL | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
TAX_PAYABLE | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
NET_TOTAL | 8(15)-character value field with 2 decimal places | WERTV8 | CURR | 15(2) | WERTV8 | ||||
GROSS_TOTAL | 8(15)-character value field with 2 decimal places | WERTV8 | CURR | 15(2) | WERTV8 | ||||
CURRENCY | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CURRENCY_CODE | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CURR_CR_AMOUNT | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
CURR_DR_AMOUNT | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
TERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
SETTLE_DISCOUNT | Text | TEXT1 | CHAR | 50 | TEXT50 | ||||
SETTLE_AMOUNT | Condition value | KWERT | CURR | 13(2) | WERTV7 | ||||
LSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | Assigned to domain | ZLSCH | |||
SD_SETL_DATE | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
SD_PAY_MECH | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
SDRFE_CREDNOTE | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
SD_CREDREF | Text (10 Characters) | TEXT10 | CHAR | 10 | TEXT10 | ||||
SDREF_REASON | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
KLAND_NAME | Country Name (Max. 50 Characters) | LANDX50 | CHAR | 50 | TEXT50 | ||||
VLAND_NAME | Country Name (Max. 50 Characters) | LANDX50 | CHAR | 50 | TEXT50 | ||||
POSTL_CODE | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
COUNTRY | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
SLAND_NAME | Country Name (Max. 50 Characters) | LANDX50 | CHAR | 50 | TEXT50 | ||||
MOV_START_TIME | Date | DATUM | DATS | 8 | DATUM | ||||
MOV_END_TIME | Date | DATUM | DATS | 8 | DATUM | ||||
ATDOCCODEID | Text for translation | TEXT200 | CHAR | 200 | TEXT200 | ||||
STATE_CHANGE_RSN | Text Field | TEXT50 | CHAR | 50 | TEXT50 | ||||
WTH_TAXTYPE | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
WTH_AMOUNT | Withholding tax base amount (local currency) | WT_BS | CURR | 15(2) | WERTV8 | ||||
WTH_DESC | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
EXCH_RATE | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF |
Key field | Non-key field |
How do I retrieve data from SAP structure PTDART_ITEMS using ABAP code?
As PTDART_ITEMS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PTDART_ITEMS as there is no data to select.How to access SAP table PTDART_ITEMS
Within an ECC or HANA version of SAP you can also view further information about PTDART_ITEMS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects