A_SalesOrderSimulation_2

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 A_SalesOrderSimulation_2.
-- 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 A_SalesOrderSimulation_2 AS
SELECT
  SalesOrder.SalesOrder AS SalesOrder,
  cast(SalesOrder.SalesOrderType as auart_spr preserving type ) AS SalesOrderType,
  SalesOrder.SalesOrderProcessingType AS SalesOrderProcessingType,
  SalesOrder.SoldToParty AS SoldToParty,
  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.CreatedByUser AS CreatedByUser,
  SalesOrder.CreationDate AS CreationDate,
  SalesOrder.CreationTime AS CreationTime,
  SalesOrder.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesOrder.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  SalesOrder.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  SalesOrder.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SalesOrder.CorrespncExternalReference AS CorrespncExternalReference,
  SalesOrder.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  SalesOrder.BusinessSolutionOrder AS BusinessSolutionOrder,
  SalesOrder.ReferenceSDDocument AS ReferenceSDDocument,
  SalesOrder.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SalesOrder.SDDocumentReason AS SDDocumentReason,
  SalesOrder.SalesOrderDate AS SalesOrderDate,
  SalesOrder.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesOrder.PricingDate AS PricingDate,
  SalesOrder.ServicesRenderedDate AS ServicesRenderedDate,
  SalesOrder.BillingDocumentDate AS BillingDocumentDate,
  SalesOrder.TotalNetAmount AS TotalNetAmount,
  SalesOrder.TransactionCurrency AS TransactionCurrency,
  SalesOrder.DeliveryDateTypeRule AS DeliveryDateTypeRule,
  SalesOrder.ShippingCondition AS ShippingCondition,
  SalesOrder.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  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.SDPricingProcedure AS SDPricingProcedure,
  SalesOrder.CustomerPriceGroup AS CustomerPriceGroup,
  SalesOrder.PriceListType AS PriceListType,
  SalesOrder.FixedValueDate AS FixedValueDate,
  SalesOrder.TaxDepartureCountry AS TaxDepartureCountry,
  SalesOrder.VATRegistrationCountry AS VATRegistrationCountry,
  SalesOrder.IsEUTriangularDeal AS IsEUTriangularDeal,
  SalesOrder.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesOrder.PaymentMethod AS PaymentMethod,
  SalesOrder.BillingCompanyCode AS BillingCompanyCode,
  SalesOrder.ControllingArea AS ControllingArea,
  SalesOrder.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  SalesOrder.AssignmentReference AS AssignmentReference,
  SalesOrder.AccountingDocExternalReference AS AccountingDocExternalReference,
  SalesOrder.CustomerCreditAccount AS CustomerCreditAccount,
  SalesOrder.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  SalesOrder.DeliveryBlockReason AS DeliveryBlockReason,
  SalesOrder.SalesOrderApprovalReason AS SalesOrderApprovalReason,
  SalesOrder.SlsContrAutoAssgmtIDForSlsOrd AS SlsContrAutoAssgmtIDForSlsOrd,
  SalesOrder.CustomerGroup AS CustomerGroup,
  SalesOrder.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SalesOrder.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SalesOrder.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SalesOrder.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SalesOrder.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  cast( '' as vdm_sdoc_crdt_chk_is_tb_dsbld ) AS CreditCheckIsToBeDisabled,
  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.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  SalesOrder.OvrlItmGeneralIncompletionSts 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,
  SalesOrder.OvrlTrdCmplncSnctndListChkSts AS OvrlTrdCmplncSnctndListChkSts,
  SalesOrder.OvrlTrdCmplncLegalCtrlChkSts AS OvrlTrdCmplncLegalCtrlChkSts,
  SalesOrder.SalesOrderDownPaymentStatus AS SalesOrderDownPaymentStatus,
  SalesOrder.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus
FROM R_SalesOrderTP AS SalesOrder
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 A_SalesOrderItemSimulation_2 AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_SalesOrderPartnerSimln_2 AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_SlsOrdPricingElementSimln_2 AS _PricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
;