SAP ABAP View DB_LOP_L_HD_IT (Selection of All Fields in Tables LOP HD and IT Option List)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-AB-TC (Application Component) Trading Contract
     ⤷ LOOP (Package) Model layer for logistical contract options

Basic Data

View Type	D	Database View
Database View	DB_LOP_L_HD_IT
Short Description	Selection of All Fields in Tables LOP HD and IT Option List
Root table	LOP_D_LIST_HD	Option list header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LOP_D_LIST_HD	LOP_D_LIST_HD
2	LOP_D_LIST_IT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LOP_D_LIST_HD	CLIENT	JL	EQ				0	0
2	LOP_D_LIST_IT	CLIENT	JR	EQ			AND	0	0
3	LOP_D_LIST_HD	LIST_GUID	JL	EQ				0	0
4	LOP_D_LIST_IT	LIST_GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	LOP_D_LIST_HD	*		☐		☐
2	CLIENT	LOP_D_LIST_HD	CLIENT		☐	MANDT	☐	Client
3	LIST_GUID	LOP_D_LIST_HD	LIST_GUID		☐	LOP_LIST_GUID	☐	Option List GUID
4	LOP_GROUP	LOP_D_LIST_HD	LOP_GROUP		☐	LOP_GROUP	☐	Logistical Option Group
5	LOP_CAT	LOP_D_LIST_HD	LOP_CAT		☐	LOP_CAT	☐	Logistical Option Category
6	LOP_TYPE	LOP_D_LIST_HD	LOP_TYPE		☐	LOP_TYPE	☐	Logistical Option Type
7	OWNER	LOP_D_LIST_HD	OWNER		☐	LOP_OWNER	☐	Holder of a Logistical Option
8	OPT_EXECUTED	LOP_D_LIST_HD	OPT_EXECUTED		☐	LOP_OPT_EXECUTED	☐	Option Exercised
9	LOP_ID	LOP_D_LIST_HD	LOP_ID		☐	LOP_ID	☐	Logistical Option List Name
10	DOC_TYPE	LOP_D_LIST_HD	DOC_TYPE		☐	LOP_DOC_TYPE	☐	Document Type
11	DOC_NO	LOP_D_LIST_HD	DOC_NO		☐	LOP_DOC_NO	☐	Document Number
12	DOC_ITEM_NO	LOP_D_LIST_HD	DOC_ITEM_NO		☐	LOP_DOC_ITEM_NO	☐	Item Number
13	REF_GUID	LOP_D_LIST_HD	REF_GUID		☐	LOP_REF_GUID	☐	Reference GUID
14	SIDE	LOP_D_LIST_HD	SIDE		☐	LOP_SIDE	☐	Side
15	CARDINALITY	LOP_D_LIST_HD	CARDINALITY		☐	LOP_CARDINALITY	☐	Number of Options That Can Be Maintained in a List
16	TXT_GROUP	LOP_D_LIST_HD	TXT_GROUP		☐	LOP_HEAD_TEXT_GROUP	☐	Group for Header Text
17	TXT_GROUP_IT	LOP_D_LIST_HD	TXT_GROUP_IT		☐	LOP_ITEM_TEXT_GROUP	☐	Group for Item Text
18	DECL_STATUS	LOP_D_LIST_HD	DECL_STATUS		☐	LOP_DECL_STATUS	☐	Status of the Declaration Date
19	MASTER_NO	LOP_D_LIST_HD	MASTER_NO		☐	LOP_MASTER_NO	☐	Logistical Option: Master List Number
20	DECL_GROUP	LOP_D_LIST_HD	DECL_GROUP		☐	LOP_DECL_GROUP	☐	Group for Declaration Date Category
21	DECL_CAT	LOP_D_LIST_HD	DECL_CAT		☐	LOP_DECL_CAT	☐	Declaration Date Category
22	DECL_RULE	LOP_D_LIST_HD	DECL_RULE		☐	LOP_DECL_RULE	☐	Declaration Date Rule
23	EVENT	LOP_D_LIST_HD	EVENT		☐	PPE_EVENT	☐	Business Event
24	EVENT_DATE	LOP_D_LIST_HD	EVENT_DATE		☐	LOP_EVENT_DATE	☐	Event Date
25	ORIGIN	LOP_D_LIST_HD	ORIGIN		☐	LOP_ORIGIN_EVENT_DATE	☐	Origin of the Event Date
26	EXPIRE_DATE	LOP_D_LIST_HD	EXPIRE_DATE		☐	LOP_EXPIRATION_DATE	☐	Declaration Date
27	CAL_ID_RESULT	LOP_D_LIST_HD	CAL_ID_RESULT		☐	LOP_CAL_ID	☐	Calendar for Declaration Date
28	FIX_DATE	LOP_D_LIST_HD	FIX_DATE		☐	LOP_FIX_DATE	☐	Fixed Date
29	DATE_TYPE	LOP_D_LIST_HD	DATE_TYPE		☐	LOP_DATE_TYPE	☐	Date Type
30	NUM_OFFSET	LOP_D_LIST_HD	NUM_OFFSET		☐	LOP_OFFSET	☐	Offset with Sign
31	DATE_RULE	LOP_D_LIST_HD	DATE_RULE		☐	LOP_DATE_CALC_RULE	☐	Date Shift Rule
32	FIX_DAY	LOP_D_LIST_HD	FIX_DAY		☐	LOP_FIX_DAY	☐	Fixed Day of Month
33	-	LOP_D_LIST_HD	PLACE_HOLDER		☐		☐
34	LOG_EXEC_DATE	LOP_D_LIST_HD	LOG_EXEC_DATE		☐	LOP_EXEC_DATE	☐	Exercise Date
35	OWNER_EXEC	LOP_D_LIST_HD	OWNER_EXEC		☐	LOP_OWNER_EXEC	☐	Holder Who Has Exercised the Option
36	*	LOP_D_LIST_IT	*		☐		☐
37	-	LOP_D_LIST_IT	CLIENT		☐	MANDT	☐	Client
38	-	LOP_D_LIST_IT	LIST_GUID		☐	LOP_LIST_GUID	☐	Option List GUID
39	LOP_COUNT	LOP_D_LIST_IT	LOP_COUNT		☐	LOP_COUNT	☐	Value Number
40	ITEM_GUID	LOP_D_LIST_IT	ITEM_GUID		☐	LOP_ITEM_GUID	☐	Option List Item GUID
41	EXT_REF	LOP_D_LIST_IT	EXT_REF		☐	LOP_EXT_REF	☐	External Reference
42	OPT_EXEC	LOP_D_LIST_IT	OPT_EXEC		☐	LOP_OPT_EXECUTED	☐	Option Exercised
43	TEXT_EXIST	LOP_D_LIST_IT	TEXT_EXIST		☐	LOP_TEXT_EXIST	☐	Texts Exist
44	CR_NAME	LOP_D_LIST_IT	CR_NAME		☐	LOP_ERNAM	☐	Name of Person Who Created the Object
45	CR_DATE	LOP_D_LIST_IT	CR_DATE		☐	LOP_ERDAT	☐	Date on Which Record Was Created
46	CR_TIME	LOP_D_LIST_IT	CR_TIME		☐	LOP_ERZEIT	☐	Time, at Which Record Was Added
47	CH_NAME	LOP_D_LIST_IT	CH_NAME		☐	LOP_AENAM	☐	Name of Person Who Changed Object
48	CH_DATE	LOP_D_LIST_IT	CH_DATE		☐	LOP_AEDAT	☐	Last Changed On
49	CH_TIME	LOP_D_LIST_IT	CH_TIME		☐	LOP_AEZEIT	☐	Time of Change
50	MATNR	LOP_D_LIST_IT	MATNR		☐	MATNR	☐	Material Number
51	PLANT	LOP_D_LIST_IT	PLANT		☐	WERKS_D	☐	Plant
52	INCO1	LOP_D_LIST_IT	INCO1		☐	INCO1	☐	Incoterms (part 1)
53	INCO2	LOP_D_LIST_IT	INCO2		☐	INCO2	☐	Incoterms (part 2)
54	COUNTRY	LOP_D_LIST_IT	COUNTRY		☐	LAND1	☐	Country Key
55	QTY_MIN	LOP_D_LIST_IT	QTY_MIN		☐	LOP_QTY_MIN	☐	Minimum Quantity
56	QTY_MAX	LOP_D_LIST_IT	QTY_MAX		☐	LOP_QTY_MAX	☐	Maximum Quantity
57	UNIT	LOP_D_LIST_IT	UNIT		☐	LOP_UNIT	☐	Unit of Measurement
58	DATE_FROM	LOP_D_LIST_IT	DATE_FROM		☐	LOP_DATE_FROM	☐	Date From
59	DATE_TO	LOP_D_LIST_IT	DATE_TO		☐	LOP_DATE_TO	☐	Date To
60	-	LOP_D_LIST_IT	PLACE_HOLDER		☐		☐
61	EXT_REF_HD	LOP_D_LIST_HD	EXT_REF		☐	LOP_EXT_REF	☐	External Reference
62	CR_NAME_HD	LOP_D_LIST_HD	CR_NAME		☐	LOP_ERNAM	☐	Name of Person Who Created the Object
63	CR_DATE_HD	LOP_D_LIST_HD	CR_DATE		☐	LOP_ERDAT	☐	Date on Which Record Was Created
64	CR_TIME_HD	LOP_D_LIST_HD	CR_TIME		☐	LOP_ERZEIT	☐	Time, at Which Record Was Added
65	CH_NAME_HD	LOP_D_LIST_HD	CH_NAME		☐	LOP_AENAM	☐	Name of Person Who Changed Object
66	CH_DATE_HD	LOP_D_LIST_HD	CH_DATE		☐	LOP_AEDAT	☐	Last Changed On
67	CH_TIME_HD	LOP_D_LIST_HD	CH_TIME		☐	LOP_AEZEIT	☐	Time of Change
68	TEXT_EXIST_HD	LOP_D_LIST_HD	TEXT_EXIST		☐	LOP_TEXT_EXIST	☐	Texts Exist

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	20130529
SAP Release Created in	607