I_JP_SubcontrgSubcontractorDP

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 I_JP_SubcontrgSubcontractorDP.
-- 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 I_JP_SubcontrgSubcontractorDP AS
SELECT
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  SupplierName AS BPSupplierName,
  CompanyCodeName,
  PaymentTerms,
  Country,
  JP_CapitalAmount,
  JP_SupplierCapitalAmountCrcy,
  _JP_SubcontrgSuplr.JP_SubcontractorType AS JP_SubcontractorType,
  _JP_SubcontrgSuplr.JP_CompletionDateOfInspValue AS JP_CompletionDateOfInspValue,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  JP_EmployeeNumber
FROM I_JP_SubcontrgSuplrMstr
LEFT OUTER JOIN I_CurrencyStdVH AS _Currency ON JP_SupplierCapitalAmountCrcy = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_JP_SubcontrgSuplr AS _JP_SubcontrgSuplr ON Supplier = _JP_SubcontrgSuplr.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [1..1]
;