LFM1_ACT

Master Data Consolidation: Best Record Table for LFM1 | #masterdata | Component: Business Partner.
Column Name Description
MANDT Client
PARTNER Business Partner Number
EKORG Purchasing organization
ASSIGNMENT_ID Multiple Assignment ID (Number)
Column Name Description
💲 Purchase order currency (WAERS):
MINBW Minimum order value
Column Name Description
Column Name Description
ERDAT Date on which the record was created
Column Name Description
SPERM Purchasing block at purchasing organization level Show values
LOEVM Deletion Indicator for Supplier at Purchasing Level Show values
WEBRE Indicator: GR-Based Invoice Verification Show values
KZABS Order Acknowledgment Requirement Show values
KZAUT Automatic Generation of Purchase Order Allowed Show values
MEPRF Price Determination (Pricing) Date Control Show values
XERSY Evaluated Receipt Settlement (ERS) Show values
WEORA Acceptance At Origin Show values
PRFRE Indicator: "relev. to price determination (vend. hierarchy) Show values
BOIND Indicator: index compilation for subseq. settlement active Show values
BLIND Indicator: Doc. index compilation active for purchase orders Show values
KZRET Indicates whether supplier is returns supplier Show values
SKRIT Supplier sort criterion for materials Show values
XERSR Automatic evaluated receipt settlement for return items Show values
AGREL Indicator: Relevant for Settlement Management Show values
XNBWY Revaluation allowed Show values
LEBRE Indicator for Service-Based Invoice Verification Show values
BOLRE Indicator: supplier subject to subseq. settlement accounting Show values
UMSAE Comparison/agreement of business volumes necessary Show values
VENDOR_RMA_REQ Supplier RMA Number Required Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
LFABC ABC indicator LFABC
VERKF Responsible Salesperson at Supplier's Office TEXT30
TELF1 Supplier's Telephone Number TEXT16
ZTERM Terms of payment key ZTERM
INCO2 Incoterms (Part 2) INCO2
PLIFZ Planned Delivery Time in Days DEC3
LIBES Order entry by supplier CHAR1
LISER Rack-jobbing: supplier CHAR1
INCO2_L Incoterms Location 1 INCO_L
INCO3_L Incoterms Location 2 INCO_L
NRGEW Indicator whether discount in kind granted NRGEW
BSTAE Confirmation Control Key BSTAE
RDPRF Rounding Profile RDPRF
MEGRU Unit of Measure Group MEGRU
VENSL Supplier Service Level DEC3_1
BOPNR Restriction Profile for PO-Based Load Building CHAR4
EIKTO Our account number with the supplier CHAR12
ABUEB Release Creation Profile ABUEB
PAPRF Profile for transferring material data via IDoc PROACT WVMI_PAPRF
VSBED Shipping Conditions VSBED
RECENCY Master Data Consolidation: Recency TZNTSTMPS
SOURCE_RECENCY Master Data Consolidation: Recency TZNTSTMPS
TARGET_ASSIGNMENT_ID Multiple Assignment ID (Number) MDG_BP_ASSIGNMENT_ID
Master Data Relations Join Conditions
Purchasing Group
  • Purchasing Group
  • Client
  • LFM1_ACT.EKGRP == T024.EKGRP
  • LFM1_ACT.MANDT == T024.MANDT
Mode of Transport at the Border (Intrastat)
  • ?
  • Mode of Transport at the Border (Intrastat)
  • LFM1_ACT.MANDT == T618.MANDT
  • LFM1_ACT.[column in domain "/ECRS/RPCTY"] == T618.LAND1
  • LFM1_ACT.EXPVZ == T618.EXPVZ
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • LFM1_ACT.INCO1 == TINC.INCO1
  • LFM1_ACT.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • LFM1_ACT.INCOV == TINCV.INCOV
  • LFM1_ACT.MANDT == TINCV.MANDT
Group for Calculation Schema (Supplier)
  • Group for Calculation Schema (Supplier)
  • Client
  • LFM1_ACT.KALSK == TMKK.KALSK
  • LFM1_ACT.MANDT == TMKK.MANDT
Planning Cycle
  • Planning Cycle
  • ?
  • LFM1_ACT.MANDT == T439G.MANDT
  • LFM1_ACT.LFRHY == T439G.MRPPP
  • LFM1_ACT.[column in domain "WERKS_D"] == T439G.WERKS
Price marking, supplier
  • Price marking, supplier
  • Client
  • LFM1_ACT.LIPRE == TWYAZ.LIPRE
  • LFM1_ACT.MANDT == TWYAZ.MANDT
Planning Calendar
  • Planning Calendar
  • ?
  • LFM1_ACT.MANDT == T439G.MANDT
  • LFM1_ACT.MRPPP == T439G.MRPPP
  • LFM1_ACT.[column in domain "WERKS_D"] == T439G.WERKS
Purchase order currency
  • LFM1_ACT.MANDT == TCURC.MANDT
  • LFM1_ACT.WAERS == TCURC.WAERS
Customs Office: Office of Exit/Entry for Foreign Trade
  • Customs Office: Office of Exit/Entry for Foreign Trade
  • ?
  • Client
  • LFM1_ACT.ZOLLA == T615.ZOLLA
  • LFM1_ACT.[column in domain "LAND1"] == T615.LAND1
  • LFM1_ACT.MANDT == T615.MANDT