DB_LOP_M_HD_IT SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from DB_LOP_M_HD_IT
Related tables to DB_LOP_M_HD_IT
Access table DB_LOP_M_HD_IT




Table View field list including key, data, relationships and ABAP select examples

DB_LOP_M_HD_IT is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The DB_LOP_M_HD_IT table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include LIST_GUID (Option List GUID), LOP_NO (Option List Number (for Master Data)), LOP_CAT (Logistical Option Category), LOP_ID (Logistical Option List Name).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DB_LOP_M_HD_IT table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3MANDT
LIST_GUIDOption List GUID LOP_LIST_GUIDRAW16WLF_GUID
LOP_NOOption List Number (for Master Data) LOP_NOCHAR10ALPHALOP_NO
LOP_CATLogistical Option Category LOP_CATCHAR4LOP_C_CATLOP_CAT
LOP_IDLogistical Option List Name LOP_IDCHAR30LOP_ID
CARDINALITYNumber of Options That Can Be Maintained in a List LOP_CARDINALITYCHAR1LOP_CARDINALITY
TXT_GROUPGroup for Header Text LOP_HEAD_TEXT_GROUPCHAR4LOP_C_TXTGRPALPHALOP_TEXT_GROUP
TXT_GROUP_ITGroup for Item Text LOP_ITEM_TEXT_GROUPCHAR4LOP_C_TXTGRPALPHALOP_TEXT_GROUP
LOP_COUNTValue Number LOP_COUNTNUMC6LOP_COUNT
ITEM_GUIDOption List Item GUID LOP_ITEM_GUIDRAW16WLF_GUID
EXT_REFExternal Reference LOP_EXT_REFCHAR32LOP_EXT_REF
OPT_EXECOption Exercised LOP_OPT_EXECUTEDCHAR1BVALD
TEXT_EXISTTexts Exist LOP_TEXT_EXISTCHAR1XFELD
CR_NAMEName of Person Who Created the Object LOP_ERNAMCHAR12USNAM
CR_DATEDate on Which Record Was Created LOP_ERDATDATS8DATUM
CR_TIMETime, at Which Record Was Added LOP_ERZEITTIMS6UHRZT
CH_NAMEName of Person Who Changed Object LOP_AENAMCHAR12USNAM
CH_DATELast Changed On LOP_AEDATDATS8DATUM
CH_TIMETime of Change LOP_AEZEITTIMS6UHRZT
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
PLANTPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
INCO1Incoterms (Part 1) INCO1CHAR3TINCINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
QTY_MINMinimum Quantity LOP_QTY_MINQUAN15(3) MENG15
QTY_MAXMaximum Quantity LOP_QTY_MAXQUAN15(3) MENG15
UNITUnit of Measurement LOP_UNITUNIT3T006CUNITMEINS
DATE_FROMDate From LOP_DATE_FROMDATS8DATUM
DATE_TODate To LOP_DATE_TODATS8DATUM
PLACE_HOLDER 0
EXT_REF_HDExternal Reference LOP_EXT_REFCHAR32LOP_EXT_REF
CR_NAME_HDName of Person Who Created the Object LOP_ERNAMCHAR12USNAM
CR_DATE_HDDate on Which Record Was Created LOP_ERDATDATS8DATUM
CR_TIME_HDTime, at Which Record Was Added LOP_ERZEITTIMS6UHRZT
CH_NAME_HDName of Person Who Changed Object LOP_AENAMCHAR12USNAM
CH_DATE_HDLast Changed On LOP_AEDATDATS8DATUM
CH_TIME_HDTime of Change LOP_AEZEITTIMS6UHRZT
TEXT_EXIST_HDTexts Exist LOP_TEXT_EXISTCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table DB_LOP_M_HD_IT using ABAP code

The following ABAP code Example will allow you to do a basic selection on DB_LOP_M_HD_IT to SELECT all data from the table
DATA: WA_DB_LOP_M_HD_IT TYPE DB_LOP_M_HD_IT.

SELECT SINGLE *
FROM DB_LOP_M_HD_IT
INTO CORRESPONDING FIELDS OF WA_DB_LOP_M_HD_IT
WHERE...

How to access SAP table DB_LOP_M_HD_IT

Within an ECC or HANA version of SAP you can also view further information about DB_LOP_M_HD_IT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!