BUPA_SUPPCO_D

Transparent Table Application Table
66 Fields 1 CDS Views

Draft table for entity I_SUPPLIERCOMPANYCODETP

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SupplierCompanyCodeDraft view_entity from BASIC Supplier Company Code - Draft

Fields (66)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesspartner BU_PARTNER Busn. Partner
KEY companycode BUKRS Company Code
KEY supplier LIFNR Supplier
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
businesspartneruuid BU_PARTNER_GUID BP GUID
companycodeforedit BUKRS Company Code
businesspartnerforedit BU_PARTNER Busn. Partner
supplierisblockedforposting SPERB_B Co.code post.block
authorizationgroup BRGRU Authorization
accountingclerk BUSAB Clerk Abbrev.
supplierclerk DZSABE_K Clerk at vendor
accountingclerkphonenumber TLFNS Act.clk tel.no.
accountingclerkfaxnumber TLFXS Clerk's fax
accountingclerkinternetaddress INTAD Clrk's internet
supplierclerkidbysupplier EIKTO_K Acct w/ vendor
istobelocallyprocessed XDEZV Local Process.
supplieraccountnote KVERM Account Memo
paymentterms DZTERM Pyt Terms
apartolerancegroup TOGRU Tolerance Group
suplrinvcverificattolgroup TOGRR Tolerance Grp
checkpaiddurationindays KULTG Chk cashng time
isdoubleinvoice REPRF Chk Double Inv.
customersupplierclearingisused XVERR_LFB1 Clrg with Cust.
reconciliationaccount AKONT Recon. account
supplierheadoffice LNRZE Head Office
layoutsortingrule DZUAWA Sort key
suppliercertificationdate CERDT Certifictn Date
paymentmethodslist DZWELS Payment Methods
cashplanninggroup FDGRV Planning Group
paymentblockingreason DZAHLS Payment Block
alternativepayee LNRZB Alternat.payee
housebank HBKID House Bank
billofexchlmtamtincocodecrcy WEBTR_CS Bill/Ex. Limit
itemistobepaidseparately XPORE Individual Payt
paymentistobesentbyedi XEDIP Pmt adv. by EDI
withholdingtaxcountry QLAND WTax C/R Key
interestcalculationcode VZSKZ Interest Indic.
interestcalculationdate DZINDT Last Key Date
intrstcalcfrequencyinmonths DZINRT Int.Calc.Freq.
lastinterestcalcrundate DATLZ Last Int. Calc.
supplierreleasegroup FRGRP Release Group
creditmemopaymentterms GUZTE Cr Memo Terms
paymentmethodsupplement UZAWE Pmnt Meth. Sup.
paymentclearinggroup FAR_PAYMENT_CLEARING_GROUP Payment Clrg Grp ID
previousaccountnumber ALTKN Prev.Acct No.
paymentreason FARP_PAYT_RSN Payment Reason
deletionisblocked NODEL_B CoCd del.block
extendedwhldgtaxisactive WT_NEWWT Extended WTax Active
personnelnumber PERNR_D Personnel No.
country LAND1 Country/Reg.
companycodename BUTXT Company Name
bphasactiveentity SDRAFT_IS_ACTIVE Is active
isbusinesspurposecompleted CVP_XBLCK Purpose Completed
currency WAERS Currency
minoritygroup MINDK Minority Indic.
deletionindicator LOEVM_B Co.Cde Deletion Flag
supplieraccountgroup KTOKK Account group
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_SUPPLIERCOMPANYCODETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_SUPPCO_D (
    MANDT,                           -- Client [MANDT]
    BUSINESSPARTNER,                 -- Busn. Partner [BU_PARTNER]
    COMPANYCODE,                     -- Company Code [BUKRS]
    SUPPLIER,                        -- Supplier [LIFNR]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    BUSINESSPARTNERUUID,             -- BP GUID [BU_PARTNER_GUID]
    COMPANYCODEFOREDIT,              -- Company Code [BUKRS]
    BUSINESSPARTNERFOREDIT,          -- Busn. Partner [BU_PARTNER]
    SUPPLIERISBLOCKEDFORPOSTING,     -- Co.code post.block [SPERB_B]
    AUTHORIZATIONGROUP,              -- Authorization [BRGRU]
    ACCOUNTINGCLERK,                 -- Clerk Abbrev. [BUSAB]
    SUPPLIERCLERK,                   -- Clerk at vendor [DZSABE_K]
    ACCOUNTINGCLERKPHONENUMBER,      -- Act.clk tel.no. [TLFNS]
    ACCOUNTINGCLERKFAXNUMBER,        -- Clerk's fax [TLFXS]
    ACCOUNTINGCLERKINTERNETADDRESS,  -- Clrk's internet [INTAD]
    SUPPLIERCLERKIDBYSUPPLIER,       -- Acct w/ vendor [EIKTO_K]
    ISTOBELOCALLYPROCESSED,          -- Local Process. [XDEZV]
    SUPPLIERACCOUNTNOTE,             -- Account Memo [KVERM]
    PAYMENTTERMS,                    -- Pyt Terms [DZTERM]
    APARTOLERANCEGROUP,              -- Tolerance Group [TOGRU]
    SUPLRINVCVERIFICATTOLGROUP,      -- Tolerance Grp [TOGRR]
    CHECKPAIDDURATIONINDAYS,         -- Chk cashng time [KULTG]
    ISDOUBLEINVOICE,                 -- Chk Double Inv. [REPRF]
    CUSTOMERSUPPLIERCLEARINGISUSED,  -- Clrg with Cust. [XVERR_LFB1]
    RECONCILIATIONACCOUNT,           -- Recon. account [AKONT]
    SUPPLIERHEADOFFICE,              -- Head Office [LNRZE]
    LAYOUTSORTINGRULE,               -- Sort key [DZUAWA]
    SUPPLIERCERTIFICATIONDATE,       -- Certifictn Date [CERDT]
    PAYMENTMETHODSLIST,              -- Payment Methods [DZWELS]
    CASHPLANNINGGROUP,               -- Planning Group [FDGRV]
    PAYMENTBLOCKINGREASON,           -- Payment Block [DZAHLS]
    ALTERNATIVEPAYEE,                -- Alternat.payee [LNRZB]
    HOUSEBANK,                       -- House Bank [HBKID]
    BILLOFEXCHLMTAMTINCOCODECRCY,    -- Bill/Ex. Limit [WEBTR_CS]
    ITEMISTOBEPAIDSEPARATELY,        -- Individual Payt [XPORE]
    PAYMENTISTOBESENTBYEDI,          -- Pmt adv. by EDI [XEDIP]
    WITHHOLDINGTAXCOUNTRY,           -- WTax C/R Key [QLAND]
    INTERESTCALCULATIONCODE,         -- Interest Indic. [VZSKZ]
    INTERESTCALCULATIONDATE,         -- Last Key Date [DZINDT]
    INTRSTCALCFREQUENCYINMONTHS,     -- Int.Calc.Freq. [DZINRT]
    LASTINTERESTCALCRUNDATE,         -- Last Int. Calc. [DATLZ]
    SUPPLIERRELEASEGROUP,            -- Release Group [FRGRP]
    CREDITMEMOPAYMENTTERMS,          -- Cr Memo Terms [GUZTE]
    PAYMENTMETHODSUPPLEMENT,         -- Pmnt Meth. Sup. [UZAWE]
    PAYMENTCLEARINGGROUP,            -- Payment Clrg Grp ID [FAR_PAYMENT_CLEARING_GROUP]
    PREVIOUSACCOUNTNUMBER,           -- Prev.Acct No. [ALTKN]
    PAYMENTREASON,                   -- Payment Reason [FARP_PAYT_RSN]
    DELETIONISBLOCKED,               -- CoCd del.block [NODEL_B]
    EXTENDEDWHLDGTAXISACTIVE,        -- Extended WTax Active [WT_NEWWT]
    PERSONNELNUMBER,                 -- Personnel No. [PERNR_D]
    COUNTRY,                         -- Country/Reg. [LAND1]
    COMPANYCODENAME,                 -- Company Name [BUTXT]
    BPHASACTIVEENTITY,               -- Is active [SDRAFT_IS_ACTIVE]
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [CVP_XBLCK]
    CURRENCY,                        -- Currency [WAERS]
    MINORITYGROUP,                   -- Minority Indic. [MINDK]
    DELETIONINDICATOR,               -- Co.Cde Deletion Flag [LOEVM_B]
    SUPPLIERACCOUNTGROUP,            -- Account group [KTOKK]
    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, BUSINESSPARTNER, COMPANYCODE, SUPPLIER, DRAFTUUID)
);

Learn More