LFM1_DFT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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