SAP ABAP Table LOP_S_BW_EXTRACT_MASTER (Extraction Structure for Logistical Option Master Lists)

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_MASTER	Table Relationship Diagram
Short Description	Extraction Structure for Logistical Option Master Lists

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_COUNT	☐	LOP_COUNT	LOP_COUNT	NUMC	6	0	Value Number
4	.INCLU-_HD	☐				0	0	Master Data Header
5	LOP_NO_HD	☐	LOP_NO	LOP_NO	CHAR	10	0	Option List Number (for Master Data)
6	EXT_REF_HD	☐	LOP_EXT_REF	LOP_EXT_REF	CHAR	32	0	External Reference
7	LOP_CAT_HD	☐	LOP_CAT	LOP_CAT	CHAR	4	0	Logistical Option Category	LOP_C_CAT
8	LOP_ID_HD	☐	LOP_ID	LOP_ID	CHAR	30	0	Logistical Option List Name
9	CARDINALITY_HD	☐	LOP_CARDINALITY	LOP_CARDINALITY	CHAR	1	0	Number of Options That Can Be Maintained in a List
10	TXT_GROUP_HD	☐	LOP_HEAD_TEXT_GROUP	LOP_TEXT_GROUP	CHAR	4	0	Group for Header Text	LOP_C_TXTGRP
11	TXT_GROUP_IT_HD	☐	LOP_ITEM_TEXT_GROUP	LOP_TEXT_GROUP	CHAR	4	0	Group for Item Text	LOP_C_TXTGRP
12	TEXT_EXIST_HD	☐	LOP_TEXT_EXIST	XFELD	CHAR	1	0	Texts Exist
13	.INCLUDE	☐				0	0	Administration data
14	CR_NAME_HD	☐	LOP_ERNAM	USNAM	CHAR	12	0	Name of Person Who Created the Object
15	CR_DATE_HD	☐	LOP_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
16	CR_TIME_HD	☐	LOP_ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
17	CH_NAME_HD	☐	LOP_AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
18	CH_DATE_HD	☐	LOP_AEDAT	DATUM	DATS	8	0	Last Changed On
19	CH_TIME_HD	☐	LOP_AEZEIT	UHRZT	TIMS	6	0	Time of Change
20	.INCLU-_IT	☐				0	0	Option list item data
21	ITEM_GUID_IT	☐	LOP_ITEM_GUID	WLF_GUID	RAW	16	0	Option List Item GUID
22	EXT_REF_IT	☐	LOP_EXT_REF	LOP_EXT_REF	CHAR	32	0	External Reference
23	OPT_EXEC_IT	☐	LOP_OPT_EXECUTED	BVALD	CHAR	1	0	Option Exercised
24	TEXT_EXIST_IT	☐	LOP_TEXT_EXIST	XFELD	CHAR	1	0	Texts Exist
25	.INCLUDE	☐				0	0	Administration data
26	CR_NAME_IT	☐	LOP_ERNAM	USNAM	CHAR	12	0	Name of Person Who Created the Object
27	CR_DATE_IT	☐	LOP_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
28	CR_TIME_IT	☐	LOP_ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
29	CH_NAME_IT	☐	LOP_AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
30	CH_DATE_IT	☐	LOP_AEDAT	DATUM	DATS	8	0	Last Changed On
31	CH_TIME_IT	☐	LOP_AEZEIT	UHRZT	TIMS	6	0	Time of Change
32	.INCLUDE	☐				0	0	Option fields in option items
33	.INCLUDE	☐				0	0	Standard data
34	MATNR_IT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
35	PLANT_IT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
36	INCO1_IT	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
37	INCO2_IT	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
38	COUNTRY_IT	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
39	QTY_MIN_IT	☐	LOP_QTY_MIN	MENG15	QUAN	15	3	Minimum Quantity
40	QTY_MAX_IT	☐	LOP_QTY_MAX	MENG15	QUAN	15	3	Maximum Quantity
41	UNIT_IT	☐	LOP_UNIT	MEINS	UNIT	3	0	Unit of Measurement	T006
42	DATE_FROM_IT	☐	LOP_DATE_FROM	DATUM	DATS	8	0	Date From
43	DATE_TO_IT	☐	LOP_DATE_TO	DATUM	DATS	8	0	Date To
44	.INCLUDE	☐				0	0	Customer fields for option item
45	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_MASTER	COUNTRY_IT	T005	LAND1		1	CN
2	LOP_S_BW_EXTRACT_MASTER	INCO1_IT	TINC	INCO1		1	CN
3	LOP_S_BW_EXTRACT_MASTER	LOP_CAT_HD	LOP_C_CAT	LOP_CAT		1	CN
4	LOP_S_BW_EXTRACT_MASTER	MATNR_IT	MARA	MATNR	REF	1	CN
5	LOP_S_BW_EXTRACT_MASTER	PLANT_IT	T001W	WERKS	REF	1	CN
6	LOP_S_BW_EXTRACT_MASTER	TXT_GROUP_HD	LOP_C_TXTGRP	TXT_GROUP		1	CN
7	LOP_S_BW_EXTRACT_MASTER	TXT_GROUP_IT_HD	LOP_C_TXTGRP	TXT_GROUP		1	CN
8	LOP_S_BW_EXTRACT_MASTER	UNIT_IT	T006	MSEHI		1	CN

History

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