SAP ABAP Table STR_CIAP (Contains a complete CIAP dataset)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-CIAP-BR (Package) CIAP solution for Brasil

Basic Data

Table Category	INTTAB	Structure
Structure	STR_CIAP	Table Relationship Diagram
Short Description	Contains a complete CIAP dataset

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	CIAP_DATA_KEY
2	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
3	DOCNUM	☐	J_1BDOCNUM	J_1BDOCNUM	NUMC	10	0	Document Number	J_1BNFDOC
4	ITMNUM	☐	J_1BITMNUM	J_1BITMNUM	NUMC	6	0	Document Item Number
5	TAXTYP	☐	J_1BTAXTYP	J_1BTAXTYP	CHAR	4	0	Tax Type	J_1BAJ
6	SERNO	☐	J_1BSERNO		NUMC	4	0	CIAP Document Number
7	.INCLUDE	☐				0	0	Stores the CIAP relevant line data
8	CIAP_VALUE_START	☐	J_1BCIAP_VALUE_START	DATUM	DATS	8	0	Start Date of CIAP Value in Current CIAP Document
9	CIAP_VALUE_STOP	☐	J_1BCIAP_VALUE_STOP	DATUM	DATS	8	0	End Date of CIAP Value in Current CIAP Document
10	CIAP_START_DATE	☐	J_1BCIAP_CIAP_START	DATUM	DATS	8	0	Initial Start Date of the Current CIAP Object
11	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
12	TAXVAL	☐	J_1B_CIAP_TAXVAL	J_1BTAXVAL	CURR	15	2	Tax Value
13	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
14	RET_SALE_LOSS	☐	J_1BCIAP_RET_SALE_LOSS	J_1BCIAP_RET_SALE_LOSS	CHAR	2	0	Describes how a CIAP object was deactivated
15	.INCLUDE	☐				0	0	What and where is the CIAP object currently?
16	KNTYP	☐	J_1BKNTYP		CHAR	35	0	Object Assignment Type
17	CONDNO	☐	J_1BCIAPCNT	J_1BCIAPCNT	NUMC	2	0	CIAP Condition Number
18	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
19	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
21	BRANCH	☐	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	*
22	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
24	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
25	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
26	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
27	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
28	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
29	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
30	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
31	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
32	KOART	☐	KOART	KOART	CHAR	1	0	Account type
33	SUP_KEY_TYPES1	☐	SUP_KEY_TYPES1	J_1BCIAPOBJ	CHAR	10	0	Additional Key 1
34	SUP_KEY_VALUE1	☐	SUP_KEY_VALUE1	J_1BCIAPVAL	CHAR	25	0	Value for Additional Key 1
35	SUP_KEY_TYPES2	☐	SUP_KEY_TYPES2	J_1BCIAPOBJ	CHAR	10	0	Additional Key 2
36	SUP_KEY_VALUE2	☐	SUP_KEY_VALUE2	J_1BCIAPVAL	CHAR	25	0	Value for Additional Key 2
37	.INCLUDE	☐				0	0	Ciap document data
38	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
39	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
40	BU_TM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
41	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
42	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
43	ERDTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
44	UPNAM	☐	UPNAM	USNAM	CHAR	12	0	Last Changed By
45	UPDDT	☐	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update
46	UPDTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
47	VORGN	☐	VORGN	VORGN	CHAR	4	0	Transaction Type for General Ledger
48	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	TSTC
49	BWASL	☐	BWASL	BWASL	CHAR	3	0	Asset Transaction Type	*
50	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
51	BELNR	☐	AWREF	AWREF	CHAR	10	0	Reference document number
52	LFDNR	☐	LFDNR4	NUMC4	NUMC	4	0	Sequence number (four characters)
53	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
54	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
55	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
56	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
57	AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
58	DOCREF	☐	J_1BDOCREF	J_1BDOCNUM	NUMC	10	0	Reference to NF	*
59	ITMREF	☐	J_1BITMREF	J_1BITMNUM	NUMC	6	0	Reference to item number (Return)
60	REFTYP	☐	J_1BREFTYP	J_1BREFTYP	CHAR	2	0	Reference type	*
61	REFKEY	☐	J_1BREFKEY	J_1BREFKEY	CHAR	35	0	Reference to source document
62	REFITM	☐	J_1BREFITM	J_1BREFITM	NUMC	6	0	Reference item to source document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	STR_CIAP	ANLN1	ANLH	ANLN1
2	STR_CIAP	ANLN2	ANLA	ANLN2
3	STR_CIAP	AUFNR	AUFK	AUFNR
4	STR_CIAP	BUKRS	T001	BUKRS
5	STR_CIAP	BWART	T156	BWART
6	STR_CIAP	DOCNUM	J_1BNFDOC	DOCNUM
7	STR_CIAP	GSBER	TGSB	GSBER
8	STR_CIAP	KOKRS	TKA01	KOKRS
9	STR_CIAP	KOSTL	CSKS	KOSTL
10	STR_CIAP	MATNR	MARA	MATNR
11	STR_CIAP	NPLNR	AUFK	AUFNR
12	STR_CIAP	PRCTR	CEPC	PRCTR
13	STR_CIAP	PSPNR	PRPS	PSPNR
14	STR_CIAP	TAXTYP	J_1BAJ	TAXTYP
15	STR_CIAP	TCODE	TSTC	TCODE
16	STR_CIAP	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C