SAP ABAP Table LOP_S_BW_EXTRACT_EMB (Extraction Structure for Logistical Option Embedded 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

Table Category	INTTAB	Structure
Structure	LOP_S_BW_EXTRACT_EMB	Table Relationship Diagram
Short Description	Extraction Structure for Logistical Option Embedded List

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	ROCANCEL	☐	ROCANCEL	BOOLE	CHAR	1	0	Indicator: Cancel Data Record
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	LIST_GUID	☑	LOP_LIST_GUID	WLF_GUID	RAW	16	0	Option List GUID
4	LOP_COUNT	☑	LOP_COUNT	LOP_COUNT	NUMC	6	0	Value Number
5	.INCLU-_HD	☐				0	0	Option list header data
6	EXT_REF_HD	☐	LOP_EXT_REF	LOP_EXT_REF	CHAR	32	0	External Reference
7	LOP_GROUP_HD	☐	LOP_GROUP	LOP_GROUP	CHAR	4	0	Logistical Option Group	LOP_C_GRP
8	LOP_CAT_HD	☐	LOP_CAT	LOP_CAT	CHAR	4	0	Logistical Option Category	LOP_C_CAT
9	LOP_TYPE_HD	☐	LOP_TYPE	LOP_TYPE	CHAR	2	0	Logistical Option Type
10	OWNER_HD	☐	LOP_OWNER	LOP_OWNER	CHAR	2	0	Holder of a Logistical Option
11	OPT_EXECUTED_HD	☐	LOP_OPT_EXECUTED	BVALD	CHAR	1	0	Option Exercised
12	LOP_ID_HD	☐	LOP_ID	LOP_ID	CHAR	30	0	Logistical Option List Name
13	.INCLUDE	☐				0	0	Reference object
14	DOC_TYPE_HD	☐	LOP_DOC_TYPE	LOP_DOC_TYPE	CHAR	2	0	Document Type
15	DOC_NO_HD	☐	LOP_DOC_NO	LOP_DOC_NO	CHAR	20	0	Document Number
16	DOC_ITEM_NO_HD	☐	LOP_DOC_ITEM_NO	LOP_DOC_ITEM_NO	NUMC	10	0	Item Number
17	REF_GUID_HD	☐	LOP_REF_GUID	WLF_GUID	RAW	16	0	Reference GUID
18	SIDE_HD	☐	LOP_SIDE	LOP_SIDE	CHAR	1	0	Side
19	CARDINALITY_HD	☐	LOP_CARDINALITY	LOP_CARDINALITY	CHAR	1	0	Number of Options That Can Be Maintained in a List
20	TXT_GROUP_HD	☐	LOP_HEAD_TEXT_GROUP	LOP_TEXT_GROUP	CHAR	4	0	Group for Header Text	LOP_C_TXTGRP
21	TXT_GROUP_IT_HD	☐	LOP_ITEM_TEXT_GROUP	LOP_TEXT_GROUP	CHAR	4	0	Group for Item Text	LOP_C_TXTGRP
22	DECL_STATUS_HD	☐	LOP_DECL_STATUS	LOP_DECL_STATUS	CHAR	2	0	Status of the Declaration Date
23	TEXT_EXIST_HD	☐	LOP_TEXT_EXIST	XFELD	CHAR	1	0	Texts Exist
24	MASTER_NO_HD	☐	LOP_MASTER_NO	LOP_NO	CHAR	10	0	Logistical Option: Master List Number
25	.INCLUDE	☐				0	0	All fields for the Declaration Date
26	.INCLUDE	☐				0	0	Standard Data for Declaration Date
27	DECL_GROUP_HD	☐	LOP_DECL_GROUP	LOP_DECL_GROUP	CHAR	4	0	Group for Declaration Date Category	LOP_C_DECL_GRP
28	DECL_CAT_HD	☐	LOP_DECL_CAT	LOP_DECL_CAT	CHAR	4	0	Declaration Date Category
29	DECL_RULE_HD	☐	LOP_DECL_RULE	LOP_DECL_RULE	CHAR	2	0	Declaration Date Rule
30	EVENT_HD	☐	PPE_EVENT	PPE_EVENT	CHAR	4	0	Business Event	PPE_C_EVENTS
31	EVENT_DATE_HD	☐	LOP_EVENT_DATE	DATUM	DATS	8	0	Event Date
32	ORIGIN_HD	☐	LOP_ORIGIN_EVENT_DATE	LOP_ORIGIN_EVENT_DATE	CHAR	1	0	Origin of the Event Date
33	EXPIRE_DATE_HD	☐	LOP_EXPIRATION_DATE	DATUM	DATS	8	0	Declaration Date
34	CAL_ID_RESULT_HD	☐	LOP_CAL_ID	WFCID	CHAR	2	0	Calendar for Declaration Date	TFACD
35	FIX_DATE_HD	☐	LOP_FIX_DATE	DATUM	DATS	8	0	Fixed Date
36	DATE_TYPE_HD	☐	LOP_DATE_TYPE	LOP_DATE_TYPE	CHAR	1	0	Date Type
37	NUM_OFFSET_HD	☐	LOP_OFFSET	LOP_OFFSET	DEC	3	0	Offset with Sign
38	DATE_RULE_HD	☐	LOP_DATE_CALC_RULE	LOP_DATE_CALC_RULE	CHAR	2	0	Date Shift Rule
39	FIX_DAY_HD	☐	LOP_FIX_DAY	LOP_FIX_DAY	NUMC	2	0	Fixed Day of Month
40	.INCLUDE	☐				0	0	Customer fields for Declaration Date
41	PLACE_HOLDER_HD	☐			CHAR	1	0
42	.INCLUDE	☐				0	0	Administration data
43	CR_NAME_HD	☐	LOP_ERNAM	USNAM	CHAR	12	0	Name of Person Who Created the Object
44	CR_DATE_HD	☐	LOP_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
45	CR_TIME_HD	☐	LOP_ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
46	CH_NAME_HD	☐	LOP_AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
47	CH_DATE_HD	☐	LOP_AEDAT	DATUM	DATS	8	0	Last Changed On
48	CH_TIME_HD	☐	LOP_AEZEIT	UHRZT	TIMS	6	0	Time of Change
49	.INCLUDE	☐				0	0	Option Exercising Data
50	LOG_EXEC_DATE_HD	☐	LOP_EXEC_DATE	DATUM	DATS	8	0	Exercise Date
51	OWNER_EXEC_HD	☐	LOP_OWNER_EXEC	LOP_OWNER	CHAR	2	0	Holder Who Has Exercised the Option
52	.INCLU-_IT	☐				0	0	Option list item data
53	ITEM_GUID_IT	☐	LOP_ITEM_GUID	WLF_GUID	RAW	16	0	Option List Item GUID
54	EXT_REF_IT	☐	LOP_EXT_REF	LOP_EXT_REF	CHAR	32	0	External Reference
55	OPT_EXEC_IT	☐	LOP_OPT_EXECUTED	BVALD	CHAR	1	0	Option Exercised
56	TEXT_EXIST_IT	☐	LOP_TEXT_EXIST	XFELD	CHAR	1	0	Texts Exist
57	.INCLUDE	☐				0	0	Administration data
58	CR_NAME_IT	☐	LOP_ERNAM	USNAM	CHAR	12	0	Name of Person Who Created the Object
59	CR_DATE_IT	☐	LOP_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
60	CR_TIME_IT	☐	LOP_ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
61	CH_NAME_IT	☐	LOP_AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
62	CH_DATE_IT	☐	LOP_AEDAT	DATUM	DATS	8	0	Last Changed On
63	CH_TIME_IT	☐	LOP_AEZEIT	UHRZT	TIMS	6	0	Time of Change
64	.INCLUDE	☐				0	0	Option fields in option items
65	.INCLUDE	☐				0	0	Standard data
66	MATNR_IT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
67	PLANT_IT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
68	INCO1_IT	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
69	INCO2_IT	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
70	COUNTRY_IT	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
71	QTY_MIN_IT	☐	LOP_QTY_MIN	MENG15	QUAN	15	3	Minimum Quantity
72	QTY_MAX_IT	☐	LOP_QTY_MAX	MENG15	QUAN	15	3	Maximum Quantity
73	UNIT_IT	☐	LOP_UNIT	MEINS	UNIT	3	0	Unit of Measurement	T006
74	DATE_FROM_IT	☐	LOP_DATE_FROM	DATUM	DATS	8	0	Date From
75	DATE_TO_IT	☐	LOP_DATE_TO	DATUM	DATS	8	0	Date To
76	.INCLUDE	☐				0	0	Customer fields for option item
77	PLACE_HOLDER_IT	☐			CHAR	1	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LOP_S_BW_EXTRACT_EMB	CAL_ID_RESULT_HD	TFACD	IDENT
2	LOP_S_BW_EXTRACT_EMB	COUNTRY_IT	T005	LAND1		1	CN
3	LOP_S_BW_EXTRACT_EMB	DECL_GROUP_HD	LOP_C_DECL_GRP	DECL_GROUP		1	CN
4	LOP_S_BW_EXTRACT_EMB	EVENT_HD	PPE_C_EVENTS	EVENT		1	CN
5	LOP_S_BW_EXTRACT_EMB	INCO1_IT	TINC	INCO1		1	CN
6	LOP_S_BW_EXTRACT_EMB	LOP_CAT_HD	LOP_C_CAT	LOP_CAT		1	CN
7	LOP_S_BW_EXTRACT_EMB	LOP_GROUP_HD	LOP_C_GRP	LOP_GROUP		1	CN
8	LOP_S_BW_EXTRACT_EMB	MATNR_IT	MARA	MATNR	REF	1	CN
9	LOP_S_BW_EXTRACT_EMB	PLANT_IT	T001W	WERKS	REF	1	CN
10	LOP_S_BW_EXTRACT_EMB	TXT_GROUP_HD	LOP_C_TXTGRP	TXT_GROUP		1	CN
11	LOP_S_BW_EXTRACT_EMB	TXT_GROUP_IT_HD	LOP_C_TXTGRP	TXT_GROUP		1	CN
12	LOP_S_BW_EXTRACT_EMB	UNIT_IT	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	617