LFA1_DFT

Transparent Table Application Table
61 Fields 2 CDS Views

Draft table for entity I_BPSUPPLIERGOVTP

LFA1_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPSUPPLIERGOVTP. It contains 61 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPSupplierGovernanceDraft view_entity from EXTENSION BP Supplier Governance - Extension
R_BPSupplierGovernanceDraft view_entity from BASIC Access BP Supplier

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartneruuid sysuuid_x UUID
KEY masterdatachangeprocess mdc_process_id Process ID
KEY mdchgprocesssrcesystem mdc_business_system Source System
KEY mdchgprocesssrceobject mdc_source_id Source ID
mdchgprocessstep mdc_process_step_no Step Number
bpassignmentid mdg_bp_assignment_id Assignment ID
supplier lifnr Supplier
trainstationname bahns Train station
authorizationgroup brgru Authorization
datamediumexchangeindicator dtams DME Rec. Code
dataexchangeinstructionkey dtaws Instruction Key
paytslipwthrefsubscriber esrnr ISR Number
suppliercorporategroup konzs Group
supplieraccountgroup ktokk Account group
customer kunnr Customer
alternativepayeeaccountnumber lnrza Alternat. Payee
deletionindicator loevm_x Deletion Flag
accountisblockedforposting sperb_x Posting Block
purchasingisblocked sperm_x Purch. block
bpisequalizationtaxsubject stkza Equalizatn tax
vatliability stkzu Liable for VAT
alternativepayeeisallowed xzemp Payee in doc.
tradingpartner rassc Trading Partner
fiscaladdress fiskn_k Fiscal address
supplierprocurementblock qsperrfkt Block Function
suplrqualitymanagementsystem qssys_ist Actual QM Sys.
supplierplant werks_ext Plant
supplierissubrangerelevant ltsna VSR relevant
supplierisplantrelevant werkr Plant relevant
factorycalendar fabkl Factory Calend.
responsibletype j_1afitp_d Tax Type
br_taxissplit j_1bindequ Tax split
brspcfctaxbasepercentagecode taxbs Tax Base
transpserviceagentststcgrp stgdl Stat.grp, agent
taxinvoicerepresentativename repres Rep's Name
businesstype gestyp Type of Business
industrytype indtyp Type of Industry
suppliercentraldeletionisblock nodel_x Deletion block
suplrqltyinprocmtcertfnvalidto qqssysdat QM System To
suplrproofofdelivrlvtcode podkzb POD-Relevant
suplrtaxauthorityaccountnumber fisku Tax Office
istobeacceptedatorigin weora Origin Accept.
referenceaccountgroup ktock Ref.Acct Group
paymentreason farp_payt_rsn Payment Reason
paymentisblockedforsupplier sperz Payment block
masterdataiscurrent abap_boolean Truth Value
datacontrollerset bu_xdcset Data Ctrlr. Set
datacontroller1 bu_data_controller Data Controller
datacontroller2 bu_data_controller Data Controller
datacontroller3 bu_data_controller Data Controller
datacontroller4 bu_data_controller Data Controller
datacontroller5 bu_data_controller Data Controller
datacontroller6 bu_data_controller Data Controller
datacontroller7 bu_data_controller Data Controller
datacontroller8 bu_data_controller Data Controller
datacontroller9 bu_data_controller Data Controller
datacontroller10 bu_data_controller Data Controller
etag mdc_process_update_token Update Token
mdchgprocesssourcemodified mdc_source_modified Modified
origin abap.char

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_BPSUPPLIERGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFA1_DFT (
    MANDT,                           -- Client [mandt]
    BUSINESSPARTNERUUID,             -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,         -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,          -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,          -- Source ID [mdc_source_id]
    MDCHGPROCESSSTEP,                -- Step Number [mdc_process_step_no]
    BPASSIGNMENTID,                  -- Assignment ID [mdg_bp_assignment_id]
    SUPPLIER,                        -- Supplier [lifnr]
    TRAINSTATIONNAME,                -- Train station [bahns]
    AUTHORIZATIONGROUP,              -- Authorization [brgru]
    DATAMEDIUMEXCHANGEINDICATOR,     -- DME Rec. Code [dtams]
    DATAEXCHANGEINSTRUCTIONKEY,      -- Instruction Key [dtaws]
    PAYTSLIPWTHREFSUBSCRIBER,        -- ISR Number [esrnr]
    SUPPLIERCORPORATEGROUP,          -- Group [konzs]
    SUPPLIERACCOUNTGROUP,            -- Account group [ktokk]
    CUSTOMER,                        -- Customer [kunnr]
    ALTERNATIVEPAYEEACCOUNTNUMBER,   -- Alternat. Payee [lnrza]
    DELETIONINDICATOR,               -- Deletion Flag [loevm_x]
    ACCOUNTISBLOCKEDFORPOSTING,      -- Posting Block [sperb_x]
    PURCHASINGISBLOCKED,             -- Purch. block [sperm_x]
    BPISEQUALIZATIONTAXSUBJECT,      -- Equalizatn tax [stkza]
    VATLIABILITY,                    -- Liable for VAT [stkzu]
    ALTERNATIVEPAYEEISALLOWED,       -- Payee in doc. [xzemp]
    TRADINGPARTNER,                  -- Trading Partner [rassc]
    FISCALADDRESS,                   -- Fiscal address [fiskn_k]
    SUPPLIERPROCUREMENTBLOCK,        -- Block Function [qsperrfkt]
    SUPLRQUALITYMANAGEMENTSYSTEM,    -- Actual QM Sys. [qssys_ist]
    SUPPLIERPLANT,                   -- Plant [werks_ext]
    SUPPLIERISSUBRANGERELEVANT,      -- VSR relevant [ltsna]
    SUPPLIERISPLANTRELEVANT,         -- Plant relevant [werkr]
    FACTORYCALENDAR,                 -- Factory Calend. [fabkl]
    RESPONSIBLETYPE,                 -- Tax Type [j_1afitp_d]
    BR_TAXISSPLIT,                   -- Tax split [j_1bindequ]
    BRSPCFCTAXBASEPERCENTAGECODE,    -- Tax Base [taxbs]
    TRANSPSERVICEAGENTSTSTCGRP,      -- Stat.grp, agent [stgdl]
    TAXINVOICEREPRESENTATIVENAME,    -- Rep's Name [repres]
    BUSINESSTYPE,                    -- Type of Business [gestyp]
    INDUSTRYTYPE,                    -- Type of Industry [indtyp]
    SUPPLIERCENTRALDELETIONISBLOCK,  -- Deletion block [nodel_x]
    SUPLRQLTYINPROCMTCERTFNVALIDTO,  -- QM System To [qqssysdat]
    SUPLRPROOFOFDELIVRLVTCODE,       -- POD-Relevant [podkzb]
    SUPLRTAXAUTHORITYACCOUNTNUMBER,  -- Tax Office [fisku]
    ISTOBEACCEPTEDATORIGIN,          -- Origin Accept. [weora]
    REFERENCEACCOUNTGROUP,           -- Ref.Acct Group [ktock]
    PAYMENTREASON,                   -- Payment Reason [farp_payt_rsn]
    PAYMENTISBLOCKEDFORSUPPLIER,     -- Payment block [sperz]
    MASTERDATAISCURRENT,             -- Truth Value [abap_boolean]
    DATACONTROLLERSET,               -- Data Ctrlr. Set [bu_xdcset]
    DATACONTROLLER1,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER2,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER3,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER4,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER5,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER6,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER7,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER8,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER9,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER10,                -- Data Controller [bu_data_controller]
    ETAG,                            -- Update Token [mdc_process_update_token]
    MDCHGPROCESSSOURCEMODIFIED,      -- Modified [mdc_source_modified]
    ORIGIN,                          -- abap.char
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT)
);

Learn More