R_BPCustomerSalesAreaGovDraft

DDL: R_BPCUSTOMERSALESAREAGOVDRAFT Type: view_entity BASIC
74 Fields 1 Data Sources

Draft Access BP Customer Sales Area

R_BPCustomerSalesAreaGovDraft is a Basic CDS View that provides data about "Draft Access BP Customer Sales Area" in SAP S/4HANA. It reads from 1 data source (knvv_dft) and exposes 74 fields with key fields BusinessPartnerUUID, CustomerSalesAreaUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject.

Data Sources (1)

SourceAliasJoin Type
knvv_dft knvv_dft from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Draft Access BP Customer Sales Area 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 (74)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID businesspartneruuid UUID
KEY CustomerSalesAreaUUID customersalesareauuid UUID
KEY MasterDataChangeProcess masterdatachangeprocess Process ID
KEY MDChgProcessSrceSystem mdchgprocesssrcesystem Source System
KEY MDChgProcessSrceObject mdchgprocesssrceobject Source ID
KEY SalesOrganization salesorganization Sales Organization
KEY DistributionChannel distributionchannel RefDistCh-Cust/Mat.
KEY Division division Internal Division ID
MDChgProcessStep mdchgprocessstep Step Number
BPAssignmentID bpassignmentid Assignment ID
Customer customer Sold-to Party
SalesOrganizationForEdit salesorganizationforedit Sales Org.
DistributionChannelForEdit distributionchannelforedit RefDistCh-Cust/Mat.
DivisionForEdit divisionforedit Division
AuthorizationGroup authorizationgroup AuthorizGroup
DeletionIndicator deletionindicator Deletion Ind.
OrderIsBlockedForCustomer orderisblockedforcustomer Order block
BPCustomerPricingProcedure bpcustomerpricingprocedure Cust.Pric.Proc.
CustomerGroup customergroup Customer Group
SalesDistrict salesdistrict Sales District
CustomerPriceGroup customerpricegroup CustPrice Group
PriceListType pricelisttype Price List Tp.
ItemOrderProbabilityInPercent itemorderprobabilityinpercent Order Probab.
IncotermsClassification incotermsclassification Incoterms
IncotermsTransferLocation incotermstransferlocation Incoterms 2
DeliveryIsBlocked deliveryisblocked Delivery block
CompleteDeliveryIsDefined completedeliveryisdefined Complete Dlv.
MaxNmbrOfPartialDelivery maxnmbrofpartialdelivery Max.Part.Deliv.
PartialDeliveryIsAllowed partialdeliveryisallowed Partial Deliv.
OrderCombinationIsAllowed ordercombinationisallowed Order Combinat.
DeliveryPriority deliverypriority Delivery Prior.
AccountByCustomer accountbycustomer Acct at cust.
ShippingCondition shippingcondition Shipping Conditions
BillingIsBlockedForCustomer billingisblockedforcustomer Billing block
ManualInvoiceMaintIsRelevant manualinvoicemaintisrelevant Man.Inv.Maint.
InvcCalendarDateIdentification invccalendardateidentification Invoicing Dates
InvoiceListSchedule invoicelistschedule Inv.List Sched.
Currency currency Valuation Crcy
CustomerABCClassification customerabcclassification ABC class
CustomerAccountAssignmentGroup customeraccountassignmentgroup AccAssmtGrpCust
CustomerPaymentTerms customerpaymentterms Pyt Terms
SupplyingPlant supplyingplant Supplying Plant
SalesGroup salesgroup Sales Group
SalesOffice salesoffice Sales Office
SalesItemProposal salesitemproposal Item proposal
AdditionalCustomerGroup1 additionalcustomergroup1 Customer Grp 1
AdditionalCustomerGroup2 additionalcustomergroup2 Customer Grp 2
AdditionalCustomerGroup3 additionalcustomergroup3 Customer Grp 3
AdditionalCustomerGroup4 additionalcustomergroup4 Customer Grp 4
AdditionalCustomerGroup5 additionalcustomergroup5 Customer Grp 5
CustomerIsRebateRelevant customerisrebaterelevant Rebate
ExchangeRateType exchangeratetype Exch. Rate Type
ProductUnitGroup productunitgroup UoM Group
InspSbstHasNoTimeOrQuantity inspsbsthasnotimeorquantity Price determin.
CustomerPaytGuarProced customerpaytguarproced Paym.guar.proc.
CreditControlArea creditcontrolarea Credit Control Area
CustomerSalesAreaIsBlocked customersalesareaisblocked TRUE
SuplrIsRlvtForSettlmtMgmt suplrisrlvtforsettlmtmgmt Settlem. Mgmt.
OverdelivTolrtdLmtRatioInPct overdelivtolrtdlmtratioinpct Overdeliv. Tol.
UnderdelivTolrtdLmtRatioInPct underdelivtolrtdlmtratioinpct Underdel. Tol.
SlsUnlmtdOvrdelivIsAllwd slsunlmtdovrdelivisallwd Unlimited Tol.
SlsDocIsRlvtForProofOfDeliv slsdocisrlvtforproofofdeliv POD-relevant
ProofOfDeliveryTimeValue proofofdeliverytimevalue POD timeframe
IncotermsVersion incotermsversion Inco. Version
IncotermsLocation1 incotermslocation1 Inco. Location1
IncotermsLocation2 incotermslocation2 Inco. Location2
IsBusinessPurposeCompleted isbusinesspurposecompleted Purpose Completed
MasterDataIsCurrent masterdataiscurrent Truth Value
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_BPCustomerSalesAreaGovDraft.
-- 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_BPCustomerSalesAreaGovDraft AS
SELECT
  BusinessPartnerUUID,
  CustomerSalesAreaUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  SalesOrganization,
  DistributionChannel,
  Division,
  MDChgProcessStep,
  BPAssignmentID,
  Customer,
  SalesOrganizationForEdit,
  DistributionChannelForEdit,
  DivisionForEdit,
  AuthorizationGroup,
  DeletionIndicator,
  OrderIsBlockedForCustomer,
  BPCustomerPricingProcedure,
  CustomerGroup,
  SalesDistrict,
  CustomerPriceGroup,
  PriceListType,
  ItemOrderProbabilityInPercent,
  IncotermsClassification,
  IncotermsTransferLocation,
  DeliveryIsBlocked,
  CompleteDeliveryIsDefined,
  MaxNmbrOfPartialDelivery,
  PartialDeliveryIsAllowed,
  OrderCombinationIsAllowed,
  DeliveryPriority,
  AccountByCustomer,
  ShippingCondition,
  BillingIsBlockedForCustomer,
  ManualInvoiceMaintIsRelevant,
  InvcCalendarDateIdentification,
  InvoiceListSchedule,
  Currency,
  CustomerABCClassification,
  CustomerAccountAssignmentGroup,
  CustomerPaymentTerms,
  SupplyingPlant,
  SalesGroup,
  SalesOffice,
  SalesItemProposal,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CustomerIsRebateRelevant,
  ExchangeRateType,
  ProductUnitGroup,
  InspSbstHasNoTimeOrQuantity,
  CustomerPaytGuarProced,
  CreditControlArea,
  CustomerSalesAreaIsBlocked,
  SuplrIsRlvtForSettlmtMgmt,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  SlsUnlmtdOvrdelivIsAllwd,
  SlsDocIsRlvtForProofOfDeliv,
  ProofOfDeliveryTimeValue,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  IsBusinessPurposeCompleted,
  MasterDataIsCurrent,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM knvv_dft
;

Learn More