SAP ABAP View DB_LOP_M_HD_IT (Selection of All Fields in Tables LOP HD and IT Master 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_M_HD_IT
Short Description	Selection of All Fields in Tables LOP HD and IT Master List
Root table	LOP_D_MASTER_HD	Option list header as master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LOP_D_MASTER_HD	LOP_D_MASTER_HD
2	LOP_D_MASTER_IT

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	LOP_D_MASTER_HD	*		☐		☐
2	CLIENT	LOP_D_MASTER_HD	CLIENT		☐	MANDT	☐	Client
3	LIST_GUID	LOP_D_MASTER_HD	LIST_GUID		☐	LOP_LIST_GUID	☐	Option List GUID
4	LOP_NO	LOP_D_MASTER_HD	LOP_NO		☐	LOP_NO	☐	Option List Number (for Master Data)
5	LOP_CAT	LOP_D_MASTER_HD	LOP_CAT		☐	LOP_CAT	☐	Logistical Option Category
6	LOP_ID	LOP_D_MASTER_HD	LOP_ID		☐	LOP_ID	☐	Logistical Option List Name
7	CARDINALITY	LOP_D_MASTER_HD	CARDINALITY		☐	LOP_CARDINALITY	☐	Number of Options That Can Be Maintained in a List
8	TXT_GROUP	LOP_D_MASTER_HD	TXT_GROUP		☐	LOP_HEAD_TEXT_GROUP	☐	Group for Header Text
9	TXT_GROUP_IT	LOP_D_MASTER_HD	TXT_GROUP_IT		☐	LOP_ITEM_TEXT_GROUP	☐	Group for Item Text
10	*	LOP_D_MASTER_IT	*		☐		☐
11	-	LOP_D_MASTER_IT	CLIENT		☐	MANDT	☐	Client
12	-	LOP_D_MASTER_IT	LIST_GUID		☐	LOP_LIST_GUID	☐	Option List GUID
13	LOP_COUNT	LOP_D_MASTER_IT	LOP_COUNT		☐	LOP_COUNT	☐	Value Number
14	ITEM_GUID	LOP_D_MASTER_IT	ITEM_GUID		☐	LOP_ITEM_GUID	☐	Option List Item GUID
15	EXT_REF	LOP_D_MASTER_IT	EXT_REF		☐	LOP_EXT_REF	☐	External Reference
16	OPT_EXEC	LOP_D_MASTER_IT	OPT_EXEC		☐	LOP_OPT_EXECUTED	☐	Option Exercised
17	TEXT_EXIST	LOP_D_MASTER_IT	TEXT_EXIST		☐	LOP_TEXT_EXIST	☐	Texts Exist
18	CR_NAME	LOP_D_MASTER_IT	CR_NAME		☐	LOP_ERNAM	☐	Name of Person Who Created the Object
19	CR_DATE	LOP_D_MASTER_IT	CR_DATE		☐	LOP_ERDAT	☐	Date on Which Record Was Created
20	CR_TIME	LOP_D_MASTER_IT	CR_TIME		☐	LOP_ERZEIT	☐	Time, at Which Record Was Added
21	CH_NAME	LOP_D_MASTER_IT	CH_NAME		☐	LOP_AENAM	☐	Name of Person Who Changed Object
22	CH_DATE	LOP_D_MASTER_IT	CH_DATE		☐	LOP_AEDAT	☐	Last Changed On
23	CH_TIME	LOP_D_MASTER_IT	CH_TIME		☐	LOP_AEZEIT	☐	Time of Change
24	MATNR	LOP_D_MASTER_IT	MATNR		☐	MATNR	☐	Material Number
25	PLANT	LOP_D_MASTER_IT	PLANT		☐	WERKS_D	☐	Plant
26	INCO1	LOP_D_MASTER_IT	INCO1		☐	INCO1	☐	Incoterms (part 1)
27	INCO2	LOP_D_MASTER_IT	INCO2		☐	INCO2	☐	Incoterms (part 2)
28	COUNTRY	LOP_D_MASTER_IT	COUNTRY		☐	LAND1	☐	Country Key
29	QTY_MIN	LOP_D_MASTER_IT	QTY_MIN		☐	LOP_QTY_MIN	☐	Minimum Quantity
30	QTY_MAX	LOP_D_MASTER_IT	QTY_MAX		☐	LOP_QTY_MAX	☐	Maximum Quantity
31	UNIT	LOP_D_MASTER_IT	UNIT		☐	LOP_UNIT	☐	Unit of Measurement
32	DATE_FROM	LOP_D_MASTER_IT	DATE_FROM		☐	LOP_DATE_FROM	☐	Date From
33	DATE_TO	LOP_D_MASTER_IT	DATE_TO		☐	LOP_DATE_TO	☐	Date To
34	PLACE_HOLDER	LOP_D_MASTER_IT	PLACE_HOLDER		☐		☐
35	EXT_REF_HD	LOP_D_MASTER_HD	EXT_REF		☐	LOP_EXT_REF	☐	External Reference
36	CR_NAME_HD	LOP_D_MASTER_HD	CR_NAME		☐	LOP_ERNAM	☐	Name of Person Who Created the Object
37	CR_DATE_HD	LOP_D_MASTER_HD	CR_DATE		☐	LOP_ERDAT	☐	Date on Which Record Was Created
38	CR_TIME_HD	LOP_D_MASTER_HD	CR_TIME		☐	LOP_ERZEIT	☐	Time, at Which Record Was Added
39	CH_NAME_HD	LOP_D_MASTER_HD	CH_NAME		☐	LOP_AENAM	☐	Name of Person Who Changed Object
40	CH_DATE_HD	LOP_D_MASTER_HD	CH_DATE		☐	LOP_AEDAT	☐	Last Changed On
41	CH_TIME_HD	LOP_D_MASTER_HD	CH_TIME		☐	LOP_AEZEIT	☐	Time of Change
42	TEXT_EXIST_HD	LOP_D_MASTER_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