FIAPPTD_BALANCE

Table to store the Balances for Vendor/Customer/Bank Account | #transactional | Component: Financials Portugal
Column Name Description
MANDT FK Client
BUKRS FK Company Code
REPORTING_YEAR Fiscal Year
PERIOD Fiscal period
RUN_ID FK Run ID
ACCOUNT Account Number
KOART Account type Show values
WAERS Currency Key
Column Name Description
💲 Currency Key (WAERS):
WRBTR Amount
Column Name Description
Column Name Description
REFERENCE_DATE Document Date in 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
ORIGIN_RUN_ID Run ID FIAPPT_RUN_ID
SCB_IND SCB Indicator FIAPPT_SCB_IND
NPC2 Entity ID FIAPPT_NPC2
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_BALANCE.MANDT == T001.MANDT
  • FIAPPTD_BALANCE.BUKRS == T001.BUKRS
Client FIAPPTD_BALANCE.MANDT == T000.MANDT