R_BusinessPartnerCustomerDraft

DDL: R_BUSINESSPARTNERCUSTOMERDRAFT Type: view_entity BASIC Package: VDM_MD_BP_RAP
79 Fields 1 Data Sources

BP Customer Draft

R_BusinessPartnerCustomerDraft is a Basic CDS View that provides data about "BP Customer Draft" in SAP S/4HANA. It reads from 1 data source (bupa_cust_d) and exposes 79 fields with key fields Customer, BusinessPartner, DraftUUID. Part of development package VDM_MD_BP_RAP.

Data Sources (1)

SourceAliasJoin Type
bupa_cust_d bupa_cust_d from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY Customer customer Sold-to Party
KEY BusinessPartner businesspartner Issuing Authority
KEY DraftUUID draftuuid UUID
CustomerForEdit customerforedit Customer
BusinessPartnerDraftUUID businesspartnerdraftuuid Draft Document ID
BusinessPartnerForEdit businesspartnerforedit Busn. Partner
BusinessPartnerUUID businesspartneruuid UUID
CustomerAccountGroup customeraccountgroup Account group
AlternativePayerAccount alternativepayeraccount Alternat.payer
DataMediumExchangeIndicator datamediumexchangeindicator DME Rec. Code
Supplier supplier Supplier
CustomerClassification customerclassification Customer Class.
VATLiability vatliability Liable for VAT
PostingIsBlocked postingisblocked Posting Block
DeliveryIsBlocked deliveryisblocked Delivery block
BillingIsBlockedForCustomer billingisblockedforcustomer Billing block
OrderIsBlockedForCustomer orderisblockedforcustomer Order block
IsNaturalPerson isnaturalperson Natural person
BusinessPartnerGrouping businesspartnergrouping Grouping
AuthorizationGroup authorizationgroup AuthorizGroup
DeliveryDateTypeRule deliverydatetyperule Deliv Date Rule
ExpressTrainStationName expresstrainstationname Express station
TrainStationName trainstationname Train station
CityLocationCoordinatesCode citylocationcoordinatescode Location code
Plant plant Valuation Area
CustomerCorporateGroup customercorporategroup Group
DataExchangeInstructionKey dataexchangeinstructionkey Instruction Key
IndustryCode1 industrycode1 Industry code 1
IndustryCode2 industrycode2 Industry code 2
IndustryCode3 industrycode3 Industry code 3
IndustryCode4 industrycode4 Industry code 4
IndustryCode5 industrycode5 Industry code 5
IsCompetitor iscompetitor Competitors
IsSalesPartner issalespartner Sales partner
IsDefaultSoldToParty isdefaultsoldtoparty Default SP
IsConsumer isconsumer Consumer
FiscalAddress fiscaladdress Fiscal address
FreeDefinedAttribute03 freedefinedattribute03 Attribute 3
CustomerConditionGroup1 customerconditiongroup1 Condition grp 1
CustomerConditionGroup2 customerconditiongroup2 Condition grp 2
CustomerConditionGroup3 customerconditiongroup3 Condition grp 3
CustomerConditionGroup4 customerconditiongroup4 Condition grp 4
CustomerConditionGroup5 customerconditiongroup5 Condition grp 5
AddressID addressid Ship-to address
InternationalLocationNumber1 internationallocationnumber1 Location no. 1
InternationalLocationNumber2 internationallocationnumber2 Location no. 2
InternationalLocationNumber3 internationallocationnumber3 Check digit
CityCode citycode IATA: City
County county Wyoming County
CustomerHasUnloadingPoint customerhasunloadingpoint Unloading pts
CustomerWorkingTimeCalendar customerworkingtimecalendar Working times
IsBusinessPurposeCompleted isbusinesspurposecompleted Purpose Completed
BPIsEqualizationTaxSubject bpisequalizationtaxsubject Equalizatn tax
Country country Venue: Ctry/Reg
Region region Venue Region
DeletionIndicator deletionindicator Deletion Ind.
Language language Report Text Language
SalesIsBlockedForCustomer salesisblockedforcustomer
PaymentReason paymentreason Payment Reason
CustomerCentralDeletionIsBlock customercentraldeletionisblock Deletion block
AlternativePayerIsAllowed alternativepayerisallowed Al.payer in doc
BPPlannedAnnualSalesYear bpplannedannualsalesyear Sales year
BPPlannedAnnualSalesCurrency bpplannedannualsalescurrency Currency
BPPlannedAnnualSalesAmount bpplannedannualsalesamount Annual sales
CustomerTradingPartnerID customertradingpartnerid Trading Partner
FiscalYearVariant fiscalyearvariant FY Variant
AccountTaxType accounttaxtype Tax Type
TaxInvoiceRepresentativeName taxinvoicerepresentativename Rep's Name
BusinessType businesstype Type of Business
IndustryType industrytype Type of Industry
LastChangedByUser lastchangedbyuser User Name
LastChangeDate lastchangedate Time Stamp
LastChangeTime lastchangetime Time changed
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_BusinessPartnerCustomerDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_BusinessPartnerCustomerDraft AS
SELECT
  Customer,
  BusinessPartner,
  DraftUUID,
  CustomerForEdit,
  BusinessPartnerDraftUUID,
  BusinessPartnerForEdit,
  BusinessPartnerUUID,
  CustomerAccountGroup,
  AlternativePayerAccount,
  DataMediumExchangeIndicator,
  Supplier,
  CustomerClassification,
  VATLiability,
  PostingIsBlocked,
  DeliveryIsBlocked,
  BillingIsBlockedForCustomer,
  OrderIsBlockedForCustomer,
  IsNaturalPerson,
  BusinessPartnerGrouping,
  AuthorizationGroup,
  DeliveryDateTypeRule,
  ExpressTrainStationName,
  TrainStationName,
  CityLocationCoordinatesCode,
  Plant,
  CustomerCorporateGroup,
  DataExchangeInstructionKey,
  IndustryCode1,
  IndustryCode2,
  IndustryCode3,
  IndustryCode4,
  IndustryCode5,
  IsCompetitor,
  IsSalesPartner,
  IsDefaultSoldToParty,
  IsConsumer,
  FiscalAddress,
  FreeDefinedAttribute03,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  AddressID,
  InternationalLocationNumber1,
  InternationalLocationNumber2,
  InternationalLocationNumber3,
  CityCode,
  County,
  CustomerHasUnloadingPoint,
  CustomerWorkingTimeCalendar,
  IsBusinessPurposeCompleted,
  BPIsEqualizationTaxSubject,
  Country,
  Region,
  DeletionIndicator,
  Language,
  SalesIsBlockedForCustomer,
  PaymentReason,
  CustomerCentralDeletionIsBlock,
  AlternativePayerIsAllowed,
  BPPlannedAnnualSalesYear,
  BPPlannedAnnualSalesCurrency,
  BPPlannedAnnualSalesAmount,
  CustomerTradingPartnerID,
  FiscalYearVariant,
  AccountTaxType,
  TaxInvoiceRepresentativeName,
  BusinessType,
  IndustryType,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM bupa_cust_d
;

Learn More