BUPA_CUSTCO_D

Transparent Table Application Table
66 Fields 1 CDS Views

Draft table for entity I_CUSTOMERCOMPANYCODETP

BUPA_CUSTCO_D is an SAP database table in S/4HANA. Draft table for entity I_CUSTOMERCOMPANYCODETP. It contains 66 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CustomerCompanyCodeDraft view_entity from BASIC Customer Company Code - Draft

Fields (66)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY companycode BUKRS Company Code
KEY businesspartner BU_PARTNER Busn. Partner
KEY customer KUNNR Customer
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
companycodeforedit BUKRS Company Code
businesspartneruuid BU_PARTNER_GUID BP GUID
accountingclerk BUSAB Clerk Abbrev.
reconciliationaccount AKONT Recon. account
authorizationgroup BRGRU Authorization
customerheadoffice KNRZE Head Office
alternativepayeraccount KNRZB Alternat.payer
paymentblockingreason DZAHLS Payment Block
interestcalculationcode VZSKZ Interest Indic.
interestcalculationdate DZINDT Last Key Date
intrstcalcfrequencyinmonths DZINRT Int.Calc.Freq.
lastinterestcalcrundate DATLZ Last Int. Calc.
customeraccountnote KVERM Account Memo
apartolerancegroup TOGRU Tolerance Group
housebank HBKID House Bank
itemistobepaidseparately XPORE Individual Payt
paytadviceissentbyedi XEDIP Pmt adv. by EDI
physicalinventoryblockind SPERB_B Co.code post.block
useratcustomer DZSABE_D Customer user
accountingclerkphonenumber TLFNS Act.clk tel.no.
accountingclerkfaxnumber TLFXS Clerk's fax
accountingclerkinternetaddress INTAD Clrk's internet
accountbycustomer EIKTO_D Acct at cust.
istobelocallyprocessed XDEZV Local Process.
collectiveinvoicevariant PERKZ_KNB1 Coll.Invce.Var.
layoutsortingrule DZUAWA Sort key
paymentterms DZTERM Pyt Terms
creditmemopaymentterms GUZTE Cr Memo Terms
customersupplierclearingisused XVERR_KNB1 Clrg with vend.
recordpaymenthistoryindicator XZVER Rec.Payt Hist.
paymentmethodslist DZWELS Payment Methods
cashplanninggroup FDGRV Planning Group
withholdingtaxcountry QLAND WTax C/R Key
valueadjustmentkey WBRSL Value Adj. Key
knownornegotiatedleave URLID Known/Neg.Leave
extendedwhldgtaxisactive WT_NEWWT Extended WTax Active
country LAND1 Country/Reg.
companycodename BUTXT Company Name
supplierreleasegroup FRGRP Release Group
personnelnumber PERNR_D Personnel No.
buyinggroupaccountnumber EKVBD Buying Group
billexchchargepaymentterms WAKON BoE Chrges Trms
checkpaiddurationindays KULTG Chk cashng time
customerpaymentblockingreason DZAHLS Payment Block
paymentmethodsupplement UZAWE Pmnt Meth. Sup.
acctsreceivablepledgingcode CESSION_KZ AR Pledging Ind
lockboxinternalid LOCKB Lockbox
custpreviousmasterrecordnumber ALTKN Prev.Acct No.
paymentclearinggroup FAR_PAYMENT_CLEARING_GROUP Payment Clrg Grp ID
paymentreason FARP_PAYT_RSN Payment Reason
deletionisblocked NODEL_B CoCd del.block
bphasactiveentity SDRAFT_IS_ACTIVE Is active
isbusinesspurposecompleted BU_XPCPT Purpose Completed
businesspartnerdraftuuid SDRAFT_UUID Draft Document ID
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_CUSTOMERCOMPANYCODETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_CUSTCO_D (
    MANDT,                           -- Client [MANDT]
    COMPANYCODE,                     -- Company Code [BUKRS]
    BUSINESSPARTNER,                 -- Busn. Partner [BU_PARTNER]
    CUSTOMER,                        -- Customer [KUNNR]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    COMPANYCODEFOREDIT,              -- Company Code [BUKRS]
    BUSINESSPARTNERUUID,             -- BP GUID [BU_PARTNER_GUID]
    ACCOUNTINGCLERK,                 -- Clerk Abbrev. [BUSAB]
    RECONCILIATIONACCOUNT,           -- Recon. account [AKONT]
    AUTHORIZATIONGROUP,              -- Authorization [BRGRU]
    CUSTOMERHEADOFFICE,              -- Head Office [KNRZE]
    ALTERNATIVEPAYERACCOUNT,         -- Alternat.payer [KNRZB]
    PAYMENTBLOCKINGREASON,           -- Payment Block [DZAHLS]
    INTERESTCALCULATIONCODE,         -- Interest Indic. [VZSKZ]
    INTERESTCALCULATIONDATE,         -- Last Key Date [DZINDT]
    INTRSTCALCFREQUENCYINMONTHS,     -- Int.Calc.Freq. [DZINRT]
    LASTINTERESTCALCRUNDATE,         -- Last Int. Calc. [DATLZ]
    CUSTOMERACCOUNTNOTE,             -- Account Memo [KVERM]
    APARTOLERANCEGROUP,              -- Tolerance Group [TOGRU]
    HOUSEBANK,                       -- House Bank [HBKID]
    ITEMISTOBEPAIDSEPARATELY,        -- Individual Payt [XPORE]
    PAYTADVICEISSENTBYEDI,           -- Pmt adv. by EDI [XEDIP]
    PHYSICALINVENTORYBLOCKIND,       -- Co.code post.block [SPERB_B]
    USERATCUSTOMER,                  -- Customer user [DZSABE_D]
    ACCOUNTINGCLERKPHONENUMBER,      -- Act.clk tel.no. [TLFNS]
    ACCOUNTINGCLERKFAXNUMBER,        -- Clerk's fax [TLFXS]
    ACCOUNTINGCLERKINTERNETADDRESS,  -- Clrk's internet [INTAD]
    ACCOUNTBYCUSTOMER,               -- Acct at cust. [EIKTO_D]
    ISTOBELOCALLYPROCESSED,          -- Local Process. [XDEZV]
    COLLECTIVEINVOICEVARIANT,        -- Coll.Invce.Var. [PERKZ_KNB1]
    LAYOUTSORTINGRULE,               -- Sort key [DZUAWA]
    PAYMENTTERMS,                    -- Pyt Terms [DZTERM]
    CREDITMEMOPAYMENTTERMS,          -- Cr Memo Terms [GUZTE]
    CUSTOMERSUPPLIERCLEARINGISUSED,  -- Clrg with vend. [XVERR_KNB1]
    RECORDPAYMENTHISTORYINDICATOR,   -- Rec.Payt Hist. [XZVER]
    PAYMENTMETHODSLIST,              -- Payment Methods [DZWELS]
    CASHPLANNINGGROUP,               -- Planning Group [FDGRV]
    WITHHOLDINGTAXCOUNTRY,           -- WTax C/R Key [QLAND]
    VALUEADJUSTMENTKEY,              -- Value Adj. Key [WBRSL]
    KNOWNORNEGOTIATEDLEAVE,          -- Known/Neg.Leave [URLID]
    EXTENDEDWHLDGTAXISACTIVE,        -- Extended WTax Active [WT_NEWWT]
    COUNTRY,                         -- Country/Reg. [LAND1]
    COMPANYCODENAME,                 -- Company Name [BUTXT]
    SUPPLIERRELEASEGROUP,            -- Release Group [FRGRP]
    PERSONNELNUMBER,                 -- Personnel No. [PERNR_D]
    BUYINGGROUPACCOUNTNUMBER,        -- Buying Group [EKVBD]
    BILLEXCHCHARGEPAYMENTTERMS,      -- BoE Chrges Trms [WAKON]
    CHECKPAIDDURATIONINDAYS,         -- Chk cashng time [KULTG]
    CUSTOMERPAYMENTBLOCKINGREASON,   -- Payment Block [DZAHLS]
    PAYMENTMETHODSUPPLEMENT,         -- Pmnt Meth. Sup. [UZAWE]
    ACCTSRECEIVABLEPLEDGINGCODE,     -- AR Pledging Ind [CESSION_KZ]
    LOCKBOXINTERNALID,               -- Lockbox [LOCKB]
    CUSTPREVIOUSMASTERRECORDNUMBER,  -- Prev.Acct No. [ALTKN]
    PAYMENTCLEARINGGROUP,            -- Payment Clrg Grp ID [FAR_PAYMENT_CLEARING_GROUP]
    PAYMENTREASON,                   -- Payment Reason [FARP_PAYT_RSN]
    DELETIONISBLOCKED,               -- CoCd del.block [NODEL_B]
    BPHASACTIVEENTITY,               -- Is active [SDRAFT_IS_ACTIVE]
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [BU_XPCPT]
    BUSINESSPARTNERDRAFTUUID,        -- Draft Document ID [SDRAFT_UUID]
    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, COMPANYCODE, BUSINESSPARTNER, CUSTOMER, DRAFTUUID)
);

Learn More