C_BPCustomerCompanyGovTP

DDL: C_BPCUSTOMERCOMPANYGOVTP Type: view_entity CONSUMPTION

BP Customer Company Governance

C_BPCustomerCompanyGovTP is a Consumption CDS View that provides data about "BP Customer Company Governance" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerCompanyGovTP) and exposes 61 fields with key fields BusinessPartnerUUID, CustomerCompanyUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject.

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerCompanyGovTP I_BPCustomerCompanyGovTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Company Governance view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (61)

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
MDChgProcessStep MDChgProcessStep Step Number
BPAssignmentID BPAssignmentID Assignment ID
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
char1024
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
CompanyCodeName _CompanyCode CompanyCodeName Company Name
char81
Country _CompanyCode Country Venue: Ctry/Reg

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 C_BPCustomerCompanyGovTP.
-- 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 C_BPCustomerCompanyGovTP AS
SELECT
  BusinessPartnerUUID,
  CustomerCompanyUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  CompanyCode,
  CompanyCodeForEdit,
  MDChgProcessStep,
  BPAssignmentID,
  Customer,
  PersonnelNumber,
  PhysicalInventoryBlockInd,
  DeletionIndicator,
  LayoutSortingRule,
  AccountingClerk,
  ReconciliationAccount,
  AuthorizationGroup,
  CustomerHeadOffice,
  AlternativePayerAccount,
  PaymentMethodsList,
  CustomerSupplierClearingIsUsed,
  PaymentBlockingReason,
  virtual PaymentTermsName : abap.char(1024) AS char1024,
  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,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  virtual CompanyCodeDescription : abap.char(81) AS char81,
  _CompanyCode.Country AS Country
FROM I_BPCustomerCompanyGovTP
;