BUPA_CUST_D
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 79 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_BusinessPartnerCustomerDraft | view_entity | from | BASIC | BP Customer Draft |
Fields (79)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| 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_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]
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, CUSTOMER, BUSINESSPARTNER, DRAFTUUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA