Table/Structure Field list used by SAP ABAP Function Module IDMX_DI_FI_DATA_EXTRACT (Generate Extract for FI digital invoice)
SAP ABAP Function Module
IDMX_DI_FI_DATA_EXTRACT (Generate Extract for FI digital invoice) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ADRC - CITY1 | City | ||
| 2 | ADRC - CITY2 | District | ||
| 3 | ADRC - COUNTRY | Country Key | ||
| 4 | ADRC - HOUSE_NUM1 | House Number | ||
| 5 | ADRC - HOUSE_NUM2 | House number supplement | ||
| 6 | ADRC - NAME1 | Name 1 | ||
| 7 | ADRC - NAME2 | Name 2 | ||
| 8 | ADRC - NATION | Version ID for International Addresses | ||
| 9 | ADRC - POST_CODE1 | City postal code | ||
| 10 | ADRC - REGION | Region (State, Province, County) | ||
| 11 | ADRC - STREET | Street | ||
| 12 | ADRC - STR_SUPPL3 | Street 4 | ||
| 13 | BKPF - AWKEY | Object key | ||
| 14 | BKPF - AWTYP | Reference procedure | ||
| 15 | BKPF - BELNR | Accounting Document Number | ||
| 16 | BKPF - BLART | Document type | ||
| 17 | BKPF - BUKRS | Company Code | ||
| 18 | BKPF - CPUDT | Accounting document entry date | ||
| 19 | BKPF - CPUTM | Time of data entry | ||
| 20 | BKPF - GJAHR | Fiscal Year | ||
| 21 | BKPF - KURSF | Exchange rate | ||
| 22 | BKPF - WAERS | Currency Key | ||
| 23 | BKPF - XBLNR | Reference Document Number | ||
| 24 | BKPF - XMWST | Calculate tax automatically | ||
| 25 | BSEC - BELNR | Accounting Document Number | ||
| 26 | BSEC - BUKRS | Company Code | ||
| 27 | BSEC - BUZEI | Number of Line Item Within Accounting Document | ||
| 28 | BSEC - GJAHR | Fiscal Year | ||
| 29 | BSEC - LAND1 | Country Key | ||
| 30 | BSEC - NAME1 | Name 1 | ||
| 31 | BSEC - NAME2 | Name 2 | ||
| 32 | BSEC - ORT01 | City | ||
| 33 | BSEC - PSTLZ | Postal Code | ||
| 34 | BSEC - REGIO | Region (State, Province, County) | ||
| 35 | BSEC - STCD1 | Tax Number 1 | ||
| 36 | BSEC - STRAS | House number and street | ||
| 37 | BSEG - BELNR | Accounting Document Number | ||
| 38 | BSEG - BUKRS | Company Code | ||
| 39 | BSEG - BUZEI | Number of Line Item Within Accounting Document | ||
| 40 | BSEG - GJAHR | Fiscal Year | ||
| 41 | BSEG - KOART | Account type | ||
| 42 | BSEG - KUNNR | Customer Number | ||
| 43 | BSEG - MWSKZ | Tax on sales/purchases code | ||
| 44 | BSEG - REBZG | Number of the Invoice the Transaction Belongs to | ||
| 45 | BSEG - REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
| 46 | BSEG - REBZT | Follow-On Document Type | ||
| 47 | BSEG - SGTXT | Item Text | ||
| 48 | BSEG - WRBTR | Amount in document currency | ||
| 49 | BSEG - ZLSCH | Payment Method | ||
| 50 | BSEG - ZUONR | Assignment number | ||
| 51 | BSET - BELNR | Accounting Document Number | ||
| 52 | BSET - BUKRS | Company Code | ||
| 53 | BSET - FWSTE | Tax Amount in Document Currency | ||
| 54 | BSET - GJAHR | Fiscal Year | ||
| 55 | BSET - KBETR | Tax Rate | ||
| 56 | BSET - MWSKZ | Tax on sales/purchases code | ||
| 57 | IDMX_DI_ACCOUNT_TYP - COUNTRY | Country Key | ||
| 58 | IDMX_DI_ACCOUNT_TYP - MEANS_OF_PAYMENT | Name of Payment Method in Language of the Country | ||
| 59 | IDMX_DI_ACCOUNT_TYP - PAYMENT_KEY | Payment Method | ||
| 60 | IDMX_DI_CMPNY_ADDRESS_DATA_TYP - CMPNY_2ND_DISTRICT | IDMX_DI_CMPNY_ADDRESS_DATA_TYP-CMPNY_2ND_DISTRICT | ||
| 61 | IDMX_DI_CMPNY_ADDRESS_DATA_TYP - CMPNY_2ND_HOUSE_NUM | IDMX_DI_CMPNY_ADDRESS_DATA_TYP-CMPNY_2ND_HOUSE_NUM | ||
| 62 | IDMX_DI_CMPNY_ADDRESS_DATA_TYP - CMPNY_CITY | IDMX_DI_CMPNY_ADDRESS_DATA_TYP-CMPNY_CITY | ||
| 63 | IDMX_DI_CMPNY_ADDRESS_DATA_TYP - CMPNY_COUNTRY | IDMX_DI_CMPNY_ADDRESS_DATA_TYP-CMPNY_COUNTRY | ||
| 64 | IDMX_DI_CMPNY_ADDRESS_DATA_TYP - CMPNY_DISTRICT | IDMX_DI_CMPNY_ADDRESS_DATA_TYP-CMPNY_DISTRICT | ||
| 65 | IDMX_DI_CMPNY_ADDRESS_DATA_TYP - CMPNY_HOUSE_NUM | IDMX_DI_CMPNY_ADDRESS_DATA_TYP-CMPNY_HOUSE_NUM | ||
| 66 | IDMX_DI_CMPNY_ADDRESS_DATA_TYP - CMPNY_POST_CODE | IDMX_DI_CMPNY_ADDRESS_DATA_TYP-CMPNY_POST_CODE | ||
| 67 | IDMX_DI_CMPNY_ADDRESS_DATA_TYP - CMPNY_STATE | IDMX_DI_CMPNY_ADDRESS_DATA_TYP-CMPNY_STATE | ||
| 68 | IDMX_DI_CMPNY_ADDRESS_DATA_TYP - CMPNY_STREET | IDMX_DI_CMPNY_ADDRESS_DATA_TYP-CMPNY_STREET | ||
| 69 | IDMX_DI_CMPNY_GLOBAL_DATA_TYP - CMPNY_NAME | (2.b) Company Code Name | ||
| 70 | IDMX_DI_CMPNY_GLOBAL_DATA_TYP - CMPNY_TAX_N | (2.a) Tax Number of Company Code | ||
| 71 | IDMX_DI_COMPL_DOC_DATA_TYP - COMPL_DOC_DATA | IDMX_DI_COMPL_DOC_DATA_TYP-COMPL_DOC_DATA | ||
| 72 | IDMX_DI_CUSTOMS_DATA_TYP - CUST_DOC | IDMX_DI_CUSTOMS_DATA_TYP-CUST_DOC | ||
| 73 | IDMX_DI_CUSTOMS_DATA_TYP - DATE_DOC_ISSUED | IDMX_DI_CUSTOMS_DATA_TYP-DATE_DOC_ISSUED | ||
| 74 | IDMX_DI_CUSTOMS_DATA_TYP - OFFICE_DOC_ISSUED | IDMX_DI_CUSTOMS_DATA_TYP-OFFICE_DOC_ISSUED | ||
| 75 | IDMX_DI_C_ADDRESS_DATA_TYP - CUST_2ND_DISTRICT | IDMX_DI_C_ADDRESS_DATA_TYP-CUST_2ND_DISTRICT | ||
| 76 | IDMX_DI_C_ADDRESS_DATA_TYP - CUST_2ND_HOUSE_NUM | IDMX_DI_C_ADDRESS_DATA_TYP-CUST_2ND_HOUSE_NUM | ||
| 77 | IDMX_DI_C_ADDRESS_DATA_TYP - CUST_CITY | IDMX_DI_C_ADDRESS_DATA_TYP-CUST_CITY | ||
| 78 | IDMX_DI_C_ADDRESS_DATA_TYP - CUST_COUNTRY | IDMX_DI_C_ADDRESS_DATA_TYP-CUST_COUNTRY | ||
| 79 | IDMX_DI_C_ADDRESS_DATA_TYP - CUST_DISTRICT | IDMX_DI_C_ADDRESS_DATA_TYP-CUST_DISTRICT | ||
| 80 | IDMX_DI_C_ADDRESS_DATA_TYP - CUST_HOUSE_NUM | IDMX_DI_C_ADDRESS_DATA_TYP-CUST_HOUSE_NUM | ||
| 81 | IDMX_DI_C_ADDRESS_DATA_TYP - CUST_POST_CODE | IDMX_DI_C_ADDRESS_DATA_TYP-CUST_POST_CODE | ||
| 82 | IDMX_DI_C_ADDRESS_DATA_TYP - CUST_STATE | IDMX_DI_C_ADDRESS_DATA_TYP-CUST_STATE | ||
| 83 | IDMX_DI_C_ADDRESS_DATA_TYP - CUST_STREET | IDMX_DI_C_ADDRESS_DATA_TYP-CUST_STREET | ||
| 84 | IDMX_DI_C_IDENT_DATA_TYP - CUST_NAME | (6.b) Customer Identification Data, Name | ||
| 85 | IDMX_DI_C_IDENT_DATA_TYP - CUST_TAX_NUM | (6.a) Customer Identification Data, Tax Number | ||
| 86 | IDMX_DI_DOCUMENT_DATA_TYP - ACCOUNT_NUMBER | (1.o) Account Number | ||
| 87 | IDMX_DI_DOCUMENT_DATA_TYP - APPROV_NUM | (1.e) Approval Number for Official Document Numbering | ||
| 88 | IDMX_DI_DOCUMENT_DATA_TYP - APPROV_YEAR | (1.f) Approval Year for Official Document Numbering | ||
| 89 | IDMX_DI_DOCUMENT_DATA_TYP - CURRENCY | (1.q) Document Currency | ||
| 90 | IDMX_DI_DOCUMENT_DATA_TYP - DISCOUNT | (1.k) Discount Amount in Document Currency | ||
| 91 | IDMX_DI_DOCUMENT_DATA_TYP - DOC_TYPE | (1.g) Document Type for Payment Flow | ||
| 92 | IDMX_DI_DOCUMENT_DATA_TYP - EXCHANGE_RATE | (1.p) Exchange Rate for Document Currency | ||
| 93 | IDMX_DI_DOCUMENT_DATA_TYP - INST_ORI_AMOUNT | (1.u) Installment Data, Original Amount | ||
| 94 | IDMX_DI_DOCUMENT_DATA_TYP - INST_ORI_DATE | (1.t) Installment Data, Original Date | ||
| 95 | IDMX_DI_DOCUMENT_DATA_TYP - INST_ORI_FOLIO | (1.r) Installment Data, Original Folio | ||
| 96 | IDMX_DI_DOCUMENT_DATA_TYP - INST_ORI_PREFIX | (1.s) Installment Data, Original Prefix | ||
| 97 | IDMX_DI_DOCUMENT_DATA_TYP - INV_DATE_TIME | (1.d) Time Stamp for Moment of Billing (ISO 8601) | ||
| 98 | IDMX_DI_DOCUMENT_DATA_TYP - ISSUING_PLACE | (1.n) Location/Place Where the Document was Issued | ||
| 99 | IDMX_DI_DOCUMENT_DATA_TYP - OFF_DOC_NUM | (1.c) Sequential Number of Official Document Number | ||
| 100 | IDMX_DI_DOCUMENT_DATA_TYP - OFF_DOC_PRE | (1.b) Prefix of Official Document Number | ||
| 101 | IDMX_DI_DOCUMENT_DATA_TYP - PAYM_MEANS | (1.m) Means of Payment of Transaction | ||
| 102 | IDMX_DI_DOCUMENT_DATA_TYP - PAYM_METHD | (1.h) Payment Method / Installment | ||
| 103 | IDMX_DI_DOCUMENT_DATA_TYP - PAYM_TERMS | (1.i) Payment Terms | ||
| 104 | IDMX_DI_DOCUMENT_DATA_TYP - SUB_TOTAL | (1.j) Subtotal Amount in Document Currency | ||
| 105 | IDMX_DI_DOCUMENT_DATA_TYP - TOTAL | (1.l) Total Amount in Document Currency | ||
| 106 | IDMX_DI_DOCUMENT_DATA_TYP - VERSION_XML | (1.a) XML/DI/CFD Version | ||
| 107 | IDMX_DI_FIITEM_COMPLEMENTO_TYP - BELNR | Accounting Document Number | ||
| 108 | IDMX_DI_FIITEM_COMPLEMENTO_TYP - BUKRS | Company Code | ||
| 109 | IDMX_DI_FIITEM_COMPLEMENTO_TYP - BUZEI | Number of Line Item Within Accounting Document | ||
| 110 | IDMX_DI_FIITEM_COMPLEMENTO_TYP - COMPLEMENTO | (11.) Supplement Data of Line Item | ||
| 111 | IDMX_DI_FIITEM_COMPLEMENTO_TYP - GJAHR | Fiscal Year | ||
| 112 | IDMX_DI_FIITEM_CUSTOMS_TYP - BELNR | Accounting Document Number | ||
| 113 | IDMX_DI_FIITEM_CUSTOMS_TYP - BUKRS | Company Code | ||
| 114 | IDMX_DI_FIITEM_CUSTOMS_TYP - BUZEI | Number of Line Item Within Accounting Document | ||
| 115 | IDMX_DI_FIITEM_CUSTOMS_TYP - CUSTOMS_DOC_DATE | Field of type DATS | ||
| 116 | IDMX_DI_FIITEM_CUSTOMS_TYP - CUSTOMS_DOC_NR | Char 20 | ||
| 117 | IDMX_DI_FIITEM_CUSTOMS_TYP - CUSTOMS_OFFICE | Char 80 | ||
| 118 | IDMX_DI_FIITEM_CUSTOMS_TYP - GJAHR | Fiscal Year | ||
| 119 | IDMX_DI_FIITEM_PROP_ACCT_TYP - BELNR | Accounting Document Number | ||
| 120 | IDMX_DI_FIITEM_PROP_ACCT_TYP - BUKRS | Company Code | ||
| 121 | IDMX_DI_FIITEM_PROP_ACCT_TYP - BUZEI | Number of Line Item Within Accounting Document | ||
| 122 | IDMX_DI_FIITEM_PROP_ACCT_TYP - GJAHR | Fiscal Year | ||
| 123 | IDMX_DI_FIITEM_PROP_ACCT_TYP - PROPERTY_ACCOUNT_NR | Comment | ||
| 124 | IDMX_DI_FISCAL_REGIME_TYP - TAX_REGIME | (5.a) Tax Regime of Document Issuer | ||
| 125 | IDMX_DI_LINE_ITEMS_TYP - AMOUNT_NET | (8.f) Goods/Services Sold, Line Item's Total Net Amount | ||
| 126 | IDMX_DI_LINE_ITEMS_TYP - COMPL_GOODS | (11.) Supplement Data of Line Item | ||
| 127 | IDMX_DI_LINE_ITEMS_TYP - CUSTOMS_DATA | IDMX_DI_LINE_ITEMS_TYP-CUSTOMS_DATA | ||
| 128 | IDMX_DI_LINE_ITEMS_TYP - DESCRIPT | (8.d) Goods/Services Sold, Description | ||
| 129 | IDMX_DI_LINE_ITEMS_TYP - ID_NUMBER | (8.c) Goods/Services Sold, Ident number / Material ID | ||
| 130 | IDMX_DI_LINE_ITEMS_TYP - PROP_AC_NUM | (10.a) Property Account Data, Property Account number | ||
| 131 | IDMX_DI_LINE_ITEMS_TYP - QUANTITY | (8.a) Goods/Services Sold, Quantity | ||
| 132 | IDMX_DI_LINE_ITEMS_TYP - UNIT_MEASURE | (8.b) Goods/Services Sold, Unit of Measure | ||
| 133 | IDMX_DI_LINE_ITEMS_TYP - UNIT_PRICE | (8.e) Goods/Services Sold, Line Item's Unit Price | ||
| 134 | IDMX_DI_ORI_IN_MSG_TYPE - CMPNY_ADDRESS_DATA | IDMX_DI_ORI_IN_MSG_TYPE-CMPNY_ADDRESS_DATA | ||
| 135 | IDMX_DI_ORI_IN_MSG_TYPE - CMPNY_GLOBAL_DATA | IDMX_DI_ORI_IN_MSG_TYPE-CMPNY_GLOBAL_DATA | ||
| 136 | IDMX_DI_ORI_IN_MSG_TYPE - COMPL_DOC_DATA | IDMX_DI_ORI_IN_MSG_TYPE-COMPL_DOC_DATA | ||
| 137 | IDMX_DI_ORI_IN_MSG_TYPE - C_ADDRESS_DATA | IDMX_DI_ORI_IN_MSG_TYPE-C_ADDRESS_DATA | ||
| 138 | IDMX_DI_ORI_IN_MSG_TYPE - C_IDENT_DATA | IDMX_DI_ORI_IN_MSG_TYPE-C_IDENT_DATA | ||
| 139 | IDMX_DI_ORI_IN_MSG_TYPE - DOCUMENT_DATA | IDMX_DI_ORI_IN_MSG_TYPE-DOCUMENT_DATA | ||
| 140 | IDMX_DI_ORI_IN_MSG_TYPE - FISCAL_REG_DATA | IDMX_DI_ORI_IN_MSG_TYPE-FISCAL_REG_DATA | ||
| 141 | IDMX_DI_ORI_IN_MSG_TYPE - SO_ADDRESS_DATA | IDMX_DI_ORI_IN_MSG_TYPE-SO_ADDRESS_DATA | ||
| 142 | IDMX_DI_ORI_IN_MSG_TYPE - TOTAL_TAXES | IDMX_DI_ORI_IN_MSG_TYPE-TOTAL_TAXES | ||
| 143 | IDMX_DI_ORI_IN_MSG_TYPE - WA_LINE_ITEMS | IDMX_DI_ORI_IN_MSG_TYPE-WA_LINE_ITEMS | ||
| 144 | IDMX_DI_ORI_IN_MSG_TYPE - WA_TAXES | IDMX_DI_ORI_IN_MSG_TYPE-WA_TAXES | ||
| 145 | IDMX_DI_SO_ADDRESS_DATA_TYP - SO_2ND_DISTRICT | IDMX_DI_SO_ADDRESS_DATA_TYP-SO_2ND_DISTRICT | ||
| 146 | IDMX_DI_SO_ADDRESS_DATA_TYP - SO_2ND_HOUSE_NUM | IDMX_DI_SO_ADDRESS_DATA_TYP-SO_2ND_HOUSE_NUM | ||
| 147 | IDMX_DI_SO_ADDRESS_DATA_TYP - SO_CITY | IDMX_DI_SO_ADDRESS_DATA_TYP-SO_CITY | ||
| 148 | IDMX_DI_SO_ADDRESS_DATA_TYP - SO_COUNTRY | IDMX_DI_SO_ADDRESS_DATA_TYP-SO_COUNTRY | ||
| 149 | IDMX_DI_SO_ADDRESS_DATA_TYP - SO_DISTRICT | IDMX_DI_SO_ADDRESS_DATA_TYP-SO_DISTRICT | ||
| 150 | IDMX_DI_SO_ADDRESS_DATA_TYP - SO_HOUSE_NUM | IDMX_DI_SO_ADDRESS_DATA_TYP-SO_HOUSE_NUM | ||
| 151 | IDMX_DI_SO_ADDRESS_DATA_TYP - SO_POST_CODE | IDMX_DI_SO_ADDRESS_DATA_TYP-SO_POST_CODE | ||
| 152 | IDMX_DI_SO_ADDRESS_DATA_TYP - SO_STATE | IDMX_DI_SO_ADDRESS_DATA_TYP-SO_STATE | ||
| 153 | IDMX_DI_SO_ADDRESS_DATA_TYP - SO_STREET | IDMX_DI_SO_ADDRESS_DATA_TYP-SO_STREET | ||
| 154 | IDMX_DI_TAXES - AWTYP | Object Type | ||
| 155 | IDMX_DI_TAXES - KVSL1 | Account key | ||
| 156 | IDMX_DI_TAXES - KVSL1_CODE | (13.a) Taxes, Legal Tax Abbreviation | ||
| 157 | IDMX_DI_TAXES_TYP - TAX_AMOUNT | (13.c) Taxes, Tax Amount | ||
| 158 | IDMX_DI_TAXES_TYP - TAX_RATE | (13.b) Taxes, Tax Rate | ||
| 159 | IDMX_DI_TAXES_TYP - TAX_TYPE | (13.a) Taxes, Legal Tax Abbreviation | ||
| 160 | IDMX_DI_TAXREG - T001Z_PAVAL | Internal key for Legal Tax Regime String | ||
| 161 | IDMX_DI_TAXREG - TAX_REGIME_TEXT | (5.a) Tax Regime of Document Issuer | ||
| 162 | IDMX_DI_TAX_TYP - KBETR | Rate (condition amount or percentage) | ||
| 163 | IDMX_DI_TAX_TYP - KSCHL | Condition Type | ||
| 164 | IDMX_DI_TAX_TYP - KTOSL | Transaction Key | ||
| 165 | IDMX_DI_TAX_TYP - WMWST | Tax amount in document currency | ||
| 166 | IDMX_DI_TOTAL_TAXES_TYP - TOTAL_TAXES_AMOUNT | (13.d) Taxes, Total Tax Amount | ||
| 167 | IDMX_DI_TXTIDDET - AWTYP | Object Type | ||
| 168 | IDMX_DI_TXTIDDET - DATAID | Data ID | ||
| 169 | IDMX_DI_TXTIDDET - TDID | Text ID | ||
| 170 | IDMX_DI_TXTIDDET - TDOBJECT | Texts: application object | ||
| 171 | KNA1 - ADRNR | Address | ||
| 172 | KNA1 - KUNNR | Customer Number | ||
| 173 | KNA1 - STCD1 | Tax Number 1 | ||
| 174 | SI_KNA1 - STCD1 | Tax Number 1 | ||
| 175 | SYST - MANDT | ABAP System Field: Client ID of Current User | ||
| 176 | SYST - MSGID | ABAP System Field: Message ID | ||
| 177 | SYST - MSGNO | ABAP System Field: Message Number | ||
| 178 | SYST - MSGTY | ABAP System Field: Message Type | ||
| 179 | SYST - MSGV1 | ABAP System Field: Message Variable | ||
| 180 | SYST - MSGV2 | ABAP System Field: Message Variable | ||
| 181 | SYST - MSGV3 | ABAP System Field: Message Variable | ||
| 182 | SYST - MSGV4 | ABAP System Field: Message Variable | ||
| 183 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 184 | T001 - ADRNR | Address | ||
| 185 | T001 - BUKRS | Company Code | ||
| 186 | T001 - LAND1 | Country Key | ||
| 187 | T001 - SPRAS | Language Key | ||
| 188 | T001Z - BUKRS | Company Code | ||
| 189 | T001Z - PARTY | Parameter type | ||
| 190 | T001Z - PAVAL | Parameter value | ||
| 191 | T005 - INTCA | Country ISO code | ||
| 192 | T005 - LAND1 | Country Key | ||
| 193 | T005T - LAND1 | Country Key | ||
| 194 | T005T - LANDX | Country Name | ||
| 195 | T005T - SPRAS | Language Key | ||
| 196 | T005U - BEZEI | Description | ||
| 197 | T005U - BLAND | Region (State, Province, County) | ||
| 198 | T005U - LAND1 | Country Key | ||
| 199 | T005U - SPRAS | Language Key | ||
| 200 | TVZBT - SPRAS | Language Key | ||
| 201 | TVZBT - VTEXT | Description of terms of payment | ||
| 202 | TVZBT - ZTERM | Terms of payment key | ||
| 203 | VBRK - BUKRS | Company Code | ||
| 204 | VBRK - ERDAT | Date on which the record was created | ||
| 205 | VBRK - FKART | Billing Type | ||
| 206 | VBRK - NETWR | Net Value in Document Currency | ||
| 207 | VBRK - VBELN | Billing document | ||
| 208 | VBRK - VKORG | Sales Organization | ||
| 209 | VBRK - XBLNR | Reference Document Number |