SAP ABAP Table J_1B_CIAP_OBJECT (CIAP document data)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1B_CIAP_OBJECT	Table Relationship Diagram
Short Description	CIAP document data

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	600