SAP ABAP Table DB_LOP_L_HD_IT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	DB_LOP_L_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_GROUP	☑	LOP_GROUP	LOP_GROUP	CHAR	4	0	Logistical Option Group	LOP_C_GRP
4	LOP_CAT	☑	LOP_CAT	LOP_CAT	CHAR	4	0	Logistical Option Category	LOP_C_CAT
5	LOP_TYPE	☑	LOP_TYPE	LOP_TYPE	CHAR	2	0	Logistical Option Type
6	OWNER	☑	LOP_OWNER	LOP_OWNER	CHAR	2	0	Holder of a Logistical Option
7	OPT_EXECUTED	☑	LOP_OPT_EXECUTED	BVALD	CHAR	1	0	Option Exercised
8	LOP_ID	☑	LOP_ID	LOP_ID	CHAR	30	0	Logistical Option List Name
9	DOC_TYPE	☑	LOP_DOC_TYPE	LOP_DOC_TYPE	CHAR	2	0	Document Type
10	DOC_NO	☑	LOP_DOC_NO	LOP_DOC_NO	CHAR	20	0	Document Number
11	DOC_ITEM_NO	☑	LOP_DOC_ITEM_NO	LOP_DOC_ITEM_NO	NUMC	10	0	Item Number
12	REF_GUID	☑	LOP_REF_GUID	WLF_GUID	RAW	16	0	Reference GUID
13	SIDE	☑	LOP_SIDE	LOP_SIDE	CHAR	1	0	Side
14	CARDINALITY	☑	LOP_CARDINALITY	LOP_CARDINALITY	CHAR	1	0	Number of Options That Can Be Maintained in a List
15	TXT_GROUP	☑	LOP_HEAD_TEXT_GROUP	LOP_TEXT_GROUP	CHAR	4	0	Group for Header Text	LOP_C_TXTGRP
16	TXT_GROUP_IT	☑	LOP_ITEM_TEXT_GROUP	LOP_TEXT_GROUP	CHAR	4	0	Group for Item Text	LOP_C_TXTGRP
17	DECL_STATUS	☑	LOP_DECL_STATUS	LOP_DECL_STATUS	CHAR	2	0	Status of the Declaration Date
18	MASTER_NO	☑	LOP_MASTER_NO	LOP_NO	CHAR	10	0	Logistical Option: Master List Number
19	DECL_GROUP	☑	LOP_DECL_GROUP	LOP_DECL_GROUP	CHAR	4	0	Group for Declaration Date Category	LOP_C_DECL_GRP
20	DECL_CAT	☑	LOP_DECL_CAT	LOP_DECL_CAT	CHAR	4	0	Declaration Date Category
21	DECL_RULE	☑	LOP_DECL_RULE	LOP_DECL_RULE	CHAR	2	0	Declaration Date Rule
22	EVENT	☑	PPE_EVENT	PPE_EVENT	CHAR	4	0	Business Event	PPE_C_EVENTS
23	EVENT_DATE	☑	LOP_EVENT_DATE	DATUM	DATS	8	0	Event Date
24	ORIGIN	☑	LOP_ORIGIN_EVENT_DATE	LOP_ORIGIN_EVENT_DATE	CHAR	1	0	Origin of the Event Date
25	EXPIRE_DATE	☑	LOP_EXPIRATION_DATE	DATUM	DATS	8	0	Declaration Date
26	CAL_ID_RESULT	☑	LOP_CAL_ID	WFCID	CHAR	2	0	Calendar for Declaration Date	TFACD
27	FIX_DATE	☑	LOP_FIX_DATE	DATUM	DATS	8	0	Fixed Date
28	DATE_TYPE	☑	LOP_DATE_TYPE	LOP_DATE_TYPE	CHAR	1	0	Date Type
29	NUM_OFFSET	☑	LOP_OFFSET	LOP_OFFSET	DEC	3	0	Offset with Sign
30	DATE_RULE	☑	LOP_DATE_CALC_RULE	LOP_DATE_CALC_RULE	CHAR	2	0	Date Shift Rule
31	FIX_DAY	☑	LOP_FIX_DAY	LOP_FIX_DAY	NUMC	2	0	Fixed Day of Month
32	LOG_EXEC_DATE	☑	LOP_EXEC_DATE	DATUM	DATS	8	0	Exercise Date
33	OWNER_EXEC	☑	LOP_OWNER_EXEC	LOP_OWNER	CHAR	2	0	Holder Who Has Exercised the Option
34	LOP_COUNT	☑	LOP_COUNT	LOP_COUNT	NUMC	6	0	Value Number
35	ITEM_GUID	☐	LOP_ITEM_GUID	WLF_GUID	RAW	16	0	Option List Item GUID
36	EXT_REF	☐	LOP_EXT_REF	LOP_EXT_REF	CHAR	32	0	External Reference
37	OPT_EXEC	☐	LOP_OPT_EXECUTED	BVALD	CHAR	1	0	Option Exercised
38	TEXT_EXIST	☐	LOP_TEXT_EXIST	XFELD	CHAR	1	0	Texts Exist
39	CR_NAME	☐	LOP_ERNAM	USNAM	CHAR	12	0	Name of Person Who Created the Object
40	CR_DATE	☐	LOP_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
41	CR_TIME	☐	LOP_ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
42	CH_NAME	☐	LOP_AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
43	CH_DATE	☐	LOP_AEDAT	DATUM	DATS	8	0	Last Changed On
44	CH_TIME	☐	LOP_AEZEIT	UHRZT	TIMS	6	0	Time of Change
45	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
46	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
47	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
48	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
49	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
50	QTY_MIN	☐	LOP_QTY_MIN	MENG15	QUAN	15	3	Minimum Quantity
51	QTY_MAX	☐	LOP_QTY_MAX	MENG15	QUAN	15	3	Maximum Quantity
52	UNIT	☐	LOP_UNIT	MEINS	UNIT	3	0	Unit of Measurement	T006
53	DATE_FROM	☐	LOP_DATE_FROM	DATUM	DATS	8	0	Date From
54	DATE_TO	☐	LOP_DATE_TO	DATUM	DATS	8	0	Date To
55	EXT_REF_HD	☐	LOP_EXT_REF	LOP_EXT_REF	CHAR	32	0	External Reference
56	CR_NAME_HD	☐	LOP_ERNAM	USNAM	CHAR	12	0	Name of Person Who Created the Object
57	CR_DATE_HD	☐	LOP_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
58	CR_TIME_HD	☐	LOP_ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
59	CH_NAME_HD	☐	LOP_AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
60	CH_DATE_HD	☐	LOP_AEDAT	DATUM	DATS	8	0	Last Changed On
61	CH_TIME_HD	☐	LOP_AEZEIT	UHRZT	TIMS	6	0	Time of Change
62	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_L_HD_IT	CAL_ID_RESULT	TFACD	IDENT
2	DB_LOP_L_HD_IT	COUNTRY	T005	LAND1		1	CN
3	DB_LOP_L_HD_IT	DECL_GROUP	LOP_C_DECL_GRP	DECL_GROUP		1	CN
4	DB_LOP_L_HD_IT	EVENT	PPE_C_EVENTS	EVENT		1	CN
5	DB_LOP_L_HD_IT	INCO1	TINC	INCO1		1	CN
6	DB_LOP_L_HD_IT	LOP_CAT	LOP_C_CAT	LOP_CAT		1	CN
7	DB_LOP_L_HD_IT	LOP_GROUP	LOP_C_GRP	LOP_GROUP		1	CN
8	DB_LOP_L_HD_IT	MATNR	MARA	MATNR	REF	1	CN
9	DB_LOP_L_HD_IT	PLANT	T001W	WERKS	REF	1	CN
10	DB_LOP_L_HD_IT	TXT_GROUP	LOP_C_TXTGRP	TXT_GROUP		1	CN
11	DB_LOP_L_HD_IT	TXT_GROUP_IT	LOP_C_TXTGRP	TXT_GROUP		1	CN
12	DB_LOP_L_HD_IT	UNIT	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in