LFM1_PRC

Transparent Table Application Table
83 Fields 2 CDS Views

Master Data Consolidation: Process Table for LFM1

LFM1_PRC is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for LFM1. It contains 83 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPSuplrPurchasingOrgProc view_entity from EXTENSION BP Supplier Purchasing Org - Extension
I_BPSuplrPurchasingOrgProc view_entity from BASIC BP Supplier Purchasing Org Process Data

Fields (83)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY process_step_no MDC_PROCESS_STEP_NO Step Number
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
KEY ekorg EKORG Purchasing Org.
KEY assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
erdat ERDAT Created On
ernam ERNAM Created By
sperm SPERM_M Pur. block POrg
loevm LOEVM_M Del. flag POrg.
lfabc LFABC ABC indicator
waers BSTWA Order currency
verkf EVERK Salesperson
telf1 TELFE Telephone
minbw MINBW Minimum value
zterm DZTERM Pyt Terms
inco1 INCO1 Incoterms
inco2 INCO2 Incoterms 2
webre WEBRE GR-Based IV
kzabs KZABS Acknowl. Reqd.
kalsk KALSK Schema Grp Supp
kzaut KZAUT Automatic PO
expvz EXPVZ Mode of Trans.
zolla DZOLLS Customs office
meprf MEPRF Pr. Date Cat.
ekgrp EKGRP Purch. Group
xersy XERSY ERS
plifz PLIFZ Pl. Deliv. Time
mrppp MRPPP_W Planning cal.
lfrhy LFRHY Planning Cycle
libes LIBES PO entry: supp.
lipre LIPRE Price mkg. sup.
liser LISER Rack jobbing
incov INCOV Inco. Version
inco2_l INCO2_L Inco. Location1
inco3_l INCO3_L Inco. Location2
weora WEORA Origin Accept.
inco2_key /SCMTMS/INC_LOC_1_KEY Incoterm Location 1
inco3_key /SCMTMS/INC_LOC_2_KEY Incoterm Location 2
inco4_key /SCMTMS/INC_DEV_PLACE_DEST_KEY Dev. Destination
prfre PRFRE_LH Price determin.
nrgew NRGEW Qualif. f. DKd
boind BOIND SS index active
blind BLIND Document Index
kzret KZRET Returns supplier
skrit SKRIT Sort criterion
bstae BSTAE Conf. Control
rdprf RDPRF Rnding Profile
megru MEGRU UoM Group
vensl VENSL Serv. Lvl
bopnr BOPNR LB profile
xersr XERSR Aut. GRSet Ret
eikto EIKTO_M Acc. w. supplier
abueb ABUEB Creation Profile
paprf WVMI_PAPRF PROACT control prof
agrel AGREL Settlem. Mgmt.
xnbwy XNBWY Revaluation
vsbed VSBED Shipping Conditions
lebre LEBRE Srv.-Based Inv. Ver.
bolre BOLRE Subseq. sett.
umsae UMSAE B.vol.comp./ag.
vendor_rma_req MSR_VRMA_REQ_LFM1 RMA Required
lfm1_eew_ps LFM1_EEW_PS Data Element Extensibility for purchase
source_recency MDC_RECENCY Last Changed On
source_modified MDC_SOURCE_MODIFIED Modified
source_modification_blip MDC_MODIFICATION_BLIP Modification
source_index MDC_SOURCE_INDEX Index
lifnr LIFNR Supplier
target_assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
aubel AUBEL Auto. debit
valid_pro VALID_PRO Settlement profile
hscabs HSCABS Absolute surcharge
hscpe HSCPE Percentage HSC
hscmin HSCMIN Minimum HSC
hscmax HSCMAX Max. HSC
fsh_sc_cid FSH_SC_CID Cust. Sup. ID
fsh_vas_detc FSH_VAS_DETC VAS Determin. Mode
j_1nboesl /NFM/BOESL Exchange Key
upprs UPPRS Subitem pricing
activity_profil WRF_PCTR_ACT_PROF Activity Profile
transport_chain WRF_PSCD_TC_ID Transportation Chain
staging_time WRF_PSCD_MST Staging Time

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Master Data Consolidation: Process Table for LFM1
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFM1_PRC (
    MANDT,                     -- Client [MANDT]
    PROCESS_ID,                -- Process ID [MDC_PROCESS_ID]
    PROCESS_STEP_NO,           -- Step Number [MDC_PROCESS_STEP_NO]
    SOURCE_SYSTEM,             -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                 -- Source ID [MDC_SOURCE_ID]
    EKORG,                     -- Purchasing Org. [EKORG]
    ASSIGNMENT_ID,             -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    ERDAT,                     -- Created On [ERDAT]
    ERNAM,                     -- Created By [ERNAM]
    SPERM,                     -- Pur. block POrg [SPERM_M]
    LOEVM,                     -- Del. flag POrg. [LOEVM_M]
    LFABC,                     -- ABC indicator [LFABC]
    WAERS,                     -- Order currency [BSTWA]
    VERKF,                     -- Salesperson [EVERK]
    TELF1,                     -- Telephone [TELFE]
    MINBW,                     -- Minimum value [MINBW]
    ZTERM,                     -- Pyt Terms [DZTERM]
    INCO1,                     -- Incoterms [INCO1]
    INCO2,                     -- Incoterms 2 [INCO2]
    WEBRE,                     -- GR-Based IV [WEBRE]
    KZABS,                     -- Acknowl. Reqd. [KZABS]
    KALSK,                     -- Schema Grp Supp [KALSK]
    KZAUT,                     -- Automatic PO [KZAUT]
    EXPVZ,                     -- Mode of Trans. [EXPVZ]
    ZOLLA,                     -- Customs office [DZOLLS]
    MEPRF,                     -- Pr. Date Cat. [MEPRF]
    EKGRP,                     -- Purch. Group [EKGRP]
    XERSY,                     -- ERS [XERSY]
    PLIFZ,                     -- Pl. Deliv. Time [PLIFZ]
    MRPPP,                     -- Planning cal. [MRPPP_W]
    LFRHY,                     -- Planning Cycle [LFRHY]
    LIBES,                     -- PO entry: supp. [LIBES]
    LIPRE,                     -- Price mkg. sup. [LIPRE]
    LISER,                     -- Rack jobbing [LISER]
    INCOV,                     -- Inco. Version [INCOV]
    INCO2_L,                   -- Inco. Location1 [INCO2_L]
    INCO3_L,                   -- Inco. Location2 [INCO3_L]
    WEORA,                     -- Origin Accept. [WEORA]
    INCO2_KEY,                 -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY]
    INCO3_KEY,                 -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY]
    INCO4_KEY,                 -- Dev. Destination [/SCMTMS/INC_DEV_PLACE_DEST_KEY]
    PRFRE,                     -- Price determin. [PRFRE_LH]
    NRGEW,                     -- Qualif. f. DKd [NRGEW]
    BOIND,                     -- SS index active [BOIND]
    BLIND,                     -- Document Index [BLIND]
    KZRET,                     -- Returns supplier [KZRET]
    SKRIT,                     -- Sort criterion [SKRIT]
    BSTAE,                     -- Conf. Control [BSTAE]
    RDPRF,                     -- Rnding Profile [RDPRF]
    MEGRU,                     -- UoM Group [MEGRU]
    VENSL,                     -- Serv. Lvl [VENSL]
    BOPNR,                     -- LB profile [BOPNR]
    XERSR,                     -- Aut. GRSet Ret [XERSR]
    EIKTO,                     -- Acc. w. supplier [EIKTO_M]
    ABUEB,                     -- Creation Profile [ABUEB]
    PAPRF,                     -- PROACT control prof [WVMI_PAPRF]
    AGREL,                     -- Settlem. Mgmt. [AGREL]
    XNBWY,                     -- Revaluation [XNBWY]
    VSBED,                     -- Shipping Conditions [VSBED]
    LEBRE,                     -- Srv.-Based Inv. Ver. [LEBRE]
    BOLRE,                     -- Subseq. sett. [BOLRE]
    UMSAE,                     -- B.vol.comp./ag. [UMSAE]
    VENDOR_RMA_REQ,            -- RMA Required [MSR_VRMA_REQ_LFM1]
    LFM1_EEW_PS,               -- Data Element Extensibility for purchase [LFM1_EEW_PS]
    SOURCE_RECENCY,            -- Last Changed On [MDC_RECENCY]
    SOURCE_MODIFIED,           -- Modified [MDC_SOURCE_MODIFIED]
    SOURCE_MODIFICATION_BLIP,  -- Modification [MDC_MODIFICATION_BLIP]
    SOURCE_INDEX,              -- Index [MDC_SOURCE_INDEX]
    LIFNR,                     -- Supplier [LIFNR]
    TARGET_ASSIGNMENT_ID,      -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    AUBEL,                     -- Auto. debit [AUBEL]
    VALID_PRO,                 -- Settlement profile [VALID_PRO]
    HSCABS,                    -- Absolute surcharge [HSCABS]
    HSCPE,                     -- Percentage HSC [HSCPE]
    HSCMIN,                    -- Minimum HSC [HSCMIN]
    HSCMAX,                    -- Max. HSC [HSCMAX]
    FSH_SC_CID,                -- Cust. Sup. ID [FSH_SC_CID]
    FSH_VAS_DETC,              -- VAS Determin. Mode [FSH_VAS_DETC]
    J_1NBOESL,                 -- Exchange Key [/NFM/BOESL]
    UPPRS,                     -- Subitem pricing [UPPRS]
    ACTIVITY_PROFIL,           -- Activity Profile [WRF_PCTR_ACT_PROF]
    TRANSPORT_CHAIN,           -- Transportation Chain [WRF_PSCD_TC_ID]
    STAGING_TIME,              -- Staging Time [WRF_PSCD_MST]
    PRIMARY KEY (MANDT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, EKORG, ASSIGNMENT_ID)
);

Learn More