C_MassChangeSalesContract

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_MassChangeSalesContract.
-- 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_MassChangeSalesContract AS
SELECT
  cast(SalesDocument as sales_contract preserving type) AS SalesContract,
  cast( SalesDocumentType as sales_contract_type preserving type ) AS SalesContractType,
  SDDocumentReason,
  CreationDate,
  CreatedByUser,
  SalesOrganization,
  DistributionChannel,
  cast( OrganizationDivision as organization_division preserving type ) AS OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SalesDistrict,
  ShippingCondition,
  cast( IncotermsClassification as vdm_header_incoterm1 preserving type ) AS HeaderIncotermsClassification,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  ShippingType,
  SoldToParty,
  cast('' as ad_namtext ) AS ShipToPartyName,
  cast('' as ad_namtext ) AS SoldToPartyName,
  cast('' as ad_namtext ) AS BillToPartyName,
  cast('' as ad_namtext ) AS PayerPartyName,
  cast('' as ad_namtext ) AS ResponsibleEmployeeName,
  cast('' as ad_namtext ) AS SalesEmployeeName,
  OverallSDProcessStatus,
  SalesDocApprovalStatus,
  cast(OverallSDDocumentRejectionSts as ovrl_sd_doc_rejection_status preserving type ) AS OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  cast(HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type ) AS HdrGeneralIncompletionStatus,
  cast(HeaderBillgIncompletionStatus as hdrbillgincompletionstatus preserving type ) AS HeaderBillgIncompletionStatus,
  cast(OverallPricingIncompletionSts as ovrl_pricing_incompletion_sts preserving type ) AS OverallPricingIncompletionSts,
  cast(OverallTrdCmplncEmbargoSts as overall_embargo_status preserving type ) AS OverallTrdCmplncEmbargoSts,
  cast(OvrlTrdCmplncSnctndListChkSts as ovrl_watchlist_screening_sts preserving type ) AS OvrlTrdCmplncSnctndListChkSts,
  cast(OvrlTrdCmplncLegalCtrlChkSts as overall_legal_control_status preserving type ) AS OvrlTrdCmplncLegalCtrlChkSts,
  cast(OverallChmlCmplncStatus as ovrl_product_marketability_sts preserving type ) AS OverallChmlCmplncStatus,
  cast(OverallDangerousGoodsStatus as overall_dangerous_goods_status preserving type ) AS OverallDangerousGoodsStatus,
  cast(ContractDownPaymentStatus as hdr_down_payment_status preserving type) AS ContractDownPaymentStatus,
  AgrmtValdtyStartDate AS SalesContractValidityStartDate,
  AgrmtValdtyEndDate AS SalesContractValidityEndDate,
  TotalNetAmount,
  TransactionCurrency,
  BusinessArea,
  CostCenter,
  ControllingArea,
  BillingCompanyCode,
  PricingDate,
  CustomerPurchaseOrderDate,
  PurchaseOrderByCustomer,
  SalesDocumentDate AS SalesContractDate,
  CreditControlArea,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  cast( SalesDocApprovalReason as sd_apm_approval_reason_vdm preserving type ) AS SalesContractApprovalReason,
  cast( CustomerPaymentTerms as hdr_dzterm preserving type ) AS CustomerPaymentTerms,
  PaymentMethod,
  MasterSalesContract,
  cast( ' ' as abap.char( 100 )) AS AdditionalPartnerName,
  cast( ' ' as productnumber ) AS Product,
  cast( ' ' as parvw_unv preserving type ) AS PartnerFunction,
  cast( ' ' as kunnr) AS Customer,
  cast( ' ' as lifnr) AS Supplier,
  cast( '00000000' as pernr_d) AS Personnel,
  cast( '0000000000' as parnr) AS ContactPerson,
  hextobin( '00000000000000000000000000000000' ) AS SlsDocMassChangeRequestUUID,
  cast ('H' as sd_mcc_entity_level) AS SlsDocMassChgEntityLevel,
  cast( '' as spart ) AS Division,
  cast( '' as pstyv ) AS SalesContractItemCategory,
  cast( ' ' as abgru_va preserving type ) AS SalesDocumentRjcnReason,
  cast( '00000000' as fkdat ) AS BillingDocumentDate,
  cast( '' as werks_ext ) AS Plant,
  cast( ' ' as prctr ) AS ProfitCenter,
  cast( '00' as lprio ) AS DeliveryPriority,
  cast( '' as gbsta preserving type ) AS SDProcessStatus,
  cast( ' ' as absta_vb preserving type ) AS SDDocumentRejectionStatus,
  cast( ' ' as general_item_incompletion_sts preserving type ) AS ItemGeneralIncompletionStatus,
  cast( ' ' as itms_incompltn_sts_billg preserving type ) AS ItemBillingIncompletionStatus,
  cast( ' ' as pricing_incompletion_status preserving type ) AS PricingIncompletionStatus,
  cast( ' ' as itm_deliv_incompletion_status preserving type ) AS ItemDeliveryIncompletionStatus,
  cast( ' ' as rfsta preserving type ) AS SDDocReferenceStatus,
  cast( ' ' as rfgsa preserving type ) AS TotalSDDocReferenceStatus,
  cast('' as embargochksts preserving type ) AS TrdCmplncEmbargoSts,
  cast('' as watchlistscrngchksts preserving type ) AS TrdCmplncSnctndListChkSts,
  cast('' as mon_tdd_pcsta preserving type ) AS ChmlCmplncStatus,
  cast('' as mon_tdd_dgsta preserving type ) AS DangerousGoodsStatus,
  cast('' as dp_clear_sta preserving type ) AS ContractItemDownPaymentStatus,
  cast('' as abap.char(4) ) AS PaymentTerms,
  cast(' ' as inco1 preserving type) AS IncotermsClassification,
  SalesDocumentType,
  SDDocumentCategory,
  SalesContract._SDDocumentReason._Text[1:Language = $session.system_language].SDDocumentReasonText AS SDDocumentReasonText,
  SalesContract._SalesGroup._Text[1:Language = $session.system_language].SalesGroupName AS SalesGroupName,
  SalesContract._SalesOffice._Text[1:Language = $session.system_language].SalesOfficeName AS SalesOfficeName,
  SalesContract._SalesDistrict._Text[1:Language = $session.system_language].SalesDistrictName AS SalesDistrictName,
  SalesContract._ShippingCondition._Text[1:Language = $session.system_language].ShippingConditionName AS ShippingConditionName,
  SalesContract._CustomerPaymentTerms._Text[1:Language = $session.system_language].CustomerPaymentTermsName AS CustomerPaymentTermsName,
  SalesContract._IncotermsClassification._Text[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  SalesContract._TransactionCurrency._Text[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  _StandardPartner.ShipToParty AS ShipToParty,
  _StandardPartner.PayerParty AS PayerParty,
  _StandardPartner.BillToParty AS BillToParty,
  _StandardPartner.ResponsibleEmployee AS ResponsibleEmployee,
  _StandardPartner.SalesEmployee AS SalesEmployee,
  _StandardPartner._ShipToParty AS _ShipToParty,
  _StandardPartner._PayerParty AS _PayerParty,
  _StandardPartner._BillToParty AS _BillToParty,
  _StandardPartner._ResponsibleEmployee AS _ResponsibleEmployee,
  _StandardPartner._SalesEmployee AS _SalesEmployee
FROM I_SalesDocument AS SalesContract
LEFT OUTER JOIN I_SDDocStandardPartner AS _StandardPartner ON SalesContract = _StandardPartner.SDDocument  -- association [0..1]
LEFT OUTER JOIN I_SlsDocNonStdPartner AS _NonStdPartner ON SalesContract = _NonStdPartner.SDDocument  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentPartner AS _SDDocumentPartner ON SalesContract = _SDDocumentPartner.SDDocument  -- association [1..*]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesContractItem ON SalesContract = _SalesContractItem.SalesDocument  -- association [0..*]
LEFT OUTER JOIN C_SalesDocumentItemWl AS _SalesDocumentItem ON SalesContract = _SalesDocumentItem.SalesDocument  -- association [0..*]
LEFT OUTER JOIN C_MassChgSalesDocumentItemWl AS _MassChgSalesDocumentItemWl ON SalesContract = _MassChgSalesDocumentItemWl.SalesDocument  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesContract = _Extension.SalesDocument  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_SalesDocPaymentMethodVH AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND BillingCompanyCode = _PaymentMethod.BillingCompanyCode  -- association [0..1]
;