R_SupplierCompanyCodeDraft

DDL: R_SUPPLIERCOMPANYCODEDRAFT Type: view_entity BASIC
65 Fields 1 Data Sources

Supplier Company Code - Draft

R_SupplierCompanyCodeDraft is a Basic CDS View that provides data about "Supplier Company Code - Draft" in SAP S/4HANA. It reads from 1 data source (bupa_suppco_d) and exposes 65 fields with key fields BusinessPartner, CompanyCode, Supplier, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
bupa_suppco_d bupa_suppco_d from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Supplier Company Code - 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 (65)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner businesspartner Issuing Authority
KEY CompanyCode companycode Receiver Company Code
KEY Supplier supplier Supplier
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
BusinessPartnerUUID businesspartneruuid UUID
CompanyCodeForEdit companycodeforedit Company Code
BusinessPartnerForEdit businesspartnerforedit Busn. Partner
SupplierIsBlockedForPosting supplierisblockedforposting Co.code post.block
AuthorizationGroup authorizationgroup AuthorizGroup
AccountingClerk accountingclerk Clerk Abbrev.
SupplierClerk supplierclerk Clerk at vendor
AccountingClerkPhoneNumber accountingclerkphonenumber Act.clk tel.no.
AccountingClerkFaxNumber accountingclerkfaxnumber Clerk's fax
AccountingClerkInternetAddress accountingclerkinternetaddress Clrk's internet
SupplierClerkIDBySupplier supplierclerkidbysupplier Acct w/ vendor
IsToBeLocallyProcessed istobelocallyprocessed Local Process.
SupplierAccountNote supplieraccountnote Account Memo
PaymentTerms paymentterms Pyt Terms
APARToleranceGroup apartolerancegroup Tolerance Group
SuplrInvcVerificatTolGroup suplrinvcverificattolgroup Tolerance Grp
CheckPaidDurationInDays checkpaiddurationindays Chk cashng time
IsDoubleInvoice isdoubleinvoice Chk Double Inv.
CustomerSupplierClearingIsUsed customersupplierclearingisused Clrg with vend.
ReconciliationAccount reconciliationaccount Recon. account
SupplierHeadOffice supplierheadoffice Head Office
LayoutSortingRule layoutsortingrule Sort key
SupplierCertificationDate suppliercertificationdate Certifictn Date
PaymentMethodsList paymentmethodslist Payment Methods
CashPlanningGroup cashplanninggroup Planning Group
PaymentBlockingReason paymentblockingreason Pmnt block
AlternativePayee alternativepayee Alternat.payee
HouseBank housebank House Bank
BillOfExchLmtAmtInCoCodeCrcy billofexchlmtamtincocodecrcy Bill/Ex. Limit
ItemIsToBePaidSeparately itemistobepaidseparately Individual Payt
PaymentIsToBeSentByEDI paymentistobesentbyedi Pmt adv. by EDI
WithholdingTaxCountry withholdingtaxcountry WTax C/R Key
InterestCalculationCode interestcalculationcode Interest Indic.
InterestCalculationDate interestcalculationdate Last Key Date
IntrstCalcFrequencyInMonths intrstcalcfrequencyinmonths Int.Calc.Freq.
LastInterestCalcRunDate lastinterestcalcrundate Last Int. Calc.
SupplierReleaseGroup supplierreleasegroup Release Group
CreditMemoPaymentTerms creditmemopaymentterms Cr Memo Terms
PaymentMethodSupplement paymentmethodsupplement Pmnt Meth. Sup.
PaymentClearingGroup paymentclearinggroup Payment Clrg Grp ID
PreviousAccountNumber previousaccountnumber Prev.Acct No.
PaymentReason paymentreason Payment Reason
DeletionIsBlocked deletionisblocked CoCd del.block
ExtendedWhldgTaxIsActive extendedwhldgtaxisactive Extended WTax Active
PersonnelNumber personnelnumber Personnel No.
Country country Venue: Ctry/Reg
CompanyCodeName companycodename Company Name
BPHasActiveEntity bphasactiveentity Is active
IsBusinessPurposeCompleted isbusinesspurposecompleted Purpose Completed
Currency currency Valuation Crcy
MinorityGroup minoritygroup Minority Indic.
DeletionIndicator deletionindicator Deletion Ind.
SupplierAccountGroup supplieraccountgroup Account group
BusinessPartnerDraftUUID businesspartnerdraftuuid Draft Document ID
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_SupplierCompanyCodeDraft.
-- 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_SupplierCompanyCodeDraft AS
SELECT
  BusinessPartner,
  CompanyCode,
  Supplier,
  DraftUUID,
  ParentDraftUUID,
  BusinessPartnerUUID,
  CompanyCodeForEdit,
  BusinessPartnerForEdit,
  SupplierIsBlockedForPosting,
  AuthorizationGroup,
  AccountingClerk,
  SupplierClerk,
  AccountingClerkPhoneNumber,
  AccountingClerkFaxNumber,
  AccountingClerkInternetAddress,
  SupplierClerkIDBySupplier,
  IsToBeLocallyProcessed,
  SupplierAccountNote,
  PaymentTerms,
  APARToleranceGroup,
  SuplrInvcVerificatTolGroup,
  CheckPaidDurationInDays,
  IsDoubleInvoice,
  CustomerSupplierClearingIsUsed,
  ReconciliationAccount,
  SupplierHeadOffice,
  LayoutSortingRule,
  SupplierCertificationDate,
  PaymentMethodsList,
  CashPlanningGroup,
  PaymentBlockingReason,
  AlternativePayee,
  HouseBank,
  BillOfExchLmtAmtInCoCodeCrcy,
  ItemIsToBePaidSeparately,
  PaymentIsToBeSentByEDI,
  WithholdingTaxCountry,
  InterestCalculationCode,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  LastInterestCalcRunDate,
  SupplierReleaseGroup,
  CreditMemoPaymentTerms,
  PaymentMethodSupplement,
  PaymentClearingGroup,
  PreviousAccountNumber,
  PaymentReason,
  DeletionIsBlocked,
  ExtendedWhldgTaxIsActive,
  PersonnelNumber,
  Country,
  CompanyCodeName,
  BPHasActiveEntity,
  IsBusinessPurposeCompleted,
  Currency,
  MinorityGroup,
  DeletionIndicator,
  SupplierAccountGroup,
  BusinessPartnerDraftUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM bupa_suppco_d
;

Learn More