SAP ABAP Table FIAPPTD_TRANS (Table to store the transaction details of the CBR PT)

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_TRANS	Table Relationship Diagram
Short Description	Table to store the transaction details of the CBR PT

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	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	DOC_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
6	PERIOD	☑	MONTH12	MONTH12	NUMC	2	0	Month
7	RUN_ID	☑	FIAPPT_RUN_ID	FIAPPT_RUN_ID	CHAR	20	0	Run ID	FIAPPTD_RUNID
8	PAY_DOC	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
9	PAY_DOC_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
10	ACCOUNT	☐	FIAPPT_ACCOUNT_NO	MAXKK	CHAR	10	0	Account Number
11	KOART	☐	KOART	KOART	CHAR	1	0	Account type
12	ORIGIN_RUN_ID	☐	FIAPPT_RUN_ID	FIAPPT_RUN_ID	CHAR	20	0	Run ID
13	REPORTING_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
14	REFERENCE_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
15	REGISTER_ID	☐	FIAPPT_REG_ID	FIAPPT_REG_ID	CHAR	1	0	ID of the Register
16	NPC2	☐	FIAPPT_NPC2	FIAPPT_NPC2	NUMC	9	0	Entity ID
17	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
19	SCB_IND	☐	FIAPPT_SCB_IND	FIAPPT_SCB_IND	CHAR	5	0	SCB Indicator
20	VALUE_TYPE	☐	FIAPPT_VALUE_TYPE	FIAPPT_VALUE_TYPE	CHAR	1	0	CBR Value Type
21	BANK_ACC_TYPE	☐	FIAPPT_BANK_ACC_TYPE	FIAPPT_BANK_ACC_TYPE	CHAR	1	0	Bank Account Type
22	BANK_ID	☐	FIAPPT_BANKID	CHAR4	CHAR	4	0	Bank ID
23	PAIS_CONTA	☐	FIAPPT_PAIS_CONTA	INTCA3	CHAR	3	0	Foreign Account Country
24	PAIS_CONTRAPARTE	☐	FIAPPT_PAIS_CONTRAPARTE	INTCA3	CHAR	3	0	Customer/Vendor Country
25	PAIS_ATIVO	☐	FIAPPT_PAIS_ATIVO	INTCA3	CHAR	3	0	Financial Active Entity
26	DUE_DATE	☐	FIAPPT_DUEDATE	DATS	DATS	8	0	Due Date
27	STCEG	☐	FIAPPT_VAT_REG_NO	STCEG	CHAR	20	0	Counterpart ID or VAT Registration Number
28	OBSERVATIONS	☐	FIAPPT_TEXT	CHAR120	CHAR	120	0	Observations
29	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_TRANS	BUKRS	T001	BUKRS
2	FIAPPTD_TRANS	MANDT	T000	MANDT
3	FIAPPTD_TRANS	RUN_ID	FIAPPTD_RUNID	RUN_ID

History

Last changed by/on	SAP	20131127
SAP Release Created in