CFIN_EX_AIFROOT - Generated table:CFIN_EX_AIFROOT
Generated table:CFIN_EX_AIFROOT information is stored in SAP table CFIN_EX_AIFROOT.
It is part of development package FINS_CFIN_EX_INTERFACE in software component FI-CF-EX. This development package consists of objects that can be grouped under "Central Finance - External Interface (3rd Party)".
It is part of development package FINS_CFIN_EX_INTERFACE in software component FI-CF-EX. This development package consists of objects that can be grouped under "Central Finance - External Interface (3rd Party)".
Fields for table CFIN_EX_AIFROOT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | /AIF/STRUC_PERS_GENERAL | X | /AIF/STRUC_PERS_GENERAL | 0 | ||
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| MSGGUID | GUID in 'CHAR' Format in Uppercase | X | GUID_32 | CHAR | 64 | |
| VERSION | Defines the version of a message in the persistence layer | X | /AIF/PERS_MESSAGE_VERSION | NUMC | 6 | |
| COUNTER | Structured Persistence Parent ID | X | /AIF/PERS_ROW_ID | INT4 | 4 | |
| .INCLUDE | AIFKEYS | X | /AIF/IFKEYS | 0 | ||
| NS | Namespace | X | /AIF/NS | CHAR | 12 | /AIF/T_NS |
| IFNAME | Interface Name | X | /AIF/IFNAME | CHAR | 20 | /AIF/T_FINF |
| IFVER | Interface Version | X | /AIF/IFVERSION | CHAR | 10 | /AIF/T_FINF |
| PARENT_ID | Structured Persistence Parent ID | /AIF/PERS_ROW_ID | INT4 | 4 | ||
| STATUS | Status for persistency engine | /AIF/PERS_XML_STATUS_E | NUMC | 4 | ||
| CREATE_USER | Create User | /AIF/CREATE_USER | CHAR | 24 | ||
| CREATE_DATE | Creation Date | /AIF/CREATE_DATE | DATS | 16 | ||
| CREATE_TIME | Creation Time | /AIF/CREATE_TIME | TIMS | 12 | ||
| SKIP_MAPPING | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 2 | ||
| PROCESSING_MODE | CFIN: Processing Mode | FINS_CFIN_PROCESSING_MODE | NUMC | 4 | ||
| UNIQUE_ID | Unique ID | FINS_CFIN_EX_UNIQUE_DOC_ID | CHAR | 64 | ||
| ACCOUNTING_LOGSY | Logical System of the Sender | LOGSYSTEM_SENDER | CHAR | 20 | ||
| OBJECT_LOGSYS | Logical system of source document | AWSYS | CHAR | 20 | ||
| OBJECT_KEY | Reference Key | AWKEY | CHAR | 40 | ||
| REFERENCE_DOCUME | Reference Document Number | XBLNR | CHAR | 32 | ||
| BUSINESS_ACTIVIT | Business Transaction | GLVOR | CHAR | 8 | ||
| DOCUMENT_TYPE | Document Type | BLART | CHAR | 4 | ||
| PREDECESSOR_REFE | Invoice Ref.: Object Key (AWREF_REB and AWORG_REB) | AWKEY_REB | CHAR | 40 | ||
| HEADER_TXT | Document Header Text | BKTXT | CHAR | 50 | ||
| DOCUMENT_DATE | Document Date in Document | BLDAT | DATS | 16 | ||
| POSTING_DATE | Posting Date in the Document | BUDAT | DATS | 16 | ||
| PRDTAX_REPORTING | Tax Reporting Date | VATDATE | DATS | 16 | ||
| INVOICE_RECEIPT | Invoice Receipt Date | REINDAT | DATS | 16 | ||
| TRANSLATION_DATE | Translation date | WWERT_D | DATS | 16 | ||
| EXCHANGE_RATE | Exchange rate | KURSF | DEC | 5 | ||
| COMP_CODE | Company Code | BUKRS | CHAR | 8 | ||
| FISCAL_YEAR | Fiscal Year of an Accounting Document in the Sender System | GJAHR_SENDER | NUMC | 8 | ||
| FISCAL_PERIOD | Fiscal period | MONAT | NUMC | 4 | ||
| ACCOUNTING_DOC_N | Document Number of an Accounting Document in Sender System | BELNR_SENDER | CHAR | 20 | ||
| USERNAME | User Name | USNAM | CHAR | 24 | ||
| CREATE_TIMESTAMP | CFIN: UTC timestamp when transfer record was created | FIN_CFIN_TRANSFER_TIMESTAMP | DEC | 11 | ||
| OBJECT_KEY_REVER | Cancel: object key (AWREF_REV and AWORG_REV) | AWKEY_REV | CHAR | 40 | ||
| REASON_REVERSAL | Reason for Reversal or Inverse Posting | STGRD | CHAR | 4 | ||
| CLEARING_DATE | Clearing Date | AUGDT | DATS | 16 | ||
| TRANSACTION_TYPE | Transaction Type for External Interface Documents | FINS_CFIN_EX_TRANSACTION_TYPE | CHAR | 2 | ||
| LEDGER_GROUP | Ledger Group | FAGL_LDGRP | CHAR | 8 | ||
| OBJECT_TYPE | Reference procedure | AWTYP | CHAR | 10 | ||
| GLO_REFERENCE | Country/Region Specific Reference 1 in the Document | FAC_GLO_REF1_HD | CHAR | 160 | ||
| GLO_DATE | Country/Region Specific Date 1 in the Document | FAC_GLO_DAT1_HD | DATS | 16 | ||
| GLO_REFERENCE_2 | Country/Region Specific Reference 2 in the Document | FAC_GLO_REF2_HD | CHAR | 50 | ||
| GLO_DATE_2 | Country/Region Specific Date 2 in the Document | FAC_GLO_DAT2_HD | DATS | 16 | ||
| GLO_REFERENCE_3 | Country/Region Specific Reference 3 in the Document | FAC_GLO_REF3_HD | CHAR | 50 | ||
| GLO_DATE_3 | Country/Region Specific Date 3 in the Document | FAC_GLO_DAT3_HD | DATS | 16 | ||
| GLO_REFERENCE_4 | Country/Region Specific Reference 4 in the Document | FAC_GLO_REF4_HD | CHAR | 100 | ||
| GLO_DATE_4 | Country/Region Specific Date 4 in the Document | FAC_GLO_DAT4_HD | DATS | 16 | ||
| GLO_REFERENCE_5 | Country/Region Specific Reference 5 in the Document | FAC_GLO_REF5_HD | CHAR | 100 | ||
| GLO_DATE_5 | Country/Region Specific Date 5 in the Document | FAC_GLO_DAT5_HD | DATS | 16 | ||
| GLO_BUSINESS_PAR | Country/Region specific Business Partner 1 in the Document | FAC_GLO_BP1_HD | CHAR | 20 | ||
| GLO_BUSINESS_P_2 | Country/Region Specific Business Partner 2 in the Document | FAC_GLO_BP2_HD | CHAR | 20 | ||
| UNIQUE_ID_2 | Unique ID | FINS_CFIN_EX_UNIQUE_DOC_ID | CHAR | 64 | ||
| CUST_EXTENSION | Generic Field for Customer Extensibility | FINS_CFIN_EX_CUST_EXTENSION | STRG | 8 | ||
| UNIQUE_ID_3 | Unique ID | FINS_CFIN_EX_UNIQUE_DOC_ID | CHAR | 64 | ||
| ACCOUNTING_LOG_2 | Logical System of the Sender | LOGSYSTEM_SENDER | CHAR | 20 | ||
| OBJECT_LOGSYS_2 | Logical system of source document | AWSYS | CHAR | 20 | ||
| OBJECT_KEY_2 | Reference Key | AWKEY | CHAR | 40 | ||
| REFERENCE_DOCU_2 | Reference Document Number | XBLNR | CHAR | 32 | ||
| BUSINESS_ACTIV_2 | Business Transaction | GLVOR | CHAR | 8 | ||
| DOCUMENT_TYPE_2 | Document Type | BLART | CHAR | 4 | ||
| PREDECESSOR_RE_2 | Invoice Ref.: Object Key (AWREF_REB and AWORG_REB) | AWKEY_REB | CHAR | 40 | ||
| HEADER_TXT_2 | Document Header Text | BKTXT | CHAR | 50 | ||
| DOCUMENT_DATE_2 | Document Date in Document | BLDAT | DATS | 16 | ||
| POSTING_DATE_2 | Posting Date in the Document | BUDAT | DATS | 16 | ||
| PRDTAX_REPORTI_2 | Tax Reporting Date | VATDATE | DATS | 16 | ||
| INVOICE_RECEIP_2 | Invoice Receipt Date | REINDAT | DATS | 16 | ||
| TRANSLATION_DA_2 | Translation date | WWERT_D | DATS | 16 | ||
| EXCHANGE_RATE_2 | Exchange rate | KURSF | DEC | 5 | ||
| COMP_CODE_2 | Company Code | BUKRS | CHAR | 8 | ||
| FISCAL_YEAR_2 | Fiscal Year of an Accounting Document in the Sender System | GJAHR_SENDER | NUMC | 8 | ||
| FISCAL_PERIOD_2 | Fiscal period | MONAT | NUMC | 4 | ||
| ACCOUNTING_DOC_2 | Document Number of an Accounting Document in Sender System | BELNR_SENDER | CHAR | 20 | ||
| USERNAME_2 | User Name | USNAM | CHAR | 24 | ||
| CREATE_TIMESTA_2 | CFIN: UTC timestamp when transfer record was created | FIN_CFIN_TRANSFER_TIMESTAMP | DEC | 11 | ||
| OBJECT_KEY_REV_2 | Cancel: object key (AWREF_REV and AWORG_REV) | AWKEY_REV | CHAR | 40 | ||
| REASON_REVERSA_2 | Reason for Reversal or Inverse Posting | STGRD | CHAR | 4 | ||
| CLEARING_DATE_2 | Clearing Date | AUGDT | DATS | 16 | ||
| TRANSACTION_TY_2 | Transaction Type for External Interface Documents | FINS_CFIN_EX_TRANSACTION_TYPE | CHAR | 2 | ||
| LEDGER_GROUP_2 | Ledger Group | FAGL_LDGRP | CHAR | 8 | ||
| OBJECT_TYPE_2 | Reference procedure | AWTYP | CHAR | 10 | ||
| GLO_REFERENCE_6 | Country/Region Specific Reference 1 in the Document | FAC_GLO_REF1_HD | CHAR | 160 | ||
| GLO_DATE_6 | Country/Region Specific Date 1 in the Document | FAC_GLO_DAT1_HD | DATS | 16 | ||
| GLO_REFERENCE_7 | Country/Region Specific Reference 2 in the Document | FAC_GLO_REF2_HD | CHAR | 50 | ||
| GLO_DATE_7 | Country/Region Specific Date 2 in the Document | FAC_GLO_DAT2_HD | DATS | 16 | ||
| GLO_REFERENCE_8 | Country/Region Specific Reference 3 in the Document | FAC_GLO_REF3_HD | CHAR | 50 | ||
| GLO_DATE_8 | Country/Region Specific Date 3 in the Document | FAC_GLO_DAT3_HD | DATS | 16 | ||
| GLO_REFERENCE_9 | Country/Region Specific Reference 4 in the Document | FAC_GLO_REF4_HD | CHAR | 100 | ||
| GLO_DATE_9 | Country/Region Specific Date 4 in the Document | FAC_GLO_DAT4_HD | DATS | 16 | ||
| GLO_REFERENCE_10 | Country/Region Specific Reference 5 in the Document | FAC_GLO_REF5_HD | CHAR | 100 | ||
| GLO_DATE_10 | Country/Region Specific Date 5 in the Document | FAC_GLO_DAT5_HD | DATS | 16 | ||
| GLO_BUSINESS_P_3 | Country/Region specific Business Partner 1 in the Document | FAC_GLO_BP1_HD | CHAR | 20 | ||
| GLO_BUSINESS_P_4 | Country/Region Specific Business Partner 2 in the Document | FAC_GLO_BP2_HD | CHAR | 20 | ||
| COMP_CODE_SENDER | Company Code in Sender System | BUKRS_SENDER | CHAR | 8 | ||
| UNIQUE_ID_4 | Unique ID | FINS_CFIN_EX_UNIQUE_DOC_ID | CHAR | 64 | ||
| CUST_EXTENSION_2 | Generic Field for Customer Extensibility | FINS_CFIN_EX_CUST_EXTENSION | STRG | 8 |