R_SupplierPurgOrgDraft

DDL: R_SUPPLIERPURGORGDRAFT Type: view_entity BASIC Package: VDM_MD_BP_RAP
69 Fields 1 Data Sources

Supplier Purchasing Organization - Draft

R_SupplierPurgOrgDraft is a Basic CDS View that provides data about "Supplier Purchasing Organization - Draft" in SAP S/4HANA. It reads from 1 data source (bupa_purgorg_d) and exposes 69 fields with key fields PurchasingOrganization, BusinessPartner, Supplier, DraftUUID. Part of development package VDM_MD_BP_RAP.

Data Sources (1)

SourceAliasJoin Type
bupa_purgorg_d bupa_purgorg_d from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Supplier Purchasing Organization - 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 (69)

KeyFieldSource TableSource FieldDescription
KEY PurchasingOrganization purchasingorganization Purchasing Organization
KEY BusinessPartner businesspartner Issuing Authority
KEY Supplier supplier Supplier
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
PurchasingOrganizationForEdit purchasingorganizationforedit Purchasing Organization
BusinessPartnerForEdit businesspartnerforedit Busn. Partner
SupplierForEdit supplierforedit Supplier
BusinessPartnerUUID businesspartneruuid UUID
PurchasingGroup purchasinggroup Purchasing Group
PlannedDeliveryDurationInDays planneddeliverydurationindays Plnd dely time
PurchasingIsBlockedForSupplier purchasingisblockedforsupplier Pur. block POrg
SupplierRespSalesPersonName supplierrespsalespersonname Salesperson
ContactPersonPhoneNumber contactpersonphonenumber Telephone No.
PurchaseOrderCurrency purchaseordercurrency Order currency
MinimumOrderAmount minimumorderamount Minimum value
CalculationSchemaGroupCode calculationschemagroupcode Schema Grp Supp
PaymentTerms paymentterms Pyt Terms
PricingDateControl pricingdatecontrol Pr. Date Cat.
SupplierABCClassificationCode supplierabcclassificationcode ABC indicator
ShippingCondition shippingcondition Shipping Conditions
PurOrdAutoGenerationIsAllowed purordautogenerationisallowed Automatic PO
InvoiceIsGoodsReceiptBased invoiceisgoodsreceiptbased GR-Based IV
IncotermsClassification incotermsclassification Incoterms
IncotermsTransferLocation incotermstransferlocation Incoterms 2
IncotermsVersion incotermsversion Inco. Version
IncotermsLocation1 incotermslocation1 Inco. Location1
IncotermsLocation2 incotermslocation2 Inco. Location2
EvaldReceiptSettlementIsActive evaldreceiptsettlementisactive ERS
AutomaticEvaluatedRcptSettlmt automaticevaluatedrcptsettlmt Aut. GRSet Ret
SupplierAccountNumber supplieraccountnumber Acc. w. supplier
SupplierConfirmationControlKey supplierconfirmationcontrolkey Conf. Control
IsOrderAcknRqd isorderacknrqd Acknowl. Reqd.
SuplrIsSubjToSubsqntSettlement suplrissubjtosubsqntsettlement Subseq. Settlmt
SuplrPurgOrgAgrmtOfBusVolIsRqd suplrpurgorgagrmtofbusvolisrqd BVC
SuplrInvcRevalIsAllowed suplrinvcrevalisallowed Revaluation
SuplrPurgOrgIsRlvtForPriceDetn suplrpurgorgisrlvtforpricedetn Price determin.
IntrastatCrsBorderTrMode intrastatcrsbordertrmode Mode of Trans.
ProductUnitGroup productunitgroup UoM Group
RoundingProfile roundingprofile Rnding Profile
PlanningCycle planningcycle Planning Cycle
SuplrDiscountInKindIsGranted suplrdiscountinkindisgranted Checkbox
SuplrIsRlvtForSettlmtMgmt suplrisrlvtforsettlmtmgmt Settlem. Mgmt.
InvoiceIsMMServiceEntryBased invoiceismmserviceentrybased Srv.-Based Inv. Ver.
ProdStockAndSlsDataTransfPrfl prodstockandslsdatatransfprfl PROACT control prof
EvaldRcptSettlementProfile evaldrcptsettlementprofile Settlement profile
AbsoluteHandlingSurchargeAmt absolutehandlingsurchargeamt Absolute surcharge
PercentageHandlingSurchargeAmt percentagehandlingsurchargeamt Percentage HSC
MinimumHandlingSurchargeAmt minimumhandlingsurchargeamt Minimum HSC
MaximumHandlingSurchargeAmt maximumhandlingsurchargeamt Max. HSC
AutomDebitCrtnIsEnbldOnGI automdebitcrtnisenbldongi Auto. debit
IncotermsSupChnLoc2AddlUUID incotermssupchnloc2addluuid Location UUID
IncotermsSupChnLoc1AddlUUID incotermssupchnloc1addluuid Location UUID
IncotermsSupChnDvtgLocAddlUUID incotermssupchndvtglocaddluuid Location UUID
BPHasActiveEntity bphasactiveentity Is active
DeletionIndicator deletionindicator Deletion Ind.
IncotermsLocation1Identifier incotermslocation1identifier Location
IncotermsLocation2Identifier incotermslocation2identifier Location
IncotermsDvtgLocIdentifier incotermsdvtglocidentifier Location
SupplierAccountGroup supplieraccountgroup Account group
SupplierAuthznGrp supplierauthzngrp Authorization
AuthorizationGroup authorizationgroup AuthorizGroup
IsBusinessPurposeCompleted isbusinesspurposecompleted Purpose Completed
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_SupplierPurgOrgDraft.
-- 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_SupplierPurgOrgDraft AS
SELECT
  PurchasingOrganization,
  BusinessPartner,
  Supplier,
  DraftUUID,
  ParentDraftUUID,
  PurchasingOrganizationForEdit,
  BusinessPartnerForEdit,
  SupplierForEdit,
  BusinessPartnerUUID,
  PurchasingGroup,
  PlannedDeliveryDurationInDays,
  PurchasingIsBlockedForSupplier,
  SupplierRespSalesPersonName,
  ContactPersonPhoneNumber,
  PurchaseOrderCurrency,
  MinimumOrderAmount,
  CalculationSchemaGroupCode,
  PaymentTerms,
  PricingDateControl,
  SupplierABCClassificationCode,
  ShippingCondition,
  PurOrdAutoGenerationIsAllowed,
  InvoiceIsGoodsReceiptBased,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  EvaldReceiptSettlementIsActive,
  AutomaticEvaluatedRcptSettlmt,
  SupplierAccountNumber,
  SupplierConfirmationControlKey,
  IsOrderAcknRqd,
  SuplrIsSubjToSubsqntSettlement,
  SuplrPurgOrgAgrmtOfBusVolIsRqd,
  SuplrInvcRevalIsAllowed,
  SuplrPurgOrgIsRlvtForPriceDetn,
  IntrastatCrsBorderTrMode,
  ProductUnitGroup,
  RoundingProfile,
  PlanningCycle,
  SuplrDiscountInKindIsGranted,
  SuplrIsRlvtForSettlmtMgmt,
  InvoiceIsMMServiceEntryBased,
  ProdStockAndSlsDataTransfPrfl,
  EvaldRcptSettlementProfile,
  AbsoluteHandlingSurchargeAmt,
  PercentageHandlingSurchargeAmt,
  MinimumHandlingSurchargeAmt,
  MaximumHandlingSurchargeAmt,
  AutomDebitCrtnIsEnbldOnGI,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsSupChnDvtgLocAddlUUID,
  BPHasActiveEntity,
  DeletionIndicator,
  IncotermsLocation1Identifier,
  IncotermsLocation2Identifier,
  IncotermsDvtgLocIdentifier,
  SupplierAccountGroup,
  SupplierAuthznGrp,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM bupa_purgorg_d
;

Learn More