LFM1_DFT

Transparent Table Application Table

Draft table for entity I_BPSUPLRPURCHASINGORGGOVTP

LFM1_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPSUPLRPURCHASINGORGGOVTP. It contains 56 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPSuplrPurchasingOrgGovDraft view_entity from EXTENSION BP Supplier Pruchasing Org Gov - Extension
R_BPSuplrPurchasingOrgGovDraft view_entity from BASIC Draft Access BP Supplier Purchasing Org

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesspartneruuid SYSUUID_X UUID
KEY suplrpurchasingorguuid 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.
mdchgprocessstep MDC_PROCESS_STEP_NO Step Number
purchasingorganizationforedit EKORG Purchasing Org.
bpassignmentid MDG_BP_ASSIGNMENT_ID Assignment ID
supplier LIFNR Supplier
purchasinggroup EKGRP Purch. Group
purchasingisblockedforsupplier SPERM_M Pur. block POrg
supplierrespsalespersonname EVERK Salesperson
supplierphonenumber TELFE Telephone
purchaseordercurrency BSTWA Order currency
minimumorderamount MINBW Minimum value
minimumorderamountcurrency BSTWA Order currency
calculationschemagroupcode KALSK Schema Grp Supp
paymentterms DZTERM Pyt Terms
pricingdatecontrol MEPRF Pr. Date Cat.
supplierabcclassificationcode LFABC ABC indicator
shippingcondition VSBED Shipping Conditions
purordautogenerationisallowed KZAUT Automatic PO
invoiceisgoodsreceiptbased WEBRE GR-Based IV
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
incotermsversion INCOV Inco. Version
incotermslocation1 INCO2_L Inco. Location1
incotermslocation2 INCO3_L Inco. Location2
deletionindicator LOEVM_M Del. flag POrg.
planneddeliverydurationindays PLIFZ Pl. Deliv. Time
supplierconfirmationcontrolkey BSTAE Conf. Control
isorderacknrqd KZABS Acknowl. Reqd.
evaldreceiptsettlementisactive XERSY ERS
automaticevaluatedrcptsettlmt XERSR Aut. GRSet Ret
supplieraccountnumber EIKTO_M Acc. w. supplier
suplrissubjtosubsqntsettlement BOLRE Subseq. sett.
suplrpurgorgagrmtofbusvolisrqd UMSAE B.vol.comp./ag.
suplrinvcrevalisallowed XNBWY Revaluation
suplrpurgorgisrlvtforpricedetn PRFRE_LH Price determin.
intrastatcrsbordertrmode EXPVZ Mode of Trans.
productunitgroup MEGRU UoM Group
roundingprofile RDPRF Rnding Profile
suplrdiscountinkindisgranted XFELD Checkbox
suplrisrlvtforsettlmtmgmt AGREL Settlem. Mgmt.
invoiceismmserviceentrybased LEBRE Srv.-Based Inv. Ver.
prodstockandslsdatatransfprfl WVMI_PAPRF PROACT control prof
masterdataiscurrent ABAP_BOOLEAN Truth Value
bpsupplierisnotinprocess ABAP_BOOLEAN Truth Value
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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_BPSUPLRPURCHASINGORGGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFM1_DFT (
    MANDT,                           -- Client [MANDT]
    BUSINESSPARTNERUUID,             -- UUID [SYSUUID_X]
    SUPLRPURCHASINGORGUUID,          -- 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]
    MDCHGPROCESSSTEP,                -- Step Number [MDC_PROCESS_STEP_NO]
    PURCHASINGORGANIZATIONFOREDIT,   -- Purchasing Org. [EKORG]
    BPASSIGNMENTID,                  -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    SUPPLIER,                        -- Supplier [LIFNR]
    PURCHASINGGROUP,                 -- Purch. Group [EKGRP]
    PURCHASINGISBLOCKEDFORSUPPLIER,  -- Pur. block POrg [SPERM_M]
    SUPPLIERRESPSALESPERSONNAME,     -- Salesperson [EVERK]
    SUPPLIERPHONENUMBER,             -- Telephone [TELFE]
    PURCHASEORDERCURRENCY,           -- Order currency [BSTWA]
    MINIMUMORDERAMOUNT,              -- Minimum value [MINBW]
    MINIMUMORDERAMOUNTCURRENCY,      -- Order currency [BSTWA]
    CALCULATIONSCHEMAGROUPCODE,      -- Schema Grp Supp [KALSK]
    PAYMENTTERMS,                    -- Pyt Terms [DZTERM]
    PRICINGDATECONTROL,              -- Pr. Date Cat. [MEPRF]
    SUPPLIERABCCLASSIFICATIONCODE,   -- ABC indicator [LFABC]
    SHIPPINGCONDITION,               -- Shipping Conditions [VSBED]
    PURORDAUTOGENERATIONISALLOWED,   -- Automatic PO [KZAUT]
    INVOICEISGOODSRECEIPTBASED,      -- GR-Based IV [WEBRE]
    INCOTERMSCLASSIFICATION,         -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [INCO2]
    INCOTERMSVERSION,                -- Inco. Version [INCOV]
    INCOTERMSLOCATION1,              -- Inco. Location1 [INCO2_L]
    INCOTERMSLOCATION2,              -- Inco. Location2 [INCO3_L]
    DELETIONINDICATOR,               -- Del. flag POrg. [LOEVM_M]
    PLANNEDDELIVERYDURATIONINDAYS,   -- Pl. Deliv. Time [PLIFZ]
    SUPPLIERCONFIRMATIONCONTROLKEY,  -- Conf. Control [BSTAE]
    ISORDERACKNRQD,                  -- Acknowl. Reqd. [KZABS]
    EVALDRECEIPTSETTLEMENTISACTIVE,  -- ERS [XERSY]
    AUTOMATICEVALUATEDRCPTSETTLMT,   -- Aut. GRSet Ret [XERSR]
    SUPPLIERACCOUNTNUMBER,           -- Acc. w. supplier [EIKTO_M]
    SUPLRISSUBJTOSUBSQNTSETTLEMENT,  -- Subseq. sett. [BOLRE]
    SUPLRPURGORGAGRMTOFBUSVOLISRQD,  -- B.vol.comp./ag. [UMSAE]
    SUPLRINVCREVALISALLOWED,         -- Revaluation [XNBWY]
    SUPLRPURGORGISRLVTFORPRICEDETN,  -- Price determin. [PRFRE_LH]
    INTRASTATCRSBORDERTRMODE,        -- Mode of Trans. [EXPVZ]
    PRODUCTUNITGROUP,                -- UoM Group [MEGRU]
    ROUNDINGPROFILE,                 -- Rnding Profile [RDPRF]
    SUPLRDISCOUNTINKINDISGRANTED,    -- Checkbox [XFELD]
    SUPLRISRLVTFORSETTLMTMGMT,       -- Settlem. Mgmt. [AGREL]
    INVOICEISMMSERVICEENTRYBASED,    -- Srv.-Based Inv. Ver. [LEBRE]
    PRODSTOCKANDSLSDATATRANSFPRFL,   -- PROACT control prof [WVMI_PAPRF]
    MASTERDATAISCURRENT,             -- Truth Value [ABAP_BOOLEAN]
    BPSUPPLIERISNOTINPROCESS,        -- Truth Value [ABAP_BOOLEAN]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, SUPLRPURCHASINGORGUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, PURCHASINGORGANIZATION)
);