KNB1_DFT

Transparent Table Application Table
64 Fields 2 CDS Views

Draft table for entity I_BPCUSTOMERCOMPANYGOVTP

KNB1_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPCUSTOMERCOMPANYGOVTP. It contains 64 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPCustomerCompanyGovDraft view_entity from EXTENSION BP Customer Company Gov - Extension
R_BPCustomerCompanyGovDraft view_entity from BASIC Draft BP Customer Company

Fields (64)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesspartneruuid SYSUUID_X UUID
KEY customercompanyuuid 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
companycodeforedit BUKRS Company Code
bpassignmentid MDG_BP_ASSIGNMENT_ID Assignment ID
mdchgprocessstep MDC_PROCESS_STEP_NO Step Number
customer KUNNR Customer
personnelnumber PERNR_D Personnel No.
physicalinventoryblockind SPERB_B Co.code post.block
deletionindicator LOEVM_B Co.Cde Deletion Flag
layoutsortingrule DZUAWA Sort key
accountingclerk BUSAB Clerk Abbrev.
reconciliationaccount AKONT Recon. account
authorizationgroup BRGRU Authorization
customerheadoffice KNRZE Head Office
alternativepayeraccount KNRZB Alternat.payer
paymentmethodslist DZWELS Payment Methods
customersupplierclearingisused XVERR_KNB1 Clrg with vend.
paymentblockingreason DZAHLS Payment Block
paymentterms DZTERM Pyt Terms
billexchchargepaymentterms WAKON BoE Chrges Trms
interestcalculationcode VZSKZ Interest Indic.
interestcalculationdate DZINDT Last Key Date
intrstcalcfrequencyinmonths DZINRT Int.Calc.Freq.
accountbycustomer EIKTO_D Acct at cust.
useratcustomer DZSABE_D Customer user
customeraccountnote KVERM Account Memo
cashplanninggroup FDGRV Planning Group
collectiveinvoicevariant PERKZ_KNB1 Coll.Invce.Var.
istobelocallyprocessed XDEZV Local Process.
bpperiodicaccountstatement XAUSZ Acct Statement
lastinterestcalcrundate DATLZ Last Int. Calc.
recordpaymenthistoryindicator XZVER Rec.Payt Hist.
apartolerancegroup TOGRU Tolerance Group
checkpaiddurationindays KULTG Chk cashng time
housebank HBKID House Bank
itemistobepaidseparately XPORE Individual Payt
custpreviousmasterrecordnumber ALTKN Prev.Acct No.
knownornegotiatedleave URLID Known/Neg.Leave
dunningnoticegroup MGRUP Grouping Key
lockboxinternalid LOCKB Lockbox
paymentmethodsupplement UZAWE Pmnt Meth. Sup.
buyinggroupaccountnumber EKVBD Buying Group
paytadviceissentbyedi XEDIP Pmt adv. by EDI
supplierreleasegroup FRGRP Release Group
accountingclerkfaxnumber TLFXS Clerk's fax
accountingclerkinternetaddress INTAD Clrk's internet
creditmemopaymentterms GUZTE Cr Memo Terms
valueadjustmentkey WBRSL Value Adj. Key
deletionisblocked NODEL_B CoCd del.block
accountingclerkphonenumber TLFNS Act.clk tel.no.
acctsreceivablepledgingcode CESSION_KZ AR Pledging Ind
paymentreason FARP_PAYT_RSN Payment Reason
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_BPCUSTOMERCOMPANYGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNB1_DFT (
    MANDT,                           -- Client [MANDT]
    BUSINESSPARTNERUUID,             -- UUID [SYSUUID_X]
    CUSTOMERCOMPANYUUID,             -- 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]
    COMPANYCODEFOREDIT,              -- Company Code [BUKRS]
    BPASSIGNMENTID,                  -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    MDCHGPROCESSSTEP,                -- Step Number [MDC_PROCESS_STEP_NO]
    CUSTOMER,                        -- Customer [KUNNR]
    PERSONNELNUMBER,                 -- Personnel No. [PERNR_D]
    PHYSICALINVENTORYBLOCKIND,       -- Co.code post.block [SPERB_B]
    DELETIONINDICATOR,               -- Co.Cde Deletion Flag [LOEVM_B]
    LAYOUTSORTINGRULE,               -- Sort key [DZUAWA]
    ACCOUNTINGCLERK,                 -- Clerk Abbrev. [BUSAB]
    RECONCILIATIONACCOUNT,           -- Recon. account [AKONT]
    AUTHORIZATIONGROUP,              -- Authorization [BRGRU]
    CUSTOMERHEADOFFICE,              -- Head Office [KNRZE]
    ALTERNATIVEPAYERACCOUNT,         -- Alternat.payer [KNRZB]
    PAYMENTMETHODSLIST,              -- Payment Methods [DZWELS]
    CUSTOMERSUPPLIERCLEARINGISUSED,  -- Clrg with vend. [XVERR_KNB1]
    PAYMENTBLOCKINGREASON,           -- Payment Block [DZAHLS]
    PAYMENTTERMS,                    -- Pyt Terms [DZTERM]
    BILLEXCHCHARGEPAYMENTTERMS,      -- BoE Chrges Trms [WAKON]
    INTERESTCALCULATIONCODE,         -- Interest Indic. [VZSKZ]
    INTERESTCALCULATIONDATE,         -- Last Key Date [DZINDT]
    INTRSTCALCFREQUENCYINMONTHS,     -- Int.Calc.Freq. [DZINRT]
    ACCOUNTBYCUSTOMER,               -- Acct at cust. [EIKTO_D]
    USERATCUSTOMER,                  -- Customer user [DZSABE_D]
    CUSTOMERACCOUNTNOTE,             -- Account Memo [KVERM]
    CASHPLANNINGGROUP,               -- Planning Group [FDGRV]
    COLLECTIVEINVOICEVARIANT,        -- Coll.Invce.Var. [PERKZ_KNB1]
    ISTOBELOCALLYPROCESSED,          -- Local Process. [XDEZV]
    BPPERIODICACCOUNTSTATEMENT,      -- Acct Statement [XAUSZ]
    LASTINTERESTCALCRUNDATE,         -- Last Int. Calc. [DATLZ]
    RECORDPAYMENTHISTORYINDICATOR,   -- Rec.Payt Hist. [XZVER]
    APARTOLERANCEGROUP,              -- Tolerance Group [TOGRU]
    CHECKPAIDDURATIONINDAYS,         -- Chk cashng time [KULTG]
    HOUSEBANK,                       -- House Bank [HBKID]
    ITEMISTOBEPAIDSEPARATELY,        -- Individual Payt [XPORE]
    CUSTPREVIOUSMASTERRECORDNUMBER,  -- Prev.Acct No. [ALTKN]
    KNOWNORNEGOTIATEDLEAVE,          -- Known/Neg.Leave [URLID]
    DUNNINGNOTICEGROUP,              -- Grouping Key [MGRUP]
    LOCKBOXINTERNALID,               -- Lockbox [LOCKB]
    PAYMENTMETHODSUPPLEMENT,         -- Pmnt Meth. Sup. [UZAWE]
    BUYINGGROUPACCOUNTNUMBER,        -- Buying Group [EKVBD]
    PAYTADVICEISSENTBYEDI,           -- Pmt adv. by EDI [XEDIP]
    SUPPLIERRELEASEGROUP,            -- Release Group [FRGRP]
    ACCOUNTINGCLERKFAXNUMBER,        -- Clerk's fax [TLFXS]
    ACCOUNTINGCLERKINTERNETADDRESS,  -- Clrk's internet [INTAD]
    CREDITMEMOPAYMENTTERMS,          -- Cr Memo Terms [GUZTE]
    VALUEADJUSTMENTKEY,              -- Value Adj. Key [WBRSL]
    DELETIONISBLOCKED,               -- CoCd del.block [NODEL_B]
    ACCOUNTINGCLERKPHONENUMBER,      -- Act.clk tel.no. [TLFNS]
    ACCTSRECEIVABLEPLEDGINGCODE,     -- AR Pledging Ind [CESSION_KZ]
    PAYMENTREASON,                   -- Payment Reason [FARP_PAYT_RSN]
    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, CUSTOMERCOMPANYUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, COMPANYCODE)
);

Learn More