SAP ABAP Table CIAP_D_RECORD (CIAP Record)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI-LOC (Application Component) Localization
     ⤷ INT_TMF_CIAP (Package) TMF Integration Features: CIAP

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CIAP_D_RECORD	Table Relationship Diagram
Short Description	CIAP Record

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	*
2	ID	☑	CIAP_RECORD_ID		RAW	16	0	CIAP Record Unique ID
3	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	BRANCH	☐	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
5	MATERIAL_NUMBER	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	CREATION_DATE	☐	CIAP_CREATION_DATE	DATUM	DATS	8	0	CIAP Creation Date
7	STATUS	☐	CIAP_RECORD_STATUS	CIAP_RECORD_STATUS	CHAR	2	0	CIAP record status
8	QUOTAS_QUANTITY	☐	CIAP_QUOTA_NUMBER	CIAP_QUOTA_NUMBER	NUMC	2	0	CIAP quota number
9	LAST_DETERMINATION	☐	CIAP_PERIOD	MCPERIOD	NUMC	6	0	Period (month/year) in which the record was created
10	WBS	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
11	INTERNAL_ORDER	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
12	FINAL_ASSET	☐	FLAG	FLAG	CHAR	1	0	General Flag
13	ASSET_ID	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
14	ASSET_SUBNUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
15	GOODS_VALUE	☐	CIAP_GOODS_VALUE	CIAP_VALUE	CURR	22	10	CIAP goods value
16	CREDIT_FACTOR	☐	CIAP_CREDIT_FACTOR		DEC	5	4	CIAP Credit Factor
17	ICMS_BASE	☐	CIAP_ICMS_BASE	CIAP_VALUE	CURR	22	10	CIAP ICMS tax base
18	ICMS_VALUE	☐	CIAP_ICMS_VALUE	CIAP_VALUE	CURR	22	10	CIAP ICMS Value
19	ICMS_SUB_TRIB	☐	CIAP_SUB_TRIB_VALUE	CIAP_VALUE	CURR	22	10	CIAP "Substituição Tributária" Value
20	ICMS_DIFAL	☐	CIAP_DIFAL_VALUE	CIAP_VALUE	CURR	22	10	CIAP DIFAL Value
21	ICMS_FREIGHT_VALUE	☐	CIAP_FREIGHT_ICMS_VALUE	CIAP_VALUE	CURR	22	10	CIAP Freight ICMS Value
22	ICMS_FREIGHT_SUB_TRIB	☐	CIAP_SUB_TRIB_VALUE	CIAP_VALUE	CURR	22	10	CIAP "Substituição Tributária" Value
23	ICMS_FREIGHT_DIFAL	☐	CIAP_DIFAL_VALUE	CIAP_VALUE	CURR	22	10	CIAP DIFAL Value
24	ICMS_TOTAL	☐	CIAP_ICMS_TOTAL_VALUE	CIAP_VALUE	CURR	22	10	CIAP ICMS Total Value
25	ICMS_TO_CREDIT	☐	CIAP_ICMS_TO_CREDIT	CIAP_VALUE	CURR	22	10	CIAP ICMS to credit value
26	ICMS_NOT_CREDITED	☐	CIAP_ICMS_NOT_CREDITED	CIAP_VALUE	CURR	22	10	CIAP ICMS Not Credited
27	ICMS_CREDITED	☐	CIAP_ICMS_CREDITED	CIAP_VALUE	CURR	22	10	CIAP ICMS credited value
28	CURRENCY	☐	CIAP_CURRENCY	WAERS	CUKY	5	0	Currency used in CIAP.	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CIAP_D_RECORD	ASSET_ID	ANLH	ANLN1	KEY	1	CN
2	CIAP_D_RECORD	ASSET_SUBNUMBER	ANLA	ANLN2	KEY	1	CN
3	CIAP_D_RECORD	BRANCH	J_1BBRANCH	BRANCH	KEY	1	CN
4	CIAP_D_RECORD	COMPANY_CODE	T001	BUKRS	KEY	1	CN
5	CIAP_D_RECORD	CURRENCY	TCURC	WAERS	KEY	1	CN
6	CIAP_D_RECORD	INTERNAL_ORDER	AUFK	AUFNR	KEY	1	CN
7	CIAP_D_RECORD	MATERIAL_NUMBER	MARA	MATNR	KEY	1	CN
8	CIAP_D_RECORD	WBS	PRPS	PSPNR	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in