SAP ABAP Table DB_LOP_M_HD_IT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	DB_LOP_M_HD_IT	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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client
2	LIST_GUID	☑	LOP_LIST_GUID	WLF_GUID	RAW	16	0	Option List GUID
3	LOP_NO	☑	LOP_NO	LOP_NO	CHAR	10	0	Option List Number (for Master Data)
4	LOP_CAT	☑	LOP_CAT	LOP_CAT	CHAR	4	0	Logistical Option Category	LOP_C_CAT
5	LOP_ID	☑	LOP_ID	LOP_ID	CHAR	30	0	Logistical Option List Name
6	CARDINALITY	☑	LOP_CARDINALITY	LOP_CARDINALITY	CHAR	1	0	Number of Options That Can Be Maintained in a List
7	TXT_GROUP	☑	LOP_HEAD_TEXT_GROUP	LOP_TEXT_GROUP	CHAR	4	0	Group for Header Text	LOP_C_TXTGRP
8	TXT_GROUP_IT	☑	LOP_ITEM_TEXT_GROUP	LOP_TEXT_GROUP	CHAR	4	0	Group for Item Text	LOP_C_TXTGRP
9	LOP_COUNT	☑	LOP_COUNT	LOP_COUNT	NUMC	6	0	Value Number
10	ITEM_GUID	☐	LOP_ITEM_GUID	WLF_GUID	RAW	16	0	Option List Item GUID
11	EXT_REF	☐	LOP_EXT_REF	LOP_EXT_REF	CHAR	32	0	External Reference
12	OPT_EXEC	☐	LOP_OPT_EXECUTED	BVALD	CHAR	1	0	Option Exercised
13	TEXT_EXIST	☐	LOP_TEXT_EXIST	XFELD	CHAR	1	0	Texts Exist
14	CR_NAME	☐	LOP_ERNAM	USNAM	CHAR	12	0	Name of Person Who Created the Object
15	CR_DATE	☐	LOP_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
16	CR_TIME	☐	LOP_ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
17	CH_NAME	☐	LOP_AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
18	CH_DATE	☐	LOP_AEDAT	DATUM	DATS	8	0	Last Changed On
19	CH_TIME	☐	LOP_AEZEIT	UHRZT	TIMS	6	0	Time of Change
20	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
21	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
22	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
23	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
24	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
25	QTY_MIN	☐	LOP_QTY_MIN	MENG15	QUAN	15	3	Minimum Quantity
26	QTY_MAX	☐	LOP_QTY_MAX	MENG15	QUAN	15	3	Maximum Quantity
27	UNIT	☐	LOP_UNIT	MEINS	UNIT	3	0	Unit of Measurement	T006
28	DATE_FROM	☐	LOP_DATE_FROM	DATUM	DATS	8	0	Date From
29	DATE_TO	☐	LOP_DATE_TO	DATUM	DATS	8	0	Date To
30	PLACE_HOLDER	☐			CHAR	1	0
31	EXT_REF_HD	☐	LOP_EXT_REF	LOP_EXT_REF	CHAR	32	0	External Reference
32	CR_NAME_HD	☐	LOP_ERNAM	USNAM	CHAR	12	0	Name of Person Who Created the Object
33	CR_DATE_HD	☐	LOP_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
34	CR_TIME_HD	☐	LOP_ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
35	CH_NAME_HD	☐	LOP_AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
36	CH_DATE_HD	☐	LOP_AEDAT	DATUM	DATS	8	0	Last Changed On
37	CH_TIME_HD	☐	LOP_AEZEIT	UHRZT	TIMS	6	0	Time of Change
38	TEXT_EXIST_HD	☐	LOP_TEXT_EXIST	XFELD	CHAR	1	0	Texts Exist

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DB_LOP_M_HD_IT	COUNTRY	T005	LAND1		1	CN
2	DB_LOP_M_HD_IT	INCO1	TINC	INCO1		1	CN
3	DB_LOP_M_HD_IT	LOP_CAT	LOP_C_CAT	LOP_CAT		1	CN
4	DB_LOP_M_HD_IT	MATNR	MARA	MATNR	REF	1	CN
5	DB_LOP_M_HD_IT	PLANT	T001W	WERKS	REF	1	CN
6	DB_LOP_M_HD_IT	TXT_GROUP	LOP_C_TXTGRP	TXT_GROUP		1	CN
7	DB_LOP_M_HD_IT	TXT_GROUP_IT	LOP_C_TXTGRP	TXT_GROUP		1	CN
8	DB_LOP_M_HD_IT	UNIT	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in