LFM2_DFT

Transparent Table Application Table
56 Fields 1 CDS Views

Draft table for entity I_BPSUPLRPURCHASINGDATAGOVTP

LFM2_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPSUPLRPURCHASINGDATAGOVTP. It contains 56 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPSupplierPurgDataGovDraft view_entity from BASIC Draft Access BP Supplier Purchasing Data

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartneruuid sysuuid_x UUID
KEY suplrpurchasingorguuid sysuuid_x UUID
KEY suplrpurchasingdatauuid sysuuid_x UUID
KEY masterdatachangeprocess mdc_process_id Process ID
KEY mdchgprocesssrcesystem mdc_business_system Source System
KEY mdchgprocesssrceobject mdc_source_id Source ID
KEY purchasingorganization ekorg Purchasing Org.
KEY suppliersubrange ltsnr Suppl. Subrange
KEY plant werks_d Plant
mdchgprocessstep mdc_process_step_no Step Number
bpassignmentid mdg_bp_assignment_id Assignment ID
supplier lifnr Supplier
purchasingorganizationforedit ekorg Purchasing Org.
suppliersubrangeforedit ltsnr Suppl. Subrange
plantforedit werks_d Plant
purchasingisblockedforsupplier sperm_m Pur. block POrg
deletionindicator loevm_m Del. flag POrg.
supplierabcclassificationcode lfabc ABC indicator
purchaseordercurrency bstwa Order currency
supplierrespsalespersonname everk Salesperson
minimumorderamount minbw Minimum value
minimumorderamountcurrency bstwa Order currency
paymentterms dzterm Pyt Terms
incotermsclassification inco1 Incoterms
incotermstransferlocation inco2 Incoterms 2
invoiceisgoodsreceiptbased webre GR-Based IV
isorderacknrqd kzabs Acknowl. Reqd.
calculationschemagroupcode kalsk Schema Grp Supp
purordautogenerationisallowed kzaut Automatic PO
intrastatcrsbordertrmode expvz Mode of Trans.
purgoutlineagrmtcustomsoffice dzolls Customs office
pricingdatecontrol meprf Pr. Date Cat.
purchasinggroup ekgrp Purch. Group
evaldreceiptsettlementisactive xersy ERS
planneddeliverydurationindays plifz Pl. Deliv. Time
mrpplanningcalendar mrppp_w Planning cal.
planningcycle lfrhy Planning Cycle
orderentryisbysupplier libes PO entry: supp.
pricemarkingagreement lipre Price mkg. sup.
supplierisrackjobbing liser Rack jobbing
incotermsversion incov Inco. Version
incotermslocation1 inco2_l Inco. Location1
incotermslocation2 inco3_l Inco. Location2
mrpresponsible dispo MRP Controller
supplierconfirmationcontrolkey bstae Conf. Control
roundingprofile rdprf Rnding Profile
productunitgroup megru UoM Group
automaticevaluatedrcptsettlmt xersr Aut. GRSet Ret
prodstockandslsdatatransfprfl wvmi_paprf PROACT control prof
suplrinvcrevalisallowed xnbwy Revaluation
invoiceismmserviceentrybased lebre Srv.-Based Inv. Ver.
suplrissubjtosubsqntsettlement bolre_unused Subseq. Settlmt
suplrpurgorgagrmtofbusvolisrqd umsae_unused BVC
supplierphonenumber telfe Telephone
masterdataiscurrent abap_boolean Truth Value

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.

