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 |