C_SchedgAgrmtMassUpdt

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_SchedgAgrmtMassUpdt.
-- 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: CSCHAGRMNT

CREATE VIEW C_SchedgAgrmtMassUpdt AS
SELECT
  cast ( SchedulingAgreement as mm_scheduling_agreement preserving type ) AS SchedulingAgreement,
  _Schedgagrmtpartner.PartnerFunction AS PartnerFunction,
  _Schedgagrmtpartner.PartnerCounter AS PartnerCounter,
  cast ( PurchasingOrganization as ekorg_ll preserving type ) AS PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  cast(PurchasingDocumentType as evart preserving type ) AS PurchasingDocumentType,
  _PurchasingDocumentType._Text[1: Language = $session.system_language ].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  cast( ExchangeRate as wkurs) AS ExchangeRate,
  ExchangeRateIsFixed,
  IncotermsClassification,
  _IncotermsClassification._Text[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  IncotermsLocation1 AS HeaderIncotermsLoc1,
  IncotermsLocation2 AS HeaderIncotermsLoc2,
  IncotermsVersion,
  _IncotermsVersion._Text[1: Language = $session.system_language ].IncotermsVersionName AS IncotermsVersionName,
  PaymentTerms,
  _PaymentTerms._Text[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  cast( _ShdStatusVH.PurchaseContractValidityStatus as mm_contract_status preserving type ) AS PurchaseContractValidityStatus,
  _ShdStatusVH.PurContrValidityStatusName AS PurContrValidityStatusName,
  CreatedByUser,
  CreatedByUserFullName,
  cast ('' as matkl) AS MaterialGroup,
  cast ('' as ewerk) AS Plant,
  cast ('' as matnr) AS Material,
  cast ('' as pstyp) AS PurchasingDocumentItemCategory,
  cast ('' as knttp) AS AccountAssignmentCategory,
  cast ( '' as qzgtyp ) AS QualityCertificateType,
  cast('00000000' as drdat) AS ItemLastTransmissionDate,
  _Schedgagrmtpartner.SupplierSubrange AS SupplierSubrange,
  cast( _Schedgagrmtpartner.Supplier as vdm_supplierref preserving type ) AS ReferenceSupplier,
  _Schedgagrmtpartner._Supplier.SupplierName AS PreferredSupplierName,
  _Schedgagrmtpartner._PartnerFunctionText[1: Language = $session.system_language ].PartnerFunctionName AS PartnerFunctionName,
  cast(' ' as abap.char( 80 )) AS NumberOfBusinessPartners
FROM I_Schedgagrmthdr
LEFT OUTER JOIN C_SchedAgrmtMassUpdtValdtySts AS _ShdStatusVH ON SchedulingAgreement = _ShdStatusVH.SchedulingAgreement  -- association [1..1]
;