SAP ABAP Table J_1B_CIAPV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	J_1B_CIAPV	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
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	KNTYP	☐	J_1BKNTYP		CHAR	35	0	Object Assignment Type
8	CONDNO	☐	J_1BCIAPCNT	J_1BCIAPCNT	NUMC	2	0	CIAP Condition Number
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code
10	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
11	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
12	BRANCH	☐	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place
13	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
14	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
15	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
16	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
17	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
18	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
19	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
20	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
21	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
22	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
23	KOART	☐	KOART	KOART	CHAR	1	0	Account type
24	SUP_KEY_TYPES1	☐	SUP_KEY_TYPES1	J_1BCIAPOBJ	CHAR	10	0	Additional Key 1
25	SUP_KEY_VALUE1	☐	SUP_KEY_VALUE1	J_1BCIAPVAL	CHAR	25	0	Value for Additional Key 1
26	SUP_KEY_TYPES2	☐	SUP_KEY_TYPES2	J_1BCIAPOBJ	CHAR	10	0	Additional Key 2
27	SUP_KEY_VALUE2	☐	SUP_KEY_VALUE2	J_1BCIAPVAL	CHAR	25	0	Value for Additional Key 2
28	CIAP_VALUE_START	☐	J_1BCIAP_VALUE_START	DATUM	DATS	8	0	Start Date of CIAP Value in Current CIAP Document
29	CIAP_VALUE_STOP	☐	J_1BCIAP_VALUE_STOP	DATUM	DATS	8	0	End Date of CIAP Value in Current CIAP Document
30	CIAP_START_DATE	☐	J_1BCIAP_CIAP_START	DATUM	DATS	8	0	Initial Start Date of the Current CIAP Object
31	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
32	TAXVAL	☐	J_1B_CIAP_TAXVAL	J_1BTAXVAL	CURR	15	2	Tax Value
33	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
34	RET_SALE_LOSS	☐	J_1BCIAP_RET_SALE_LOSS	J_1BCIAP_RET_SALE_LOSS	CHAR	2	0	Describes how a CIAP object was deactivated
35	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
36	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
37	BU_TM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
38	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
39	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
40	ERDTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
41	UPNAM	☐	UPNAM	USNAM	CHAR	12	0	Last Changed By
42	UPDDT	☐	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update
43	UPDTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
44	VORGN	☐	VORGN	VORGN	CHAR	4	0	Transaction Type for General Ledger
45	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	TSTC
46	BWASL	☐	BWASL	BWASL	CHAR	3	0	Asset Transaction Type
47	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
48	BELNR	☐	AWREF	AWREF	CHAR	10	0	Reference document number
49	LFDNR	☐	LFDNR4	NUMC4	NUMC	4	0	Sequence number (four characters)
50	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
51	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
52	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure
53	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
54	AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System
55	DOCREF	☐	J_1BDOCREF	J_1BDOCNUM	NUMC	10	0	Reference to NF
56	ITMREF	☐	J_1BITMREF	J_1BITMNUM	NUMC	6	0	Reference to item number (Return)
57	REFTYP	☐	J_1BREFTYP	J_1BREFTYP	CHAR	2	0	Reference type
58	REFKEY	☐	J_1BREFKEY	J_1BREFKEY	CHAR	35	0	Reference to source document
59	REFITM	☐	J_1BREFITM	J_1BREFITM	NUMC	6	0	Reference item to source document
60	LOG_KEY_CHAR35	☐	J_1BLOG_KEY_CHAR35		CHAR	35	0	Sender Key
61	CIAP_OBJ_FLAG	☐	J_1BCIAP_OBJ_FLAG	XFELD	CHAR	1	0	Identified as CIAP Object
62	CIAP_STATUS	☐	J_1BCIAP_STATUS		CHAR	3	0	Internal Status of the CIAP Object Set by the System
63	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
64	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
65	TEXT	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
66	DOCDAT	☐	J_1BDOCDAT	DATUM	DATS	8	0	Document date
67	PSTDAT	☐	J_1BPSTDAT	DATUM	DATS	8	0	Posting date
68	MODEL	☐	J_1BMODEL	J_1BMODEL	NUMC	2	0	Model of Nota Fiscal
69	SERIES	☐	J_1BSERIES	J_1BSERIES	CHAR	3	0	Series
70	SUBSER	☐	J_1BSUBSER	J_1BSUBSER	CHAR	2	0	Sub series
71	NFNUM	☐	J_1BNFNUMB	J_1BNFNUMB	NUMC	6	0	Nota Fiscal Number
72	NFTYPE	☐	J_1BNFTYPE	J_1BNFTYPE	CHAR	2	0	Nota Fiscal Type	J_1BAA
73	DOCTYP	☐	J_1BDOCTYP	J_1BDOCTYP	CHAR	1	0	Document type	J_1BDOCTYPES
74	PARVW	☐	J_1BPARVW	J_1BPARVW	CHAR	2	0	Nota Fiscal Partner Function	J_1BAD
75	PARID	☐	J_1BPARID	J_1BPARID	CHAR	10	0	Partner ID (Customer, Vendor, Business Place)
76	PARTYP	☐	J_1BPARTYP	J_1BPARTYP	CHAR	1	0	Nota Fiscal Partner Type
77	CANCEL	☐	J_1BCANCEL	XFELD	CHAR	1	0	Canceled
78	CFOP	☐	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	J_1BAG
79	MATUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1B_CIAPV	ANLN1	ANLH	ANLN1
2	J_1B_CIAPV	ANLN2	ANLA	ANLN2
3	J_1B_CIAPV	AUFNR	AUFK	AUFNR
4	J_1B_CIAPV	BWART	T156	BWART
5	J_1B_CIAPV	CFOP	J_1BAG	CFOP	KEY	1	CN
6	J_1B_CIAPV	DOCNUM	J_1BNFDOC	DOCNUM
7	J_1B_CIAPV	DOCTYP	J_1BDOCTYPES	DOCTYP	KEY	1	CN
8	J_1B_CIAPV	GSBER	TGSB	GSBER
9	J_1B_CIAPV	KOKRS	TKA01	KOKRS
10	J_1B_CIAPV	KOSTL	CSKS	KOSTL
11	J_1B_CIAPV	MATNR	MARA	MATNR
12	J_1B_CIAPV	MEINS	T006	MSEHI
13	J_1B_CIAPV	NFTYPE	J_1BAA	NFTYPE	KEY	1	CN
14	J_1B_CIAPV	NPLNR	AUFK	AUFNR
15	J_1B_CIAPV	PARVW	J_1BAD	PARVW	KEY	1	CN
16	J_1B_CIAPV	PRCTR	CEPC	PRCTR
17	J_1B_CIAPV	PSPNR	PRPS	PSPNR
18	J_1B_CIAPV	TAXTYP	J_1BAJ	TAXTYP
19	J_1B_CIAPV	TCODE	TSTC	TCODE
20	J_1B_CIAPV	WAERS	TCURC	WAERS
21	J_1B_CIAPV	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20140121
SAP Release Created in