C_SlsOrdWithoutChargeManageTP

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 C_SlsOrdWithoutChargeManageTP.
-- 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 C_SlsOrdWithoutChargeManageTP AS
SELECT
  SalesOrderWithoutCharge.SalesOrderWithoutCharge AS SalesOrderWithoutCharge,
  SalesOrderWithoutCharge.SalesOrderWithoutChargeType AS SalesOrderWithoutChargeType,
  SalesOrderWithoutCharge.SoldToParty AS SoldToParty,
  cast(SalesOrderWithoutCharge.CustomerName as vdm_sold_to_name preserving type) AS CustomerName,
  SoldToPartyAddressID,
  SalesOrderWithoutCharge.SalesOrganization AS SalesOrganization,
  SalesOrderWithoutCharge.SalesOrganization AS SalesOrganizationForFilter,
  SalesOrderWithoutCharge.DistributionChannel AS DistributionChannel,
  SalesOrderWithoutCharge.ReferenceDistributionChannel AS ReferenceDistributionChannel,
  SalesOrderWithoutCharge.OrganizationDivision AS OrganizationDivision,
  SalesOrderWithoutCharge.SalesOffice AS SalesOffice,
  SalesOrderWithoutCharge.SalesGroup AS SalesGroup,
  SalesOrderWithoutCharge.SalesDistrict AS SalesDistrict,
  SalesOrderWithoutCharge.BillingDocumentDate AS BillingDocumentDate,
  SalesOrderWithoutCharge.SDPricingProcedure AS SDPricingProcedure,
  SalesOrderWithoutCharge.CustomerPriceGroup AS CustomerPriceGroup,
  SalesOrderWithoutCharge.SalesOrderWithoutChargeDate AS SalesOrderWithoutChargeDate,
  SalesOrderWithoutCharge.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesOrderWithoutCharge.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  SalesOrderWithoutCharge.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SalesOrderWithoutCharge.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  SalesOrderWithoutCharge.CustomerGroup AS CustomerGroup,
  SalesOrderWithoutCharge.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SalesOrderWithoutCharge.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SalesOrderWithoutCharge.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SalesOrderWithoutCharge.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SalesOrderWithoutCharge.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SalesOrderWithoutCharge.SDDocumentReason AS SDDocumentReason,
  SalesOrderWithoutCharge.SDDocumentReason AS SDDocumentReasonForFilter,
  SalesOrderWithoutCharge.PricingDate AS PricingDate,
  SalesOrderWithoutCharge.ServicesRenderedDate AS ServicesRenderedDate,
  SalesOrderWithoutCharge.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesOrderWithoutCharge.ShippingCondition AS ShippingCondition,
  SalesOrderWithoutCharge.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  SalesOrderWithoutCharge.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  SalesOrderWithoutCharge.ShippingType AS ShippingType,
  SalesOrderWithoutCharge.IncotermsClassification AS IncotermsClassification,
  SalesOrderWithoutCharge.IncotermsVersion AS IncotermsVersion,
  SalesOrderWithoutCharge.IncotermsLocation1 AS IncotermsLocation1,
  SalesOrderWithoutCharge.IncotermsLocation2 AS IncotermsLocation2,
  SalesOrderWithoutCharge.FixedValueDate AS FixedValueDate,
  SalesOrderWithoutCharge.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  SalesOrderWithoutCharge.DeliveryBlockReason AS DeliveryBlockReason,
  SalesOrderWithoutCharge.SlsOrdWthoutChrgApprvlReason AS SlsOrdWthoutChrgApprvlReason,
  SalesOrderWithoutCharge.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesOrderWithoutCharge.BillingCompanyCode AS BillingCompanyCode,
  SalesOrderWithoutCharge.PaymentMethod AS PaymentMethod,
  SalesOrderWithoutCharge.AccountingDocExternalReference AS AccountingDocExternalReference,
  SalesOrderWithoutCharge.TotalNetAmount AS TotalNetAmount,
  SalesOrderWithoutCharge.TransactionCurrency AS TransactionCurrency,
  SalesOrderWithoutCharge.ReferenceSDDocument AS ReferenceSDDocument,
  SalesOrderWithoutCharge.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SalesOrderWithoutCharge.ControllingArea AS ControllingArea,
  SalesOrderWithoutCharge.OverallSDProcessStatus AS OverallSDProcessStatus,
  SalesOrderWithoutCharge.OverallDeliveryBlockStatus AS OverallDeliveryBlockStatus,
  virtual DeliveryBlockCriticality : int1 AS virtualDeliveryBlockCriticalityint1,
  SalesOrderWithoutCharge.OverallBillingBlockStatus AS OverallBillingBlockStatus,
  virtual BillingBlockCriticality : int1 AS virtualBillingBlockCriticalityint1,
  SalesOrderWithoutCharge.OverallDeliveryStatus AS OverallDeliveryStatus,
  virtual OvrlDeliveryStatusCriticality : int1 AS virtualOvrlDeliveryStatusCriticalityint1,
  SalesOrderWithoutCharge.SlsDocOvrlSupplyBlockStatus AS SlsDocOvrlSupplyBlockStatus,
  virtual SlsDocOvrlSupplyBlockStsCrty: int1 AS virtualSlsDocOvrlSupplyBlockStsCrtyint1,
  SalesOrderWithoutCharge.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  virtual OvrlSDDocRejectionStsCritlty : int1 AS virtualOvrlSDDocRejectionStsCritltyint1,
  SalesOrderWithoutCharge.TotalBlockStatus AS TotalBlockStatus,
  virtual TotalBlockStatusCriticality : int1 AS virtualTotalBlockStatusCriticalityint1,
  virtual SlsDocOvrlIncompltnStsCritlty : int1 AS virtualSlsDocOvrlIncompltnStsCritltyint1,
  SalesOrderWithoutCharge.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  virtual HdrGenIncompltnStsCriticality : int1 AS virtualHdrGenIncompltnStsCriticalityint1,
  SalesOrderWithoutCharge.OvrlItmGeneralIncompletionSts AS OvrlItmGeneralIncompletionSts,
  virtual OvrlItmGenIncompltnStsCritlty : int1 AS virtualOvrlItmGenIncompltnStsCritltyint1,
  SalesOrderWithoutCharge.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  SalesOrderWithoutCharge.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  SalesOrderWithoutCharge.OverallChmlCmplncStatus AS OverallChmlCmplncStatus,
  virtual OvrlChmlCmplncStsCriticality : int1 AS virtualOvrlChmlCmplncStsCriticalityint1,
  SalesOrderWithoutCharge.OverallDangerousGoodsStatus AS OverallDangerousGoodsStatus,
  virtual OvrlDngrsGdsStsCriticality : int1 AS virtualOvrlDngrsGdsStsCriticalityint1,
  SalesOrderWithoutCharge.OverallSafetyDataSheetStatus AS OverallSafetyDataSheetStatus,
  virtual OvrlSftyDataSheetStsCritlty : int1 AS virtualOvrlSftyDataSheetStsCritltyint1,
  SalesOrderWithoutCharge.OverallTrdCmplncEmbargoSts AS OverallTrdCmplncEmbargoSts,
  SalesOrderWithoutCharge.OvrlTrdCmplncSnctndListChkSts AS OvrlTrdCmplncSnctndListChkSts,
  SalesOrderWithoutCharge.OvrlTrdCmplncLegalCtrlChkSts AS OvrlTrdCmplncLegalCtrlChkSts,
  SalesOrderWithoutCharge.LastChangeDateTime AS LastChangeDateTime,
  SalesOrderWithoutCharge.CreatedByUser AS CreatedByUser,
  SalesOrderWithoutCharge.CreationDate AS CreationDate,
  SalesOrderWithoutCharge.CreationTime AS CreationTime,
  SalesOrderWithoutCharge.SalesDocumentCreationDateTime AS SalesDocumentCreationDateTime,
  SalesOrderWithoutCharge.LastChangedByUser AS LastChangedByUser,
  SalesOrderWithoutCharge.LastChangeDate AS LastChangeDate,
  SalesOrderWithoutCharge.OutputRequestUUID AS OutputRequestUUID,
  virtual UICT_OutputRequestUUID : boole_d AS virtualUICT_OutputRequestUUIDboole_d,
  virtual UICT_LastChangeDateTime : boole_d AS virtualUICT_LastChangeDateTimeboole_d,
  virtual UICT_WithdrawFromApproval : boole_d AS virtualUICT_WithdrawFromApprovalboole_d,
  SalesOrderWithoutCharge._SalesOrderWithoutChargeType AS _SalesOrderWithoutChargeType,
  SalesOrderWithoutCharge._DistributionChannel AS _DistributionChannel,
  SalesOrderWithoutCharge._OrganizationDivision AS _OrganizationDivision,
  SalesOrderWithoutCharge._SalesGroup AS _SalesGroup,
  SalesOrderWithoutCharge._SalesOffice AS _SalesOffice,
  SalesOrderWithoutCharge._SalesDistrict AS _SalesDistrict,
  SalesOrderWithoutCharge._SDPricingProcedure AS _SDPricingProcedure,
  SalesOrderWithoutCharge._CustomerPriceGroup AS _CustomerPriceGroup,
  SalesOrderWithoutCharge._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
  SalesOrderWithoutCharge._CustomerGroup AS _CustomerGroup,
  SalesOrderWithoutCharge._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  SalesOrderWithoutCharge._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  SalesOrderWithoutCharge._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  SalesOrderWithoutCharge._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  SalesOrderWithoutCharge._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  SalesOrderWithoutCharge._SDDocumentReason AS _SDDocumentReason,
  SalesOrderWithoutCharge._TransactionCurrency AS _TransactionCurrency,
  SalesOrderWithoutCharge._ShippingType AS _ShippingType,
  SalesOrderWithoutCharge._ShippingCondition AS _ShippingCondition,
  SalesOrderWithoutCharge._IncotermsClassification AS _IncotermsClassification,
  SalesOrderWithoutCharge._IncotermsVersion AS _IncotermsVersion,
  SalesOrderWithoutCharge._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SalesOrderWithoutCharge._BillingCompanyCode AS _BillingCompanyCode,
  SalesOrderWithoutCharge._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
  SalesOrderWithoutCharge._DeliveryBlockReason AS _DeliveryBlockReason,
  SalesOrderWithoutCharge._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  SalesOrderWithoutCharge._OverallSDProcessStatus AS _OverallSDProcessStatus,
  SalesOrderWithoutCharge._OverallBillingBlockStatus AS _OverallBillingBlockStatus,
  SalesOrderWithoutCharge._OverallDeliveryBlockStatus AS _OverallDeliveryBlockStatus,
  SalesOrderWithoutCharge._OverallDeliveryStatus AS _OverallDeliveryStatus,
  SalesOrderWithoutCharge._SlsDocOvrlSupplyBlockStatus AS _SlsDocOvrlSupplyBlockStatus,
  SalesOrderWithoutCharge._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  SalesOrderWithoutCharge._SlsOrdWthoutChrgApprvlReason AS _SlsOrdWthoutChrgApprvlReason,
  SalesOrderWithoutCharge._OverallChmlCmplncStatus AS _OverallChmlCmplncStatus,
  SalesOrderWithoutCharge._OverallDangerousGoodsStatus AS _OverallDangerousGoodsStatus,
  SalesOrderWithoutCharge._OvrlSftyDataSheetSts AS _OvrlSftyDataSheetSts,
  SalesOrderWithoutCharge._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  SalesOrderWithoutCharge._TotalBlockStatus AS _TotalBlockStatus,
  SalesOrderWithoutCharge._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  SalesOrderWithoutCharge._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  SalesOrderWithoutCharge._OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus,
  SalesOrderWithoutCharge._OvTrdCmplncSnctndListChkSts AS _OvTrdCmplncSnctndListChkSts,
  SalesOrderWithoutCharge._OvrlTradeCmplncEmbargoStatus AS _OvrlTradeCmplncEmbargoStatus,
  SalesOrderWithoutCharge._OvrlTrdCmplncLegalCtrlChkSts AS _OvrlTrdCmplncLegalCtrlChkSts,
  SalesOrderWithoutCharge._ControllingArea AS _ControllingArea,
  SalesOrderWithoutCharge._CreatedByUser AS _CreatedByUser,
  SalesOrderWithoutCharge._LastChangedByUser AS _LastChangedByUser
