R_BPCustomerCompanyGovDraft

DDL: R_BPCUSTOMERCOMPANYGOVDRAFT Type: view_entity BASIC
63 Fields 1 Data Sources

Draft BP Customer Company

R_BPCustomerCompanyGovDraft is a Basic CDS View that provides data about "Draft BP Customer Company" in SAP S/4HANA. It reads from 1 data source (knb1_dft) and exposes 63 fields with key fields BusinessPartnerUUID, CustomerCompanyUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject.

Data Sources (1)

SourceAliasJoin Type
knb1_dft knb1_dft from

Annotations (8)

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

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID businesspartneruuid UUID
KEY CustomerCompanyUUID customercompanyuuid UUID
KEY MasterDataChangeProcess masterdatachangeprocess Process ID
KEY MDChgProcessSrceSystem mdchgprocesssrcesystem Source System
KEY MDChgProcessSrceObject mdchgprocesssrceobject Source ID
KEY CompanyCode companycode Receiver Company Code
CompanyCodeForEdit companycodeforedit Company Code
BPAssignmentID bpassignmentid Assignment ID
MDChgProcessStep mdchgprocessstep Step Number
Customer customer Sold-to Party
PersonnelNumber personnelnumber Personnel No.
PhysicalInventoryBlockInd physicalinventoryblockind Phys. Inv. Blk
DeletionIndicator deletionindicator Deletion Ind.
LayoutSortingRule layoutsortingrule Sort key
AccountingClerk accountingclerk Clerk Abbrev.
ReconciliationAccount reconciliationaccount Recon. account
AuthorizationGroup authorizationgroup AuthorizGroup
CustomerHeadOffice customerheadoffice Head Office
AlternativePayerAccount alternativepayeraccount Alternat.payer
PaymentMethodsList paymentmethodslist Payment Methods
CustomerSupplierClearingIsUsed customersupplierclearingisused Clrg with vend.
PaymentBlockingReason paymentblockingreason Pmnt block
PaymentTerms paymentterms Pyt Terms
BillExchChargePaymentTerms billexchchargepaymentterms BoE Chrges Trms
InterestCalculationCode interestcalculationcode Interest Indic.
InterestCalculationDate interestcalculationdate Last Key Date
IntrstCalcFrequencyInMonths intrstcalcfrequencyinmonths Int.Calc.Freq.
AccountByCustomer accountbycustomer Acct at cust.
UserAtCustomer useratcustomer Customer user
CustomerAccountNote customeraccountnote Account Memo
CashPlanningGroup cashplanninggroup Planning Group
CollectiveInvoiceVariant collectiveinvoicevariant Coll.Invce.Var.
IsToBeLocallyProcessed istobelocallyprocessed Local Process.
BPPeriodicAccountStatement bpperiodicaccountstatement Acct Statement
LastInterestCalcRunDate lastinterestcalcrundate Last Int. Calc.
RecordPaymentHistoryIndicator recordpaymenthistoryindicator Rec.Payt Hist.
APARToleranceGroup apartolerancegroup Tolerance Group
CheckPaidDurationInDays checkpaiddurationindays Chk cashng time
HouseBank housebank House Bank
ItemIsToBePaidSeparately itemistobepaidseparately Individual Payt
CustPreviousMasterRecordNumber custpreviousmasterrecordnumber Prev.Acct No.
KnownOrNegotiatedLeave knownornegotiatedleave Known/Neg.Leave
DunningNoticeGroup dunningnoticegroup Grouping Key
LockboxInternalID lockboxinternalid Lockbox
PaymentMethodSupplement paymentmethodsupplement Pmnt Meth. Sup.
BuyingGroupAccountNumber buyinggroupaccountnumber Buying Group
PaytAdviceIsSentbyEDI paytadviceissentbyedi Pmt adv. by EDI
SupplierReleaseGroup supplierreleasegroup Release Group
AccountingClerkFaxNumber accountingclerkfaxnumber Clerk's fax
AccountingClerkInternetAddress accountingclerkinternetaddress Clrk's internet
CreditMemoPaymentTerms creditmemopaymentterms Cr Memo Terms
ValueAdjustmentKey valueadjustmentkey Value Adj. Key
DeletionIsBlocked deletionisblocked CoCd del.block
AccountingClerkPhoneNumber accountingclerkphonenumber Act.clk tel.no.
AcctsReceivablePledgingCode acctsreceivablepledgingcode AR Pledging Ind
PaymentReason paymentreason Payment Reason
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_BPCustomerCompanyGovDraft.
-- 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_BPCustomerCompanyGovDraft AS
SELECT
  BusinessPartnerUUID,
  CustomerCompanyUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  CompanyCode,
  CompanyCodeForEdit,
  BPAssignmentID,
  MDChgProcessStep,
  Customer,
  PersonnelNumber,
  PhysicalInventoryBlockInd,
  DeletionIndicator,
  LayoutSortingRule,
  AccountingClerk,
  ReconciliationAccount,
  AuthorizationGroup,
  CustomerHeadOffice,
  AlternativePayerAccount,
  PaymentMethodsList,
  CustomerSupplierClearingIsUsed,
  PaymentBlockingReason,
  PaymentTerms,
  BillExchChargePaymentTerms,
  InterestCalculationCode,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  AccountByCustomer,
  UserAtCustomer,
  CustomerAccountNote,
  CashPlanningGroup,
  CollectiveInvoiceVariant,
  IsToBeLocallyProcessed,
  BPPeriodicAccountStatement,
  LastInterestCalcRunDate,
  RecordPaymentHistoryIndicator,
  APARToleranceGroup,
  CheckPaidDurationInDays,
  HouseBank,
  ItemIsToBePaidSeparately,
  CustPreviousMasterRecordNumber,
  KnownOrNegotiatedLeave,
  DunningNoticeGroup,
  LockboxInternalID,
  PaymentMethodSupplement,
  BuyingGroupAccountNumber,
  PaytAdviceIsSentbyEDI,
  SupplierReleaseGroup,
  AccountingClerkFaxNumber,
  AccountingClerkInternetAddress,
  CreditMemoPaymentTerms,
  ValueAdjustmentKey,
  DeletionIsBlocked,
  AccountingClerkPhoneNumber,
  AcctsReceivablePledgingCode,
  PaymentReason,
  MasterDataIsCurrent,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM knb1_dft
;

Learn More