FIAPPTD_TRANS - Table to store the transaction details of the CBR PT
Table to store the transaction details of the CBR PT information is stored in SAP table FIAPPTD_TRANS.
It is part of development package ID-FI-PT in software component FI-LOC-FI-PT. This development package consists of objects that can be grouped under "Add-On Development - FI - Portugal".
It is part of development package ID-FI-PT in software component FI-LOC-FI-PT. This development package consists of objects that can be grouped under "Add-On Development - FI - Portugal".
Fields for table FIAPPTD_TRANS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
BELNR | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
DOC_YEAR | Fiscal Year | X | GJAHR | NUMC | 8 | |
BUZEI | Number of Line Item Within Accounting Document | X | BUZEI | NUMC | 6 | |
PERIOD | Fiscal period | X | MONAT | NUMC | 4 | |
RUN_ID | Run ID | X | FIAPPT_RUN_ID | CHAR | 40 | FIAPPTD_RUNID |
PAY_DOC | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
PAY_DOC_YEAR | Fiscal Year | X | GJAHR | NUMC | 8 | |
ACCOUNT | Account Number | FIAPPT_ACCOUNT_NO | CHAR | 20 | ||
KOART | Account type | KOART | CHAR | 2 | ||
ORIGIN_RUN_ID | Run ID | FIAPPT_RUN_ID | CHAR | 40 | ||
REPORTING_YEAR | Fiscal Year | GJAHR | NUMC | 8 | ||
REFERENCE_DATE | Posting Date in the Document | BUDAT | DATS | 16 | ||
REGISTER_ID | ID of the Register | FIAPPT_REG_ID | CHAR | 2 | ||
NPC2 | Entity ID | FIAPPT_NPC2 | NUMC | 18 | ||
WRBTR | Amount in document currency | WRBTR | CURR | 12 | ||
WAERS | Currency Key | WAERS | CUKY | 10 | ||
SCB_IND | SCB Indicator | FIAPPT_SCB_IND | CHAR | 10 | ||
VALUE_TYPE | CBR Value Type | FIAPPT_VALUE_TYPE | CHAR | 2 | ||
BANK_ACC_TYPE | Bank Account Type | FIAPPT_BANK_ACC_TYPE | CHAR | 2 | ||
BANK_ID | Bank ID | FIAPPT_BANKID | CHAR | 8 | ||
PAIS_CONTA | Foreign Account Country/Region | FIAPPT_PAIS_CONTA | CHAR | 6 | ||
PAIS_CONTRAPARTE | Customer/Vendor Country/Region | FIAPPT_PAIS_CONTRAPARTE | CHAR | 6 | ||
PAIS_ATIVO | Financial Active Entity | FIAPPT_PAIS_ATIVO | CHAR | 6 | ||
DUE_DATE | Due Date | FIAPPT_DUEDATE | DATS | 16 | ||
STCEG | Counterpart ID or VAT Registration Number | FIAPPT_VAT_REG_NO | CHAR | 40 | ||
OBSERVATIONS | Observations | FIAPPT_TEXT | CHAR | 240 | ||
ISOCD | ISO currency code | ISOCD | CHAR | 6 |