Table/Structure Field list used by SAP ABAP Program IDGTCN_SALES_ORDER (Get Data from Sales Orders for GTI File Generation)
SAP ABAP Program
IDGTCN_SALES_ORDER (Get Data from Sales Orders for GTI File Generation) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ADRC - ADDRNUMBER | Address number | ||
| 2 | ADRC - CITY1 | City | ||
| 3 | ADRC - COUNTRY | Country Key | ||
| 4 | ADRC - HOUSE_NUM1 | House Number | ||
| 5 | ADRC - NAME1 | Name 1 | ||
| 6 | ADRC - NAME2 | Name 2 | ||
| 7 | ADRC - REGION | Region (State, Province, County) | ||
| 8 | ADRC - STREET | Street | ||
| 9 | ADRC - TEL_NUMBER | First telephone no.: dialling code+number | ||
| 10 | BAPIRET2 - ID | Message Class | ||
| 11 | BAPIRET2 - LOG_NO | Application log: log number | ||
| 12 | BAPIRET2 - MESSAGE | Message Text | ||
| 13 | BAPIRET2 - MESSAGE_V1 | Message Variable | ||
| 14 | BAPIRET2 - NUMBER | Message Number | ||
| 15 | BAPIRET2 - TYPE | Message type: S Success, E Error, W Warning, I Info, A Abort | ||
| 16 | BNKA - BANKA | Name of bank | ||
| 17 | BNKA - BANKL | Bank Keys | ||
| 18 | BNKA - BANKS | Bank country key | ||
| 19 | BNKA - BRNCH | Bank Branch | ||
| 20 | EMARA - GROES | Size/dimensions | ||
| 21 | IDGT_CODE_LC - GTCPDE | Tax Catalog Code | ||
| 22 | IDGT_CODE_LC - MATNR | Material Number | ||
| 23 | IDGT_CODE_LC - MWSKZ | Tax Code | ||
| 24 | IDGT_CUSTTYPE - CTYPE | VAT Invoice Type | ||
| 25 | IDGT_CUSTTYPE - KUNNR | Customer Number | ||
| 26 | IDGT_GTDH - KSTRAS | Address | ||
| 27 | IDGT_GTDM - GTKEY1 | GTI Multiple Data Key 1 | ||
| 28 | IDGT_INFO - MAKTX | Material Description | ||
| 29 | IDGT_INFO - MSPEC | Material Specification | ||
| 30 | IDGT_INFO_LC_APPEND1 - MAKTX | Material Description | ||
| 31 | IDGT_INFO_LC_APPEND1 - MSPEC | Material Specification | ||
| 32 | IDGT_OB_CTRL - COLLE | Receiver | ||
| 33 | IDGT_OB_CTRL - CT_VAT | Condition Type | ||
| 34 | IDGT_OB_CTRL - VERIF | User Name | ||
| 35 | IDGT_S_HEADER - BUKRS | Company Code | ||
| 36 | IDGT_S_HEADER - CTYPE | VAT Invoice Type | ||
| 37 | IDGT_S_HEADER - CURRENCY | Currency Key | ||
| 38 | IDGT_S_HEADER - CUSNAM | User name | ||
| 39 | IDGT_S_HEADER - GTKEY1 | GTI Multiple Data Key 1 | ||
| 40 | IDGT_S_HEADER - GTOTYPE | Source Document Type | ||
| 41 | IDGT_S_HEADER - KBANKA | Bank Account | ||
| 42 | IDGT_S_HEADER - KNAME1 | Customer Name | ||
| 43 | IDGT_S_HEADER - KSTCD5 | Tax Number 5 | ||
| 44 | IDGT_S_HEADER - KSTRAS | Address | ||
| 45 | IDGT_S_HEADER - KUNNR | Customer Number | ||
| 46 | IDGT_S_HEADER - NETWR_DOC | Net Value in Document Currency | ||
| 47 | IDGT_S_HEADER - SENTDATE | Date: Invoice sent to GT | ||
| 48 | IDGT_S_HEADER - USERNAME | Created By | ||
| 49 | IDGT_S_HEADER - VBELN | Sales and Distribution Document Number | ||
| 50 | IDGT_S_HEADER - VUSNAM | User name | ||
| 51 | IDGT_S_ITEM - FKIMG | Billed Quantity | ||
| 52 | IDGT_S_ITEM - GTKEY1 | GTI Multiple Data Key 1 | ||
| 53 | IDGT_S_ITEM - GTOTYPE | Source Document Type | ||
| 54 | IDGT_S_ITEM - MAKTX | Material Description | ||
| 55 | IDGT_S_ITEM - MATNR | Material Number | ||
| 56 | IDGT_S_ITEM - MEINS | Base Unit of Measure | ||
| 57 | IDGT_S_ITEM - MSPEC | Material Specification | ||
| 58 | IDGT_S_ITEM - NETWR | Net Value | ||
| 59 | IDGT_S_ITEM - PEMOD | Price Mode | ||
| 60 | IDGT_S_ITEM - POSNR | Item Number | ||
| 61 | IDGT_S_ITEM - TAXAMT | Tax Amount | ||
| 62 | IDGT_S_ITEM - TAXCOD | Tax Catalog Code | ||
| 63 | IDGT_S_ITEM - TAXRATE | VAT Tax Rate | ||
| 64 | IDGT_S_ITEM - UNITPE | Unit Price | ||
| 65 | IDGT_S_ITEM - UOMDESC | Unit Measurement Desc. | ||
| 66 | IDGT_S_ITEM - VBELN | Sales and Distribution Document Number | ||
| 67 | IDGT_S_ITEM - VFPOS | Billing item | ||
| 68 | IDGT_S_MUTIL_KEY - GTKEY1 | GTI Multiple Data Key 1 | ||
| 69 | IDGT_S_MUTIL_KEY - GTOTYPE | Source Document Type | ||
| 70 | KNA1 - ADRNR | Address | ||
| 71 | KNA1 - KUNNR | Customer Number | ||
| 72 | KNA1 - NAME1 | Name 1 | ||
| 73 | KNA1 - NAME2 | Name 2 | ||
| 74 | KNA1 - STCD1 | Tax Number 1 | ||
| 75 | KNA1 - STCD5 | Tax Number 5 | ||
| 76 | KNA1 - XCPDK | Indicator: Is the account a one-time account? | ||
| 77 | KNBK - BANKL | Bank Keys | ||
| 78 | KNBK - BANKN | Bank account number | ||
| 79 | KNBK - BANKS | Bank country key | ||
| 80 | KNBK - BKREF | Reference specifications for bank details | ||
| 81 | KNBK - KUNNR | Customer Number | ||
| 82 | KONV - KBETR | Rate (condition amount or percentage) | ||
| 83 | KONV - KNUMV | Number of the document condition | ||
| 84 | KONV - KPOSN | Condition Item Number | ||
| 85 | KONV - KSCHL | Condition Type | ||
| 86 | KONV - KWERT | Condition Value | ||
| 87 | KONV - MWSK1 | Tax on sales/purchases code | ||
| 88 | MAKT - MAKTX | Material description | ||
| 89 | MAKT - MATNR | Material Number | ||
| 90 | MAKT - SPRAS | Language Key | ||
| 91 | MARA - GROES | Size/dimensions | ||
| 92 | MARA - MATNR | Material Number | ||
| 93 | RSDSSELOPT - LOW | 'Generic' SELECT-OPTION for Dynamic Selections | ||
| 94 | RSDSSELOPT - OPTION | ABAP: Selection option (EQ/BT/CP/...) | ||
| 95 | RSDSSELOPT - SIGN | ABAP: ID: I/E (include/exclude values) | ||
| 96 | SI_KNA1 - STCD1 | Tax Number 1 | ||
| 97 | SI_KNA1 - STCD5 | Tax Number 5 | ||
| 98 | SYST - LANGU | ABAP System Field: Language Key of Text Environment | ||
| 99 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 100 | SYST - UNAME | ABAP System Field: Name of Current User | ||
| 101 | T005U - BEZEI | Description | ||
| 102 | T005U - BLAND | Region (State, Province, County) | ||
| 103 | T005U - LAND1 | Country Key | ||
| 104 | T005U - SPRAS | Language Key | ||
| 105 | T006A - MSEHI | Unit of Measurement | ||
| 106 | T006A - SPRAS | Language Key | ||
| 107 | TVKO - VKORG | Sales Organization | ||
| 108 | VBAK - AUART | Sales Document Type | ||
| 109 | VBAK - BUKRS_VF | Company code to be billed | ||
| 110 | VBAK - ERDAT | Date on which the record was created | ||
| 111 | VBAK - ERNAM | Name of Person who Created the Object | ||
| 112 | VBAK - KNUMV | Number of the document condition | ||
| 113 | VBAK - KUNNR | Sold-to party | ||
| 114 | VBAK - NETWR | Net Value of the Sales Order in Document Currency | ||
| 115 | VBAK - SPART | Division | ||
| 116 | VBAK - VBELN | Sales Document | ||
| 117 | VBAK - VKORG | Sales Organization | ||
| 118 | VBAK - VTWEG | Distribution Channel | ||
| 119 | VBAK - WAERK | SD document currency | ||
| 120 | VBAP - KWMENG | Cumulative order quantity in sales units | ||
| 121 | VBAP - MATNR | Material Number | ||
| 122 | VBAP - NETPR | Net price | ||
| 123 | VBAP - NETWR | Net value of the order item in document currency | ||
| 124 | VBAP - POSNR | Sales Document Item | ||
| 125 | VBAP - SHKZG | Returns Item | ||
| 126 | VBAP - VBELN | Sales Document | ||
| 127 | VBAP - VRKME | Sales unit | ||
| 128 | VBPA - ADRNR | Address | ||
| 129 | VBPA - KUNNR | Customer Number | ||
| 130 | VBPA - PARVW | Partner Role | ||
| 131 | VBPA - POSNR | Item number of the SD document | ||
| 132 | VBPA - VBELN | Sales and Distribution Document Number | ||
| 133 | VBRK - KUNRG | Payer |