BUPA_CUST_D

Transparent Table Application Table
73 Fields 1 CDS Views

Draft table for entity I_BUSINESSPARTNERCUSTTP

BUPA_CUST_D is an SAP database table in S/4HANA. Draft table for entity I_BUSINESSPARTNERCUSTTP. It contains 73 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BusinessPartnerCustomerDraft view_entity from BASIC BP Customer Draft

Fields (73)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY customer kunnr Customer
KEY businesspartner bu_partner Busn. Partner
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
customerforedit kunnr Customer
businesspartneruuid bu_partner_guid BP GUID
customeraccountgroup ktokd Account group
alternativepayeraccount knrza Alternat. Payer
datamediumexchangeindicator dtams DME Rec. Code
supplier lifnr Supplier
customerclassification kukla Customer Class.
vatliability stkzu Liable for VAT
postingisblocked sperb_x Posting Block
deliveryisblocked lifsd_x Delivery block
billingisblockedforcustomer faksd_x Billing block
orderisblockedforcustomer aufsd_x Order block
isnaturalperson stkzn Natural person
businesspartnergrouping bu_group Grouping
authorizationgroup brgru Authorization
deliverydatetyperule sd_delivery_date_type_rule Deliv Date Rule
expresstrainstationname bahne Express station
trainstationname bahns Train station
citylocationcoordinatescode locco Location code
plant werks_d Plant
customercorporategroup konzs Group
dataexchangeinstructionkey dtaws Instruction Key
industrycode1 bran1_d Industry code 1
industrycode2 bran2 Industry code 2
industrycode3 bran3 Industry code 3
iscompetitor dear1 Competitors
issalespartner dear2 Sales partner
isdefaultsoldtoparty dear5 Default SP
isconsumer dear6 Consumer
fiscaladdress fiskn_d Fiscal address
freedefinedattribute03 katr3 Attribute 3
customerconditiongroup1 kdkg1 Condition grp 1
customerconditiongroup2 kdkg2 Condition grp 2
customerconditiongroup3 kdkg3 Condition grp 3
customerconditiongroup4 kdkg4 Condition grp 4
customerconditiongroup5 kdkg5 Condition grp 5
addressid adrnr Address
internationallocationnumber1 bbbnr Location no. 1
internationallocationnumber2 bbsnr Location no. 2
internationallocationnumber3 bubkz Check digit
citycode cityc City Code
county counc County Code
customerhasunloadingpoint exabl Unloading pts
customerworkingtimecalendar knazk Working times
isbusinesspurposecompleted cvp_xblck Purpose Completed
bpisequalizationtaxsubject xfeld Checkbox
country land1_gp Country/Region Key
region regio Region
deletionindicator loevm_x Deletion Flag
language spras Language
salesisblockedforcustomer abap.char
paymentreason farp_payt_rsn Payment Reason
customercentraldeletionisblock nodel_x Deletion block
alternativepayerisallowed xregu Al.payer in doc
bpplannedannualsalesyear umjah Sales year
bpplannedannualsalescurrency uwaer Currency
bpplannedannualsalesamount umsat Annual sales
customertradingpartnerid rassc Trading Partner
fiscalyearvariant periv FY Variant
accounttaxtype j_1atoid Tax number type
industrycode4 bran4 Industry code 4
industrycode5 bran5 Industry code 5
taxinvoicerepresentativename repres Rep's Name
businesstype gestyp Type of Business
industrytype indtyp Type of Industry
lastchangedbyuser bu_chusr Changed by
lastchangedate bu_chdat Changed on
lastchangetime bu_chtim Changed at

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_BUSINESSPARTNERCUSTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_CUST_D (
    MANDT,                           -- Client [mandt]
    CUSTOMER,                        -- Customer [kunnr]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    CUSTOMERFOREDIT,                 -- Customer [kunnr]
    BUSINESSPARTNERUUID,             -- BP GUID [bu_partner_guid]
    CUSTOMERACCOUNTGROUP,            -- Account group [ktokd]
    ALTERNATIVEPAYERACCOUNT,         -- Alternat. Payer [knrza]
    DATAMEDIUMEXCHANGEINDICATOR,     -- DME Rec. Code [dtams]
    SUPPLIER,                        -- Supplier [lifnr]
    CUSTOMERCLASSIFICATION,          -- Customer Class. [kukla]
    VATLIABILITY,                    -- Liable for VAT [stkzu]
    POSTINGISBLOCKED,                -- Posting Block [sperb_x]
    DELIVERYISBLOCKED,               -- Delivery block [lifsd_x]
    BILLINGISBLOCKEDFORCUSTOMER,     -- Billing block [faksd_x]
    ORDERISBLOCKEDFORCUSTOMER,       -- Order block [aufsd_x]
    ISNATURALPERSON,                 -- Natural person [stkzn]
    BUSINESSPARTNERGROUPING,         -- Grouping [bu_group]
    AUTHORIZATIONGROUP,              -- Authorization [brgru]
    DELIVERYDATETYPERULE,            -- Deliv Date Rule [sd_delivery_date_type_rule]
    EXPRESSTRAINSTATIONNAME,         -- Express station [bahne]
    TRAINSTATIONNAME,                -- Train station [bahns]
    CITYLOCATIONCOORDINATESCODE,     -- Location code [locco]
    PLANT,                           -- Plant [werks_d]
    CUSTOMERCORPORATEGROUP,          -- Group [konzs]
    DATAEXCHANGEINSTRUCTIONKEY,      -- Instruction Key [dtaws]
    INDUSTRYCODE1,                   -- Industry code 1 [bran1_d]
    INDUSTRYCODE2,                   -- Industry code 2 [bran2]
    INDUSTRYCODE3,                   -- Industry code 3 [bran3]
    ISCOMPETITOR,                    -- Competitors [dear1]
    ISSALESPARTNER,                  -- Sales partner [dear2]
    ISDEFAULTSOLDTOPARTY,            -- Default SP [dear5]
    ISCONSUMER,                      -- Consumer [dear6]
    FISCALADDRESS,                   -- Fiscal address [fiskn_d]
    FREEDEFINEDATTRIBUTE03,          -- Attribute 3 [katr3]
    CUSTOMERCONDITIONGROUP1,         -- Condition grp 1 [kdkg1]
    CUSTOMERCONDITIONGROUP2,         -- Condition grp 2 [kdkg2]
    CUSTOMERCONDITIONGROUP3,         -- Condition grp 3 [kdkg3]
    CUSTOMERCONDITIONGROUP4,         -- Condition grp 4 [kdkg4]
    CUSTOMERCONDITIONGROUP5,         -- Condition grp 5 [kdkg5]
    ADDRESSID,                       -- Address [adrnr]
    INTERNATIONALLOCATIONNUMBER1,    -- Location no. 1 [bbbnr]
    INTERNATIONALLOCATIONNUMBER2,    -- Location no. 2 [bbsnr]
    INTERNATIONALLOCATIONNUMBER3,    -- Check digit [bubkz]
    CITYCODE,                        -- City Code [cityc]
    COUNTY,                          -- County Code [counc]
    CUSTOMERHASUNLOADINGPOINT,       -- Unloading pts [exabl]
    CUSTOMERWORKINGTIMECALENDAR,     -- Working times [knazk]
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [cvp_xblck]
    BPISEQUALIZATIONTAXSUBJECT,      -- Checkbox [xfeld]
    COUNTRY,                         -- Country/Region Key [land1_gp]
    REGION,                          -- Region [regio]
    DELETIONINDICATOR,               -- Deletion Flag [loevm_x]
    LANGUAGE,                        -- Language [spras]
    SALESISBLOCKEDFORCUSTOMER,       -- abap.char
    PAYMENTREASON,                   -- Payment Reason [farp_payt_rsn]
    CUSTOMERCENTRALDELETIONISBLOCK,  -- Deletion block [nodel_x]
    ALTERNATIVEPAYERISALLOWED,       -- Al.payer in doc [xregu]
    BPPLANNEDANNUALSALESYEAR,        -- Sales year [umjah]
    BPPLANNEDANNUALSALESCURRENCY,    -- Currency [uwaer]
    BPPLANNEDANNUALSALESAMOUNT,      -- Annual sales [umsat]
    CUSTOMERTRADINGPARTNERID,        -- Trading Partner [rassc]
    FISCALYEARVARIANT,               -- FY Variant [periv]
    ACCOUNTTAXTYPE,                  -- Tax number type [j_1atoid]
    INDUSTRYCODE4,                   -- Industry code 4 [bran4]
    INDUSTRYCODE5,                   -- Industry code 5 [bran5]
    TAXINVOICEREPRESENTATIVENAME,    -- Rep's Name [repres]
    BUSINESSTYPE,                    -- Type of Business [gestyp]
    INDUSTRYTYPE,                    -- Type of Industry [indtyp]
    LASTCHANGEDBYUSER,               -- Changed by [bu_chusr]
    LASTCHANGEDATE,                  -- Changed on [bu_chdat]
    LASTCHANGETIME,                  -- Changed at [bu_chtim]
    PRIMARY KEY (MANDT, CUSTOMER, BUSINESSPARTNER, DRAFTUUID)
);

Learn More