SAP LFM2_DQ_STR Table in S/4 HANA - Key and Attribute Structure for LFM2
LFM2_DQ_STR is a standard SAP Table which is used to store Key and Attribute Structure for LFM2 data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP LFM2_DQ_STR table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: LFM2_DQ_STR
LFM2_DQ_STR table structure field list
Below is the full LFM2_DQ_STR field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
SOURCE_SYSTEM | Source System | MDC_BUSINESS_SYSTEM | CHAR | 60(0) | AIT_SYSTEM | SAI_BUSINESS_SYSTEM | BS_KEY_NAME | |||
SOURCE_ID | Master Data Consolidation: ID of a Source Objects | MDC_SOURCE_ID | CHAR | 60(0) | MDC_SOURCE_ID | |||||
EKORG | Purchasing organization | EKORG | CHAR | 4(0) | EKORG | EKO | ||||
LTSNR | Supplier Subrange | LTSNR | CHAR | 6(0) | LTSNR | |||||
WERKS | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
ASSIGNMENT_ID | Multiple Assignment ID (Number) | MDG_BP_ASSIGNMENT_ID | NUMC | 12(0) | MDG_BP_ASSIGNMENT_ID | |||||
ERDAT | Date on which the record was created | ERDAT | DATS | 8(0) | DATUM | |||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
SPERM | Purchasing block at purchasing organization level | SPERM_M | CHAR | 1(0) | XFELD | |||||
LOEVM | Deletion Indicator for Supplier at Purchasing Level | LOEVM_M | CHAR | 1(0) | XFELD | |||||
LFABC | ABC indicator | LFABC | CHAR | 1(0) | LFABC | |||||
WAERS | Purchase order currency | BSTWA | CUKY | 5(0) | TCURC | WAERS | ||||
VERKF | Responsible Salesperson at Supplier's Office | EVERK | CHAR | 30(0) | TEXT30 | |||||
TELF1 | Supplier's Telephone Number | TELFE | CHAR | 16(0) | TEXT16 | |||||
MINBW | Minimum order value | MINBW | CURR | 13(2) | WERT7 | |||||
ZTERM | Terms of payment key | DZTERM | CHAR | 4(0) | ZTERM | |||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3(0) | TINC | INCO1 | ||||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28(0) | INCO2 | |||||
WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1(0) | XFELD | |||||
KZABS | Order Acknowledgment Requirement | KZABS | CHAR | 1(0) | XFELD | |||||
KALSK | Group for Calculation Schema (Supplier) | KALSK | CHAR | 2(0) | TMKK | KALSK | ||||
KZAUT | Automatic Generation of Purchase Order Allowed | KZAUT | CHAR | 1(0) | XFELD | |||||
EXPVZ | Mode of Transport at the Border (Intrastat) | EXPVZ | CHAR | 1(0) | T618 | EXPVZ | ||||
ZOLLA | Customs Office: Office of Exit/Entry for Foreign Trade | DZOLLS | CHAR | 6(0) | T615 | ZOLLS | ||||
MEPRF | Price Determination (Pricing) Date Control | MEPRF | CHAR | 1(0) | MEPRF | |||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3(0) | T024 | EKGRP | EKG | |||
XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1(0) | XFELD | |||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3(0) | DEC3 | |||||
MRPPP | Planning Calendar | MRPPP_W | CHAR | 3(0) | T439G | MRPPP | ||||
LFRHY | Planning cycle | LFRHY | CHAR | 3(0) | T439G | MRPPP | ||||
LIBES | Order entry by supplier | LIBES | CHAR | 1(0) | CHAR1 | |||||
LIPRE | Price marking, supplier | LIPRE | CHAR | 2(0) | TWYAZ | LIPRE | ||||
LISER | Rack-jobbing: supplier | LISER | CHAR | 1(0) | CHAR1 | |||||
INCOV | Incoterms Version | INCOV | CHAR | 4(0) | TINCV | INCOV | ||||
INCO2_L | Incoterms Location 1 | INCO2_L | CHAR | 70(0) | INCO_L | |||||
INCO3_L | Incoterms Location 2 | INCO3_L | CHAR | 70(0) | INCO_L | |||||
DISPO | MRP Controller | DISPO | CHAR | 3(0) | DISPO | DGR | HS_T024D | DISPO | ||
BOIND | Field Not Used (Subsequent Settlement) | BOIND_UNUSED | CHAR | 1(0) | XFELD | |||||
BSTAE | Confirmation Control Key | BSTAE | CHAR | 4(0) | BSTAE | |||||
RDPRF | Rounding Profile | RDPRF | CHAR | 4(0) | RDPRF | |||||
MEGRU | Unit of Measure Group | MEGRU | CHAR | 4(0) | MEGRU | |||||
BOPNR | Restriction Profile for PO-Based Load Building | BOPNR | CHAR | 4(0) | CHAR4 | |||||
XERSR | Automatic evaluated receipt settlement for return items | XERSR | CHAR | 1(0) | XFELD | |||||
ABUEB | Release Creation Profile | ABUEB | CHAR | 4(0) | ABUEB | |||||
PAPRF | Profile for transferring material data via IDoc PROACT | WVMI_PAPRF | CHAR | 4(0) | WVMI_PAPRF | |||||
XNBWY | Revaluation allowed | XNBWY | CHAR | 1(0) | XFELD | |||||
LEBRE | Indicator for Service-Based Invoice Verification | LEBRE | CHAR | 1(0) | XFELD | |||||
BOLRE | Field Not Used (Subsequent Settlement) | BOLRE_UNUSED | CHAR | 1(0) | XFELD | |||||
UMSAE | Field Not Used (Subsequent Settlement) | UMSAE_UNUSED | CHAR | 1(0) | XFELD | |||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER |
Search for further information about these or an SAP related objects