FIAPPTD_TRANS

Table to store the transaction details of the CBR PT | #transactional | Component: Financials Portugal
Column Name Description
MANDT FK Client
BUKRS FK Company Code
BELNR Document Number of an Accounting Document
DOC_YEAR Fiscal Year
BUZEI Number of Line Item Within Accounting Document
PERIOD Fiscal period
RUN_ID FK Run ID
PAY_DOC Document Number of an Accounting Document
PAY_DOC_YEAR Fiscal Year
Column Name Description
💲 Currency Key (BKPF.WAERS):
WRBTR Amount in document currency
Column Name Description
Column Name Description
REFERENCE_DATE Posting Date in the Document
DUE_DATE Due Date
Column Name Description
KOART Account type Show values
REGISTER_ID ID of the Register Show values
VALUE_TYPE CBR Value Type Show values
BANK_ACC_TYPE Bank Account Type Show values
Column Name Description Domain name
ACCOUNT Account Number MAXKK
ORIGIN_RUN_ID Run ID FIAPPT_RUN_ID
REPORTING_YEAR Fiscal Year GJAHR
NPC2 Entity ID FIAPPT_NPC2
SCB_IND SCB Indicator FIAPPT_SCB_IND
BANK_ID Bank ID CHAR4
PAIS_CONTA Foreign Account Country/Region INTCA3
PAIS_CONTRAPARTE Customer/Vendor Country/Region INTCA3
PAIS_ATIVO Financial Active Entity INTCA3
STCEG Counterpart ID or VAT Registration Number STCEG
OBSERVATIONS Observations CHAR120
ISOCD ISO currency code ISOCD
Master Data Relations Join Conditions
Company Code
  • FIAPPTD_TRANS.MANDT == T001.MANDT
  • FIAPPTD_TRANS.BUKRS == T001.BUKRS
Client FIAPPTD_TRANS.MANDT == T000.MANDT