SAP ABAP Table FIAPPTD_BALANCE (Table to store the Balances for Vendor/Customer/Bank Account)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-PT (Package) Add-On Development - FI - Portugal

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FIAPPTD_BALANCE	Table Relationship Diagram
Short Description	Table to store the Balances for Vendor/Customer/Bank Account

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	REPORTING_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	PERIOD	☑	MONTH12	MONTH12	NUMC	2	0	Month
5	RUN_ID	☑	FIAPPT_RUN_ID	FIAPPT_RUN_ID	CHAR	20	0	Run ID	FIAPPTD_RUNID
6	ACCOUNT	☑	FIAPPT_ACCOUNT_NO	MAXKK	CHAR	10	0	Account Number
7	KOART	☑	KOART	KOART	CHAR	1	0	Account type
8	WAERS	☑	WAERS	WAERS	CUKY	5	0	Currency Key	*
9	WRBTR	☐	FIAPPT_AMOUNT	FIAPPT_AMOUNT	CURR	24	2	Amount
10	ORIGIN_RUN_ID	☐	FIAPPT_RUN_ID	FIAPPT_RUN_ID	CHAR	20	0	Run ID
11	REFERENCE_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
12	REGISTER_ID	☐	FIAPPT_REG_ID	FIAPPT_REG_ID	CHAR	1	0	ID of the Register
13	SCB_IND	☐	FIAPPT_SCB_IND	FIAPPT_SCB_IND	CHAR	5	0	SCB Indicator
14	NPC2	☐	FIAPPT_NPC2	FIAPPT_NPC2	NUMC	9	0	Entity ID
15	VALUE_TYPE	☐	FIAPPT_VALUE_TYPE	FIAPPT_VALUE_TYPE	CHAR	1	0	CBR Value Type
16	BANK_ACC_TYPE	☐	FIAPPT_BANK_ACC_TYPE	FIAPPT_BANK_ACC_TYPE	CHAR	1	0	Bank Account Type
17	BANK_ID	☐	FIAPPT_BANKID	CHAR4	CHAR	4	0	Bank ID
18	PAIS_CONTA	☐	FIAPPT_PAIS_CONTA	INTCA3	CHAR	3	0	Foreign Account Country
19	PAIS_CONTRAPARTE	☐	FIAPPT_PAIS_CONTRAPARTE	INTCA3	CHAR	3	0	Customer/Vendor Country
20	PAIS_ATIVO	☐	FIAPPT_PAIS_ATIVO	INTCA3	CHAR	3	0	Financial Active Entity
21	DUE_DATE	☐	FIAPPT_DUEDATE	DATS	DATS	8	0	Due Date
22	STCEG	☐	FIAPPT_VAT_REG_NO	STCEG	CHAR	20	0	Counterpart ID or VAT Registration Number
23	OBSERVATIONS	☐	FIAPPT_TEXT	CHAR120	CHAR	120	0	Observations
24	ISOCD	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FIAPPTD_BALANCE	BUKRS	T001	BUKRS
2	FIAPPTD_BALANCE	MANDT	T000	MANDT
3	FIAPPTD_BALANCE	RUN_ID	FIAPPTD_RUNID	RUN_ID

History

Last changed by/on	SAP	20131127
SAP Release Created in