FROM R_SalesOrderWithoutChargeTP
LEFT OUTER JOIN C_SlsVolumeNetAmtYearToDate AS _SlsVolumeNetAmtYearToDate ON SalesOrderWithoutCharge = _SlsVolumeNetAmtYearToDate.SalesDocument AND SalesOrderWithoutChargeType = _SlsVolumeNetAmtYearToDate.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN C_SalesDocPaymentMethodVH AS _PaymentMethodVH ON PaymentMethod = _PaymentMethodVH.PaymentMethod AND BillingCompanyCode = _PaymentMethodVH.BillingCompanyCode  -- association [0..1]
LEFT OUTER JOIN C_SlsDocStdPartnerContactInfo AS _SoldToPartyContactInfo ON SalesOrderWithoutCharge = _SoldToPartyContactInfo.SalesDocument AND SoldToParty = _SoldToPartyContactInfo.SoldToParty AND SalesOrderWithoutChargeType = _SoldToPartyContactInfo.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN C_SalesDocSalesOrganizationVH AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN C_SalesDocSalesOrganizationVH AS _SalesOrganizationForFltr ON SalesOrganizationForFilter = _SalesOrganizationForFltr.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN C_SDDocumentReasonValueHelp AS _SDDocumentReasonForFilter ON SDDocumentReasonForFilter = _SDDocumentReasonForFilter.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentStandardPartner AS _StandardPartner ON SalesOrderWithoutCharge = _StandardPartner.SalesDocument  -- association [0..1]
;