SAP ABAP View J_1B_CIAPV (CIAP Database View)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	J_1B_CIAPV
Short Description	CIAP Database View
Root table	J_1B_CIAP_OBJECT	CIAP document data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	J_1B_CIAP_OBJECT	J_1B_CIAP_OBJECT
2	J_1BNFDOC
3	J_1BNFLIN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	J_1B_CIAP_OBJECT	MANDT	JL	EQ				0	0
2	J_1BNFDOC	MANDT	JR	EQ			AND	0	0
3	J_1B_CIAP_OBJECT	DOCNUM	JL	EQ				0	0
4	J_1BNFDOC	DOCNUM	JR	EQ			AND	0	0
5	J_1B_CIAP_OBJECT	MANDT	JL	EQ				0	0
6	J_1BNFLIN	MANDT	JR	EQ			AND	0	0
7	J_1B_CIAP_OBJECT	DOCNUM	JL	EQ				0	0
8	J_1BNFLIN	DOCNUM	JR	EQ			AND	0	0
9	J_1B_CIAP_OBJECT	ITMNUM	JL	EQ				0	0
10	J_1BNFLIN	ITMNUM	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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