LFM1
Vendor master record purchasing organization data
LFM1 is an SAP database table in S/4HANA. Vendor master record purchasing organization data. It contains 25 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SCMTMS/CV_SupplCustOrg | view | left_outer | View to get supplier and cust org data | |
| E_BPPURORG_D | view | from | EXTENSION | Extensibility BP Purchase Org Core |
| FNDEI_LFM1_BLOCKINGINFO | view | from | Blocking View for table LFM1 | |
| FNDEI_LFM1_FILTER | view | from | Filter View for table LFM1 | |
| FSH_V_Inforecord_Sos_B | view | inner | MM-PUR: Basic CDS View for SOS | |
| I_NominationSchedBPPurgOrgVH | view | from | BASIC | Nomination BP Purchasing Organization VH |
| I_SupplierPurchasingOrg | view | from | BASIC | Supplier Purchasing Organization |
| I_SupplierPurchOrg | view | from | BASIC | Vendor Details for Purchasing Org |
| m_v_inforecord_sos | view | inner | MM-PUR: CDS View for SOS | |
| M_V_Inforecord_Sos_B | view | inner | MM-PUR: Basic CDS View for SOS | |
| m_v_outline_agreement_sos | view | inner | MM-PUR: CDS View for SOS | |
| M_V_Outline_Agreement_Sos_B | view | left_outer | MM-PUR: Basic CDS View for SOS | |
| SHSM_M_KREDE | view | inner | CDS View replacing M_KREDE in search help KREDE |
Fields (25)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | lifnr | elifn | Supplier | |||
| KEY | ekorg | ekorg | Purchasing Org. | |||
| 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 |
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.
-- Vendor master record purchasing organization data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFM1 (
MANDT, -- Client [mandt]
LIFNR, -- Supplier [elifn]
EKORG, -- Purchasing Org. [ekorg]
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]
PRIMARY KEY (MANDT, LIFNR, EKORG)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA