ESH_B_CNDNCONTR

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 ESH_B_CNDNCONTR.
-- 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: ESH_B_CC

CREATE VIEW ESH_B_CNDNCONTR AS
SELECT
  coco.CreatedByUser AS CreatedByUser,
  coco.CreationDate AS CreationDate,
  coco.CndnContrValidFrom AS CndnContrValidFrom,
  coco.CndnContrValidTo AS CndnContrValidTo,
  coco.ExternalDocumentReferenceID AS ExternalDocumentReferenceID,
  coco.CndnContrType AS CndnContrType,
  coco.Customer AS Customer,
  _Customer._CustomerToBusinessPartner.BusinessPartnerUUID AS CustomerBpUUID,
  coco.Supplier AS Supplier,
  _Supplier._SupplierToBusinessPartner.BusinessPartnerUUID AS SupplierBpUUID,
  coco.PurchasingOrganization AS PurchasingOrganization,
  coco.PurchasingGroup AS PurchasingGroup,
  coco.SalesOrganization AS SalesOrganization,
  coco.DistributionChannel AS DistributionChannel,
  coco.Division AS Division,
  coco.CndnContrIsInactive AS CndnContrIsInactive,
  coco.CompanyCode AS CompanyCode,
  coco.PersonWorkAgreement AS PersonWorkAgreement,
  coco.CndnContrWorkerCostCenter AS CndnContrWorkerCostCenter
FROM I_ConditionContract AS coco
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;