R_SalesOrderTP

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_SalesOrderTP.
-- 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_SalesOrderTP AS
SELECT
  SalesOrder.SalesOrder AS SalesOrder,
  SalesOrder.SalesOrder AS SalesOrderForEdit,
  SalesOrder.SalesOrderType AS SalesOrderType,
  SalesOrder.SoldToParty AS SoldToParty,
  _SoldToParty.FullName AS CustomerName,
  _SoldToParty.AddressID AS SoldToPartyAddressID,
  SalesOrder.SalesOrganization AS SalesOrganization,
  SalesOrder.DistributionChannel AS DistributionChannel,
  _SlsOrganizationDistrChnl.ReferenceDistributionChannel AS ReferenceDistributionChannel,
  SalesOrder.OrganizationDivision AS OrganizationDivision,
  SalesOrder.SalesOffice AS SalesOffice,
  SalesOrder.SalesGroup AS SalesGroup,
  SalesOrder.SalesDistrict AS SalesDistrict,
  SalesOrder.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesOrder.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  SalesOrder.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SalesOrder.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  SalesOrder.CorrespncExternalReference AS CorrespncExternalReference,
  SalesOrder.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  SalesOrder.CustomerGroup AS CustomerGroup,
  SalesOrder.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SalesOrder.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SalesOrder.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SalesOrder.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SalesOrder.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SalesOrder.SDDocumentReason AS SDDocumentReason,
  SalesOrder.PricingDate AS PricingDate,
  SalesOrder.ServicesRenderedDate AS ServicesRenderedDate,
  SalesOrder.BillingDocumentDate AS BillingDocumentDate,
  SalesOrder.SDPricingProcedure AS SDPricingProcedure,
  SalesOrder.CustomerPriceGroup AS CustomerPriceGroup,
  SalesOrder.PriceListType AS PriceListType,
  SalesOrder.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesOrder.DeliveryDateTypeRule AS DeliveryDateTypeRule,
  SalesOrder.ShippingCondition AS ShippingCondition,
  SalesOrder.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  SalesOrder.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  SalesOrder.SlsDocIsRlvtForProofOfDeliv AS SlsDocIsRlvtForProofOfDeliv,
  SalesOrder.ShippingType AS ShippingType,
  SalesOrder.ReceivingPoint AS ReceivingPoint,
  SalesOrder.IncotermsClassification AS IncotermsClassification,
  SalesOrder.IncotermsVersion AS IncotermsVersion,
  SalesOrder.IncotermsLocation1 AS IncotermsLocation1,
  SalesOrder.IncotermsLocation2 AS IncotermsLocation2,
  SalesOrder.FixedValueDate AS FixedValueDate,
  SalesOrder.TaxDepartureCountry AS TaxDepartureCountry,
  SalesOrder.VATRegistrationCountry AS VATRegistrationCountry,
  SalesOrder.CustomerTaxClassification1 AS CustomerTaxClassification1,
  SalesOrder.CustomerTaxClassification2 AS CustomerTaxClassification2,
  SalesOrder.CustomerTaxClassification3 AS CustomerTaxClassification3,
  SalesOrder.CustomerTaxClassification4 AS CustomerTaxClassification4,
  SalesOrder.CustomerTaxClassification5 AS CustomerTaxClassification5,
  SalesOrder.CustomerTaxClassification6 AS CustomerTaxClassification6,
  SalesOrder.CustomerTaxClassification7 AS CustomerTaxClassification7,
  SalesOrder.CustomerTaxClassification8 AS CustomerTaxClassification8,
  SalesOrder.CustomerTaxClassification9 AS CustomerTaxClassification9,
  SalesOrder.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  SalesOrder.DeliveryBlockReason AS DeliveryBlockReason,
  SalesOrder.SalesOrderApprovalReason AS SalesOrderApprovalReason,
  SalesOrder.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesOrder.BillingCompanyCode AS BillingCompanyCode,
  SalesOrder.BillingPlan AS BillingPlan,
  SalesOrder.PaymentMethod AS PaymentMethod,
  SalesOrder.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  SalesOrder.AssignmentReference AS AssignmentReference,
  SalesOrder.AccountingDocExternalReference AS AccountingDocExternalReference,
  SalesOrder.TotalNetAmount AS TotalNetAmount,
  SalesOrder.TransactionCurrency AS TransactionCurrency,
  SalesOrder.ReferenceSDDocument AS ReferenceSDDocument,
  SalesOrder.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SalesOrder.CustomerCreditAccount AS CustomerCreditAccount,
  SalesOrder.CreditControlArea AS CreditControlArea,
  SalesOrder.OverallSDProcessStatus AS OverallSDProcessStatus,
  SalesOrder.OverallPurchaseConfStatus AS OverallPurchaseConfStatus,
  SalesOrder.OverallDeliveryBlockStatus AS OverallDeliveryBlockStatus,
  SalesOrder.OverallBillingBlockStatus AS OverallBillingBlockStatus,
  SalesOrder.OverallDeliveryStatus AS OverallDeliveryStatus,
  SalesOrder.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  SalesOrder.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  SalesOrder.TotalBlockStatus AS TotalBlockStatus,
  SalesOrder.SlsDocOvrlSupplyBlockStatus AS SlsDocOvrlSupplyBlockStatus,
  cast(SalesOrder.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type ) AS HdrGeneralIncompletionStatus,
  cast(SalesOrder.OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type ) AS OvrlItmGeneralIncompletionSts,
  SalesOrder.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  SalesOrder.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  SalesOrder.OverallChmlCmplncStatus AS OverallChmlCmplncStatus,
  SalesOrder.OverallDangerousGoodsStatus AS OverallDangerousGoodsStatus,
  SalesOrder.OverallSafetyDataSheetStatus AS OverallSafetyDataSheetStatus,
  SalesOrder.OverallTrdCmplncEmbargoSts AS OverallTrdCmplncEmbargoSts,
  cast(SalesOrder.OvrlTrdCmplncSnctndListChkSts as totwatchlistscrngchksts preserving type ) AS OvrlTrdCmplncSnctndListChkSts,
  SalesOrder.OvrlTrdCmplncLegalCtrlChkSts AS OvrlTrdCmplncLegalCtrlChkSts,
  SalesOrder.SalesOrderDownPaymentStatus AS SalesOrderDownPaymentStatus,
  SalesOrder.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  SalesOrder.EntProjTypeCustomerProject AS EntProjTypeCustomerProject,
  SalesOrder.BusinessSolutionOrder AS BusinessSolutionOrder,
  SalesOrder.SlsContrAutoAssgmtIDForSlsOrd AS SlsContrAutoAssgmtIDForSlsOrd,
  SalesOrder.SalesOrderDate AS SalesOrderDate,
  SalesOrder.SalesOrderProcessingType AS SalesOrderProcessingType,
  SalesOrder.ControllingArea AS ControllingArea,
  SalesOrder.CreatedByUser AS CreatedByUser,
  SalesOrder.CreationDate AS CreationDate,
  SalesOrder.CreationTime AS CreationTime,
  SalesOrder.LastChangedByUser AS LastChangedByUser,
  SalesOrder.LastChangeDate AS LastChangeDate,
  SalesOrder.IsEUTriangularDeal AS IsEUTriangularDeal,
  OutputRequest.OutputRequestUUID AS OutputRequestUUID,
  SalesOrder._SalesOrderType AS _SalesOrderType,
  SalesOrder._SalesOrganization AS _SalesOrganization,
  SalesOrder._DistributionChannel AS _DistributionChannel,
  SalesOrder._OrganizationDivision AS _OrganizationDivision,
  SalesOrder._SalesGroup AS _SalesGroup,
  SalesOrder._SalesOffice AS _SalesOffice,
  SalesOrder._SalesDistrict AS _SalesDistrict,
  SalesOrder._SDPricingProcedure AS _SDPricingProcedure,
  SalesOrder._CreatedByUser AS _CreatedByUser,
  SalesOrder._CustomerPriceGroup AS _CustomerPriceGroup,
  SalesOrder._PriceListType AS _PriceListType,
  SalesOrder._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
  SalesOrder._CustomerGroup AS _CustomerGroup,
  SalesOrder._LastChangedByUser AS _LastChangedByUser,
  SalesOrder._SDDocumentReason AS _SDDocumentReason,
  SalesOrder._TransactionCurrency AS _TransactionCurrency,
  SalesOrder._ShippingType AS _ShippingType,
  SalesOrder._ShippingCondition AS _ShippingCondition,
  SalesOrder._DeliveryDateTypeRule AS _DeliveryDateTypeRule,
  SalesOrder._IncotermsClassification AS _IncotermsClassification,
  SalesOrder._IncotermsVersion AS _IncotermsVersion,
  SalesOrder._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SalesOrder._BillingCompanyCode AS _BillingCompanyCode,
  SalesOrder._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
  SalesOrder._DeliveryBlockReason AS _DeliveryBlockReason,
  SalesOrder._CustomerCreditAccount AS _CustomerCreditAccount,
  SalesOrder._CreditControlArea AS _CreditControlArea,
  SalesOrder._OverallSDProcessStatus AS _OverallSDProcessStatus,
  SalesOrder._OverallPurchaseConfStatus AS _OverallPurchaseConfStatus,
  SalesOrder._OverallBillingBlockStatus AS _OverallBillingBlockStatus,
  SalesOrder._OverallDeliveryBlockStatus AS _OverallDeliveryBlockStatus,
  SalesOrder._OverallDeliveryStatus AS _OverallDeliveryStatus,
  SalesOrder._TotalCreditCheckStatus AS _TotalCreditCheckStatus,
  SalesOrder._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  SalesOrder._SalesOrderApprovalReason AS _SalesOrderApprovalReason,
  SalesOrder._OverallChmlCmplncStatus AS _OverallChmlCmplncStatus,
  SalesOrder._OverallDangerousGoodsStatus AS _OverallDangerousGoodsStatus,
  SalesOrder._OvrlSftyDataSheetSts AS _OvrlSftyDataSheetSts,
  SalesOrder._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  SalesOrder._TotalBlockStatus AS _TotalBlockStatus,
  SalesOrder._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  SalesOrder._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  SalesOrder._OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus,
  SalesOrder._OvTrdCmplncSnctndListChkSts AS _OvTrdCmplncSnctndListChkSts,
  SalesOrder._OvrlTradeCmplncEmbargoStatus AS _OvrlTradeCmplncEmbargoStatus,
  SalesOrder._OvrlTrdCmplncLegalCtrlChkSts AS _OvrlTrdCmplncLegalCtrlChkSts,
  SalesOrder._DownPaymentStatus AS _DownPaymentStatus,
  SalesOrder._OverallOrdReltdBillgStatus AS _OverallOrdReltdBillgStatus,
  SalesOrder._SlsDocOvrlSupplyBlockStatus AS _SlsDocOvrlSupplyBlockStatus,
  SalesOrder._ControllingArea AS _ControllingArea,
  SalesOrder._TaxDepartureCountry AS _TaxDepartureCountry,
  SalesOrder._VATRegistrationCountry AS _VATRegistrationCountry,
  SalesOrder._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup,
  SalesOrder._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  SalesOrder._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  SalesOrder._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  SalesOrder._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  SalesOrder._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  SalesOrder._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory
FROM I_SalesOrder AS SalesOrder
LEFT OUTER JOIN R_OutputRequestTP AS _OutputRequest ON OutputRequestUUID = _OutputRequest.OutputRequestUUID  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderPartner AS _SoldToParty ON SalesOrder = _SoldToParty.SalesOrder AND _SoldToParty.PartnerFunction = 'AG'  -- association [0..1]
LEFT OUTER JOIN I_SlsOrganizationDistrChnl AS _SlsOrganizationDistrChnl ON SalesOrganization = _SlsOrganizationDistrChnl.SalesOrganization AND DistributionChannel = _SlsOrganizationDistrChnl.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesOrder = _Extension.SalesDocument  -- association [1]
LEFT OUTER JOIN R_SalesOrderItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderPartnerTP AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderPricingElementTP AS _PricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesOrderBillingPlanTP AS _BillingPlan ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SalesOrderShipToPartyTP AS _ShipToParty ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SalesOrderRelatedObjectTP AS _RelatedObject ON /* condition not available in parsed metadata */  -- association [0..*]
;