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 |