R_CntrlPurContrDistribution

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_CntrlPurContrDistribution.
-- 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.
-- SQL view name: RCNTRLPCONDSTR

CREATE VIEW R_CntrlPurContrDistribution AS
SELECT
  purchasingdocument AS CentralPurchaseContract,
  purchasingdocumentitem AS CentralPurchaseContractItem,
  ekpo_distr.distributionnumber AS DistributionKey,
  ekpo_distr.purchasingdocumentcategory AS PurchasingDocumentCategory,
  ekpo_distr.purchasingdocumenttype AS PurchasingDocumentType,
  ekpo_distr.purchasingorganization AS PurchasingOrganization,
  ekpo_distr.companycode AS CompanyCode,
  ekpo_distr.plant AS Plant,
  ekpo_distr.logicalsystem AS LogicalSystem,
  ekpo_distr.documentcurrency AS DocumentCurrency,
  ekpo_distr.documentcurrency AS Currency,
  ekpo_distr.purchasinggroup AS PurchasingGroup,
  ekpo_distr.storagelocation AS StorageLocation,
  ekpo_distr.paymentterms AS PaymentTerms,
  ekpo_distr.cashdiscount1days AS CashDiscount1Days,
  ekpo_distr.cashdiscount2days AS CashDiscount2Days,
  ekpo_distr.netpaymentdays AS NetPaymentDays,
  ekpo_distr.cashdiscount1percent AS CashDiscount1Percent,
  ekpo_distr.cashdiscount2percent AS CashDiscount2Percent,
  ekpo_distr.material AS Material,
  ekpo_distr.materialgroup AS MaterialGroup,
  ekpo_distr.purchasingdocumentdistrpct AS CntrlPurContrDistributionPct,
  ekpo_distr.targetquantity AS TargetQuantity,
  ekpo_distr.targetvalue AS TargetAmount,
  ekpo_distr.extcontractforpurg AS ExtContractForPurg,
  ekpo_distr.extcontractitemforpurg AS ExtContractItemForPurg,
  ekpo_distr.extcontractitemdistrforpurg AS ExtContractItemDistrForPurg,
  ekpo_distr.extcontractitemdistrstatus AS PurgDocItemDistributionStatus,
  cast( ekpo_distr.isdeleted as xfeld ) AS IsDeleted,
  ekpo_distr.orderquantityunit AS OrderQuantityUnit,
  ekpo_distr.distributiontype AS DistributionType,
  ekpo_distr.responsemessageguid AS DistrResponseMessageUUID,
  cast( ekpo_distr.itemdistributionisrelevant as xfeld ) AS ItemDistributionIsRelevant,
  ekpo_distr.referencedhdrdistrnumber AS ReferenceHeaderDistributionKey,
  cast( ekpo_distr.isitemdistributionblocked as xfeld ) AS CntrlPurContrItmDistrIsBlocked,
  ekpo_distr.distributionlevel AS CntrlPurContrDistributionLevel,
  ekpo_distr.manualdeliveryaddressid AS ManualDeliveryAddressID,
  ekpo_distr.deliveryaddresstype AS ProcmtHubDelivAddressTypeCode,
  ekpo_distr.externalreferencedocument AS ExternalReferenceDocument,
  ekpo_distr.externalreferencedocumentitem AS ExternalReferenceDocumentItem,
  ekpo_distr.externalrefdoccategory AS ExternalRefDocCategory,
  ekpo_distr.purchasinginforecordupdatecode AS PurchasingInfoRecordUpdateCode,
  ekpo_distr.procmthubpredecessordocument AS ProcmtHubPredecessorDocument,
  ekpo_distr.procmthubpredecessordocitem AS ProcmtHubPredecessorDocItem,
  ekpo_distr.procmthubpredecessordoccat AS ProcmtHubPredecessorDocCat,
  ekpo_distr.procmthubpurchaserequisition AS ProcmtHubPurchaseRequisition,
  ekpo_distr.procmthubpurrequisitionitem AS ProcmtHubPurRequisitionItem,
  ekpo_distr.sourcelistisupdated AS SourceListIsUpdated,
  ekpo_distr.sourcelistrestriction AS SourceListRestriction,
  ekpo_distr.srcelistresponsemsguuid AS SrceListResponseMsgUUID,
  ekpo_distr.sourcelistchangeconfstatus AS SourceListChangeConfStatus,
  ekpo_distr.procmthubcompanycodegroupingid AS ProcmtHubCompanyCodeGroupingID,
  ekpo_distr.outlineagrmtitmisblocked AS OutlineAgrmtItmIsBlocked,
  ekpo_distr.purgdocitmblkrsncode AS PurgDocItmBlkRsnCode,
  ekpo_distr.incotermsclassification AS IncotermsClassification,
  ekpo_distr.incotermslocation1 AS IncotermsLocation1,
  ekpo_distr.shippinginstruction AS ShippingInstruction,
  ekpo_distr.cntrlpurcontrdistrtrggrdtetime AS CntrlPurContrDistrTrggrDteTime,
  ekpo_distr.procmthubsubcontractor AS ProcmtHubSubcontractor,
  ekpo_distr.procmthubsuplrissubcontractor AS ProcmtHubSuplrIsSubcontractor,
  ekpo_distr.referencedeliveryaddressid AS ReferenceDeliveryAddressID,
  ekpo_distr.formofaddress AS FormOfAddress,
  ekpo_distr.procmthubbusinesspartnername1 AS ProcmtHubBusinessPartnerName1,
  ekpo_distr.procmthubbusinesspartnername2 AS ProcmtHubBusinessPartnerName2,
  ekpo_distr.procmthubbusinesspartnername3 AS ProcmtHubBusinessPartnerName3,
  ekpo_distr.procmthubbusinesspartnername4 AS ProcmtHubBusinessPartnerName4,
  ekpo_distr.procmthubstreetname AS ProcmtHubStreetName,
  ekpo_distr.procmthubhousenumber AS ProcmtHubHouseNumber,
  ekpo_distr.procmthubpostalcode AS ProcmtHubPostalCode,
  ekpo_distr.procmthubcityname AS ProcmtHubCityName,
  ekpo_distr.procmthubcountry AS ProcmtHubCountry,
  ekpo_distr.procmthubregion AS ProcmtHubRegion,
  ekpo_distr.procmthubprdcssrdocuuid AS ProcmtHubPrdcssrDocUUID,
  ekpo_distr.procmthubprdcssrdocitemuuid AS ProcmtHubPrdcssrDocItemUUID,
  ekpo_distr.procmthubprdcssrdocobjtype AS ProcmtHubPrdcssrDocObjType,
  ekpo_distr.procmthubprdcssrdocobjnodetype AS ProcmtHubPrdcssrDocObjNodeType
FROM ekpo_distr
LEFT OUTER JOIN R_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN R_CntrlPurchaseContractItem AS _CntrlPurchaseContractItem ON CentralPurchaseContract = _CntrlPurchaseContractItem.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurchaseContractItem.CentralPurchaseContractItem  -- association [1..1]
;