I_SalesOrderRequest

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 I_SalesOrderRequest.
-- 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: ISOR

CREATE VIEW I_SalesOrderRequest AS
SELECT
  SalesOrderRequest.salesorderrequest AS SalesOrderRequest,
  SalesOrderRequest.salesorderrequestcategory AS SalesOrderRequestCategory,
  SalesOrderRequest.companycode AS CompanyCode,
  SalesOrderRequest.uploadfilecontentbinary AS UploadFileContentBinary,
  SalesOrderRequest.salesorderrequestfilemimetype AS SalesOrderRequestFileMimeType,
  SalesOrderRequest.salesorderrequestfilename AS SalesOrderRequestFileName,
  SalesOrderRequest.salesorderrequestextractoruuid AS SalesOrderRequestExtractorUUID,
  SalesOrderRequest.salesorderreqextractionstatus AS SalesOrderReqExtractionStatus,
  SalesOrderRequest.salesorderreqprocessingstatus AS SalesOrderReqProcessingStatus,
  SalesOrderRequest.salesordertype AS SalesOrderType,
  _SoldToPartyAddress.Customer AS SoldToParty,
  _SoldToPartyAddress.AddressID AS SoldToPartyAddressID,
  _ShipToPartyAddress.Customer AS ShipToParty,
  _ShipToPartyAddress.AddressID AS ShipToPartyAddressID,
  SalesOrderRequest.salesorganization AS SalesOrganization,
  SalesOrderRequest.distributionchannel AS DistributionChannel,
  SalesOrderRequest.organizationdivision AS OrganizationDivision,
  SalesOrderRequest.salesgroup AS SalesGroup,
  SalesOrderRequest.salesoffice AS SalesOffice,
  SalesOrderRequest.purchaseorderbycustomer AS PurchaseOrderByCustomer,
  SalesOrderRequest.transactioncurrency AS TransactionCurrency,
  SalesOrderRequest.totalnetamount AS TotalNetAmount,
  SalesOrderRequest.sdpricingprocedure AS SDPricingProcedure,
  SalesOrderRequest.salesorder AS SalesOrder,
  SalesOrderRequest.createdbyuser AS CreatedByUser,
  SalesOrderRequest.creationdatetime AS CreationDateTime,
  SalesOrderRequest.lastchangedbyuser AS LastChangedByUser,
  SalesOrderRequest.lastchangedatetime AS LastChangeDateTime,
  SalesOrderRequest.requesteddeliverydate AS RequestedDeliveryDate,
  SalesOrderRequest.salesorderreqsimulationstatus AS SalesOrderReqSimulationStatus,
  SalesOrderRequest.salesorderreqapprovalstatus AS SalesOrderReqApprovalStatus,
  SalesOrderRequest.lastsimulateddatetime AS LastSimulatedDateTime,
  SalesOrderRequest.salesorderrequestloghandle AS SalesOrderRequestLogHandle,
  SalesOrderRequest.slsordreqfilecontenthash AS SlsOrdReqFileContentHash,
  SalesOrderRequest.slsordreqsilentdtamigrtnvers AS SlsOrdReqSilentDtaMigrtnVers,
  SalesOrderRequest.incotermsclassification AS IncotermsClassification,
  SalesOrderRequest.incotermsversion AS IncotermsVersion,
  SalesOrderRequest.incotermslocation1 AS IncotermsLocation1,
  SalesOrderRequest.incotermslocation2 AS IncotermsLocation2,
  SalesOrderRequest.customerpaymentterms AS CustomerPaymentTerms,
  SalesOrderRequest.fixedvaluedate AS FixedValueDate,
  SalesOrderRequest.customerpurchaseorderdate AS CustomerPurchaseOrderDate
FROM sdsls_sor AS SalesOrderRequest
LEFT OUTER JOIN I_SalesOrderRequestItem AS _Item ON SalesOrderRequest = _Item.SalesOrderRequest  -- association [0..*]
LEFT OUTER JOIN I_SalesOrderRequestPartner AS _SoldToPartyAddress ON SalesOrderRequest = _SoldToPartyAddress.SalesOrderRequest AND _SoldToPartyAddress.PartnerFunction = 'AG'  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderRequestPartner AS _ShipToPartyAddress ON SalesOrderRequest = _ShipToPartyAddress.SalesOrderRequest AND _ShipToPartyAddress.PartnerFunction = 'WE'  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderRequestDerivedItem AS _DerivedItem ON SalesOrderRequest = _DerivedItem.SalesOrderRequest  -- association [0..*]
LEFT OUTER JOIN I_SalesOrderRequestSource AS _SalesOrderRequestSource ON SalesOrderRequest = _SalesOrderRequestSource.SalesOrderRequest  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_SlsOrganizationDistrChnl AS _SlsOrganizationDistrChnl ON SalesOrganization = _SlsOrganizationDistrChnl.SalesOrganization AND DistributionChannel = _SlsOrganizationDistrChnl.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _OrganizationDivision ON OrganizationDivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SlsOrdReqExtractionStatus AS _SlsOrdReqExtractionStatus ON SalesOrderReqExtractionStatus = _SlsOrdReqExtractionStatus.SalesOrderReqExtractionStatus  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderRequestCategory AS _SalesOrderRequestCategory ON SalesOrderRequestCategory = _SalesOrderRequestCategory.SalesOrderRequestCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderType AS _SalesOrderType ON SalesOrderType = _SalesOrderType.SalesOrderType  -- association [0..1]
LEFT OUTER JOIN I_SlsOrdReqSimulationStatus AS _SlsOrdReqSimulationStatus ON SalesOrderReqSimulationStatus = _SlsOrdReqSimulationStatus.SalesOrderReqSimulationStatus  -- association [0..1]
LEFT OUTER JOIN I_SlsOrdReqApprovalStatus AS _SlsOrdReqApprovalStatus ON SalesOrderReqApprovalStatus = _SlsOrdReqApprovalStatus.SalesOrderReqApprovalStatus  -- association [0..1]
;