LFB1_DFT

Transparent Table Application Table
60 Fields 2 CDS Views

Draft table for entity I_BPSUPPLIERCOMPANYGOVTP

LFB1_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPSUPPLIERCOMPANYGOVTP. It contains 60 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPSupplierCompanyGovDraft view_entity from EXTENSION BP Supplier Company Gov - Extension
R_BPSupplierCompanyGovDraft view_entity from BASIC Draft Access BP Supplier Company

Fields (60)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesspartneruuid SYSUUID_X UUID
KEY suppliercompanyuuid 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 companycode BUKRS Company Code
mdchgprocessstep MDC_PROCESS_STEP_NO Step Number
companycodeforedit BUKRS Company Code
bpassignmentid MDG_BP_ASSIGNMENT_ID Assignment ID
supplier LIFNR Supplier
personnelnumber PERNR_D Personnel No.
supplierisblockedforposting SPERB_B Co.code post.block
deletionindicator LOEVM_B Co.Cde Deletion Flag
layoutsortingrule DZUAWA Sort key
reconciliationaccount AKONT Recon. account
authorizationgroup BRGRU Authorization
interestcalculationcode VZSKZ Interest Indic.
paymentmethodslist DZWELS Payment Methods
clearcustomersupplier XVERR_LFB1 Clrg with Cust.
paymentblockingreason DZAHLS Payment Block
paymentterms DZTERM Pyt Terms
supplierclerkidbysupplier EIKTO_K Acct w/ vendor
supplierclerk DZSABE_K Clerk at vendor
supplieraccountnote KVERM Account Memo
cashplanninggroup FDGRV Planning Group
accountingclerk BUSAB Clerk Abbrev.
supplierheadoffice LNRZE Head Office
alternativepayee LNRZB Alternat.payee
interestcalculationdate DZINDT Last Key Date
intrstcalcfrequencyinmonths DZINRT Int.Calc.Freq.
lastinterestcalcrundate DATLZ Last Int. Calc.
istobelocallyprocessed XDEZV Local Process.
currency WAERS Currency
billofexchlmtamtincocodecrcy WEBTR_CS Bill/Ex. Limit
checkpaiddurationindays KULTG Chk cashng time
isdoubleinvoice REPRF Chk Double Inv.
apartolerancegroup TOGRU Tolerance Group
housebank HBKID House Bank
itemistobepaidseparately XPORE Individual Payt
minoritygroup MINDK Minority Indic.
previousaccountnumber ALTKN Prev.Acct No.
paymentmethodsupplement UZAWE Pmnt Meth. Sup.
withholdingtaxcountry QLAND WTax C/R Key
paymentistobesentbyedi XEDIP Pmt adv. by EDI
supplierreleasegroup FRGRP Release Group
suplrinvcverificattolgroup TOGRR Tolerance Grp
accountingclerkfaxnumber TLFXS Clerk's fax
accountingclerkinternetaddress INTAD Clrk's internet
creditmemopaymentterms GUZTE Cr Memo Terms
suppliercertificationdate CERDT Certifictn Date
deletionisblocked NODEL_B CoCd del.block
accountingclerkphonenumber TLFNS Act.clk tel.no.
masterdataiscurrent 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_BPSUPPLIERCOMPANYGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFB1_DFT (
    MANDT,                           -- Client [MANDT]
    BUSINESSPARTNERUUID,             -- UUID [SYSUUID_X]
    SUPPLIERCOMPANYUUID,             -- UUID [SYSUUID_X]
    MASTERDATACHANGEPROCESS,         -- Process ID [MDC_PROCESS_ID]
    MDCHGPROCESSSRCESYSTEM,          -- Source System [MDC_BUSINESS_SYSTEM]
    MDCHGPROCESSSRCEOBJECT,          -- Source ID [MDC_SOURCE_ID]
    COMPANYCODE,                     -- Company Code [BUKRS]
    MDCHGPROCESSSTEP,                -- Step Number [MDC_PROCESS_STEP_NO]
    COMPANYCODEFOREDIT,              -- Company Code [BUKRS]
    BPASSIGNMENTID,                  -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    SUPPLIER,                        -- Supplier [LIFNR]
    PERSONNELNUMBER,                 -- Personnel No. [PERNR_D]
    SUPPLIERISBLOCKEDFORPOSTING,     -- Co.code post.block [SPERB_B]
    DELETIONINDICATOR,               -- Co.Cde Deletion Flag [LOEVM_B]
    LAYOUTSORTINGRULE,               -- Sort key [DZUAWA]
    RECONCILIATIONACCOUNT,           -- Recon. account [AKONT]
    AUTHORIZATIONGROUP,              -- Authorization [BRGRU]
    INTERESTCALCULATIONCODE,         -- Interest Indic. [VZSKZ]
    PAYMENTMETHODSLIST,              -- Payment Methods [DZWELS]
    CLEARCUSTOMERSUPPLIER,           -- Clrg with Cust. [XVERR_LFB1]
    PAYMENTBLOCKINGREASON,           -- Payment Block [DZAHLS]
    PAYMENTTERMS,                    -- Pyt Terms [DZTERM]
    SUPPLIERCLERKIDBYSUPPLIER,       -- Acct w/ vendor [EIKTO_K]
    SUPPLIERCLERK,                   -- Clerk at vendor [DZSABE_K]
    SUPPLIERACCOUNTNOTE,             -- Account Memo [KVERM]
    CASHPLANNINGGROUP,               -- Planning Group [FDGRV]
    ACCOUNTINGCLERK,                 -- Clerk Abbrev. [BUSAB]
    SUPPLIERHEADOFFICE,              -- Head Office [LNRZE]
    ALTERNATIVEPAYEE,                -- Alternat.payee [LNRZB]
    INTERESTCALCULATIONDATE,         -- Last Key Date [DZINDT]
    INTRSTCALCFREQUENCYINMONTHS,     -- Int.Calc.Freq. [DZINRT]
    LASTINTERESTCALCRUNDATE,         -- Last Int. Calc. [DATLZ]
    ISTOBELOCALLYPROCESSED,          -- Local Process. [XDEZV]
    CURRENCY,                        -- Currency [WAERS]
    BILLOFEXCHLMTAMTINCOCODECRCY,    -- Bill/Ex. Limit [WEBTR_CS]
    CHECKPAIDDURATIONINDAYS,         -- Chk cashng time [KULTG]
    ISDOUBLEINVOICE,                 -- Chk Double Inv. [REPRF]
    APARTOLERANCEGROUP,              -- Tolerance Group [TOGRU]
    HOUSEBANK,                       -- House Bank [HBKID]
    ITEMISTOBEPAIDSEPARATELY,        -- Individual Payt [XPORE]
    MINORITYGROUP,                   -- Minority Indic. [MINDK]
    PREVIOUSACCOUNTNUMBER,           -- Prev.Acct No. [ALTKN]
    PAYMENTMETHODSUPPLEMENT,         -- Pmnt Meth. Sup. [UZAWE]
    WITHHOLDINGTAXCOUNTRY,           -- WTax C/R Key [QLAND]
    PAYMENTISTOBESENTBYEDI,          -- Pmt adv. by EDI [XEDIP]
    SUPPLIERRELEASEGROUP,            -- Release Group [FRGRP]
    SUPLRINVCVERIFICATTOLGROUP,      -- Tolerance Grp [TOGRR]
    ACCOUNTINGCLERKFAXNUMBER,        -- Clerk's fax [TLFXS]
    ACCOUNTINGCLERKINTERNETADDRESS,  -- Clrk's internet [INTAD]
    CREDITMEMOPAYMENTTERMS,          -- Cr Memo Terms [GUZTE]
    SUPPLIERCERTIFICATIONDATE,       -- Certifictn Date [CERDT]
    DELETIONISBLOCKED,               -- CoCd del.block [NODEL_B]
    ACCOUNTINGCLERKPHONENUMBER,      -- Act.clk tel.no. [TLFNS]
    MASTERDATAISCURRENT,             -- 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, SUPPLIERCOMPANYUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, COMPANYCODE)
);

Learn More