-- Draft table for entity I_BPSUPLRPURCHASINGDATAGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFM2_DFT (
    MANDT,                           -- Client [mandt]
    BUSINESSPARTNERUUID,             -- UUID [sysuuid_x]
    SUPLRPURCHASINGORGUUID,          -- UUID [sysuuid_x]
    SUPLRPURCHASINGDATAUUID,         -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,         -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,          -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,          -- Source ID [mdc_source_id]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    SUPPLIERSUBRANGE,                -- Suppl. Subrange [ltsnr]
    PLANT,                           -- Plant [werks_d]
    MDCHGPROCESSSTEP,                -- Step Number [mdc_process_step_no]
    BPASSIGNMENTID,                  -- Assignment ID [mdg_bp_assignment_id]
    SUPPLIER,                        -- Supplier [lifnr]
    PURCHASINGORGANIZATIONFOREDIT,   -- Purchasing Org. [ekorg]
    SUPPLIERSUBRANGEFOREDIT,         -- Suppl. Subrange [ltsnr]
    PLANTFOREDIT,                    -- Plant [werks_d]
    PURCHASINGISBLOCKEDFORSUPPLIER,  -- Pur. block POrg [sperm_m]
    DELETIONINDICATOR,               -- Del. flag POrg. [loevm_m]
    SUPPLIERABCCLASSIFICATIONCODE,   -- ABC indicator [lfabc]
    PURCHASEORDERCURRENCY,           -- Order currency [bstwa]
    SUPPLIERRESPSALESPERSONNAME,     -- Salesperson [everk]
    MINIMUMORDERAMOUNT,              -- Minimum value [minbw]
    MINIMUMORDERAMOUNTCURRENCY,      -- Order currency [bstwa]
    PAYMENTTERMS,                    -- Pyt Terms [dzterm]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [inco2]
    INVOICEISGOODSRECEIPTBASED,      -- GR-Based IV [webre]
    ISORDERACKNRQD,                  -- Acknowl. Reqd. [kzabs]
    CALCULATIONSCHEMAGROUPCODE,      -- Schema Grp Supp [kalsk]
    PURORDAUTOGENERATIONISALLOWED,   -- Automatic PO [kzaut]
    INTRASTATCRSBORDERTRMODE,        -- Mode of Trans. [expvz]
    PURGOUTLINEAGRMTCUSTOMSOFFICE,   -- Customs office [dzolls]
    PRICINGDATECONTROL,              -- Pr. Date Cat. [meprf]
    PURCHASINGGROUP,                 -- Purch. Group [ekgrp]
    EVALDRECEIPTSETTLEMENTISACTIVE,  -- ERS [xersy]
    PLANNEDDELIVERYDURATIONINDAYS,   -- Pl. Deliv. Time [plifz]
    MRPPLANNINGCALENDAR,             -- Planning cal. [mrppp_w]
    PLANNINGCYCLE,                   -- Planning Cycle [lfrhy]
    ORDERENTRYISBYSUPPLIER,          -- PO entry: supp. [libes]
    PRICEMARKINGAGREEMENT,           -- Price mkg. sup. [lipre]
    SUPPLIERISRACKJOBBING,           -- Rack jobbing [liser]
    INCOTERMSVERSION,                -- Inco. Version [incov]
    INCOTERMSLOCATION1,              -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,              -- Inco. Location2 [inco3_l]
    MRPRESPONSIBLE,                  -- MRP Controller [dispo]
    SUPPLIERCONFIRMATIONCONTROLKEY,  -- Conf. Control [bstae]
    ROUNDINGPROFILE,                 -- Rnding Profile [rdprf]
    PRODUCTUNITGROUP,                -- UoM Group [megru]
    AUTOMATICEVALUATEDRCPTSETTLMT,   -- Aut. GRSet Ret [xersr]
    PRODSTOCKANDSLSDATATRANSFPRFL,   -- PROACT control prof [wvmi_paprf]
    SUPLRINVCREVALISALLOWED,         -- Revaluation [xnbwy]
    INVOICEISMMSERVICEENTRYBASED,    -- Srv.-Based Inv. Ver. [lebre]
    SUPLRISSUBJTOSUBSQNTSETTLEMENT,  -- Subseq. Settlmt [bolre_unused]
    SUPLRPURGORGAGRMTOFBUSVOLISRQD,  -- BVC [umsae_unused]
    SUPPLIERPHONENUMBER,             -- Telephone [telfe]
    MASTERDATAISCURRENT,             -- Truth Value [abap_boolean]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, SUPLRPURCHASINGORGUUID, SUPLRPURCHASINGDATAUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, PURCHASINGORGANIZATION, SUPPLIERSUBRANGE, PLANT)
);

Learn More