R_BPSupplierCompanyGovDraft

DDL: R_BPSUPPLIERCOMPANYGOVDRAFT Type: view_entity BASIC
60 Fields 1 Data Sources 1 Associations

Draft Access BP Supplier Company

R_BPSupplierCompanyGovDraft is a Basic CDS View that provides data about "Draft Access BP Supplier Company" in SAP S/4HANA. It reads from 1 data source (lfb1_dft) and exposes 60 fields with key fields BusinessPartnerUUID, SupplierCompanyUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
lfb1_dft lfb1_dft from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_BPSupplierCompanyGovDraft _ExtSupplierCompanyDraft $projection.BusinessPartnerUUID = _ExtSupplierCompanyDraft.BusinessPartnerUUID and $projection.SupplierCompanyUUID = _ExtSupplierCompanyDraft.SupplierCompanyUUID and $projection.MasterDataChangeProcess = _ExtSupplierCompanyDraft.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _ExtSupplierCompanyDraft.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _ExtSupplierCompanyDraft.MDChgProcessSrceObject and $projection.CompanyCode = _ExtSupplierCompanyDraft.CompanyCode

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Draft Access BP Supplier Company 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 (60)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID businesspartneruuid UUID
KEY SupplierCompanyUUID suppliercompanyuuid UUID
KEY MasterDataChangeProcess masterdatachangeprocess Process ID
KEY MDChgProcessSrceSystem mdchgprocesssrcesystem Source System
KEY MDChgProcessSrceObject mdchgprocesssrceobject Source ID
KEY CompanyCode companycode Receiver Company Code
MDChgProcessStep mdchgprocessstep Step Number
CompanyCodeForEdit companycodeforedit Company Code
BPAssignmentID bpassignmentid Assignment ID
Supplier supplier Supplier
PersonnelNumber personnelnumber Personnel No.
SupplierIsBlockedForPosting supplierisblockedforposting Co.code post.block
DeletionIndicator deletionindicator Deletion Ind.
LayoutSortingRule layoutsortingrule Sort key
ReconciliationAccount reconciliationaccount Recon. account
AuthorizationGroup authorizationgroup AuthorizGroup
InterestCalculationCode interestcalculationcode Interest Indic.
PaymentMethodsList paymentmethodslist Payment Methods
ClearCustomerSupplier clearcustomersupplier Clrg with Cust.
PaymentBlockingReason paymentblockingreason Pmnt block
PaymentTerms paymentterms Pyt Terms
SupplierClerkIDBySupplier supplierclerkidbysupplier Acct w/ vendor
SupplierClerk supplierclerk Clerk at vendor
SupplierAccountNote supplieraccountnote Account Memo
CashPlanningGroup cashplanninggroup Planning Group
AccountingClerk accountingclerk Clerk Abbrev.
SupplierHeadOffice supplierheadoffice Head Office
AlternativePayee alternativepayee Alternat.payee
InterestCalculationDate interestcalculationdate Last Key Date
IntrstCalcFrequencyInMonths intrstcalcfrequencyinmonths Int.Calc.Freq.
LastInterestCalcRunDate lastinterestcalcrundate Last Int. Calc.
IsToBeLocallyProcessed istobelocallyprocessed Local Process.
Currency currency Valuation Crcy
BillOfExchLmtAmtInCoCodeCrcy billofexchlmtamtincocodecrcy Bill/Ex. Limit
CheckPaidDurationInDays checkpaiddurationindays Chk cashng time
IsDoubleInvoice isdoubleinvoice Chk Double Inv.
APARToleranceGroup apartolerancegroup Tolerance Group
HouseBank housebank House Bank
ItemIsToBePaidSeparately itemistobepaidseparately Individual Payt
MinorityGroup minoritygroup Minority Indic.
PreviousAccountNumber previousaccountnumber Prev.Acct No.
PaymentMethodSupplement paymentmethodsupplement Pmnt Meth. Sup.
WithholdingTaxCountry withholdingtaxcountry WTax C/R Key
PaymentIsToBeSentByEDI paymentistobesentbyedi Pmt adv. by EDI
SupplierReleaseGroup supplierreleasegroup Release Group
SuplrInvcVerificatTolGroup suplrinvcverificattolgroup Tolerance Grp
AccountingClerkFaxNumber accountingclerkfaxnumber Clerk's fax
AccountingClerkInternetAddress accountingclerkinternetaddress Clrk's internet
CreditMemoPaymentTerms creditmemopaymentterms Cr Memo Terms
SupplierCertificationDate suppliercertificationdate Certifictn Date
DeletionIsBlocked deletionisblocked CoCd del.block
AccountingClerkPhoneNumber accountingclerkphonenumber Act.clk tel.no.
MasterDataIsCurrent masterdataiscurrent Truth Value
Origin origin Task Origin
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_BPSupplierCompanyGovDraft.
-- 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_BPSupplierCompanyGovDraft AS
SELECT
  BusinessPartnerUUID,
  SupplierCompanyUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  CompanyCode,
  MDChgProcessStep,
  CompanyCodeForEdit,
  BPAssignmentID,
  Supplier,
  PersonnelNumber,
  SupplierIsBlockedForPosting,
  DeletionIndicator,
  LayoutSortingRule,
  ReconciliationAccount,
  AuthorizationGroup,
  InterestCalculationCode,
  PaymentMethodsList,
  ClearCustomerSupplier,
  PaymentBlockingReason,
  PaymentTerms,
  SupplierClerkIDBySupplier,
  SupplierClerk,
  SupplierAccountNote,
  CashPlanningGroup,
  AccountingClerk,
  SupplierHeadOffice,
  AlternativePayee,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  LastInterestCalcRunDate,
  IsToBeLocallyProcessed,
  Currency,
  BillOfExchLmtAmtInCoCodeCrcy,
  CheckPaidDurationInDays,
  IsDoubleInvoice,
  APARToleranceGroup,
  HouseBank,
  ItemIsToBePaidSeparately,
  MinorityGroup,
  PreviousAccountNumber,
  PaymentMethodSupplement,
  WithholdingTaxCountry,
  PaymentIsToBeSentByEDI,
  SupplierReleaseGroup,
  SuplrInvcVerificatTolGroup,
  AccountingClerkFaxNumber,
  AccountingClerkInternetAddress,
  CreditMemoPaymentTerms,
  SupplierCertificationDate,
  DeletionIsBlocked,
  AccountingClerkPhoneNumber,
  MasterDataIsCurrent,
  Origin,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM lfb1_dft
LEFT OUTER JOIN E_BPSupplierCompanyGovDraft AS _ExtSupplierCompanyDraft ON BusinessPartnerUUID = _ExtSupplierCompanyDraft.BusinessPartnerUUID AND SupplierCompanyUUID = _ExtSupplierCompanyDraft.SupplierCompanyUUID AND MasterDataChangeProcess = _ExtSupplierCompanyDraft.MasterDataChangeProcess AND MDChgProcessSrceSystem = _ExtSupplierCompanyDraft.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtSupplierCompanyDraft.MDChgProcessSrceObject AND CompanyCode = _ExtSupplierCompanyDraft.CompanyCode  -- association [0..1]
;

Learn More