I_JP_SubcontrgPaymentTerm

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_SubcontrgPaymentTerm.
-- 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_SubcontrgPaymentTerm AS
SELECT
  cast(I_JP_SubcontrgSuplr.Supplier as lifnr preserving type ) AS Supplier,
  cast(I_JP_SubcontrgSuplr.CompanyCode as bukrs preserving type ) AS CompanyCode,
  _SupplierPurchasingOrg.PurchasingOrganization AS PurchasingOrganization,
  I_JP_SubcontrgSuplr.JP_SubcontractorType AS JP_SubcontractorType,
  _Subcontract.JP_SubcontractorTypeDomainText AS JP_SubcontractorTypeDomainText,
  case when _SupplierPurchasingOrg.PaymentTerms is not null then _SupplierPurchasingOrg.PaymentTerms else I_JP_SubcontrgSuplr.PaymentTerms end as PaymentTerms AS PaymentTermsendasPaymentTerms,
  I_JP_SubcontrgSuplr.JP_CompletionDateOfInspValue AS JP_CompletionDateOfInspValue,
  cast(I_JP_SubcontrgSuplr.HouseBank as hbkid preserving type ) AS HouseBank,
  cast(_HouseBank.BankCountry as banks preserving type ) AS BankCountry,
  cast(_HouseBank.BankInternalID as bankl preserving type ) AS BankInternalID,
  glo_sc_aplpar_jp.effctv_date AS EffectiveDate,
  I_JP_SubcontrgSuplr._CompanyCode AS _CompanyCode,
  I_JP_SubcontrgSuplr._Supplier AS _Supplier
FROM I_JP_SubcontrgSuplr
LEFT OUTER JOIN glo_sc_aplpar_jp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_HouseBankMaster AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [1..1]
LEFT OUTER JOIN I_SupplierPurchasingOrg AS _SupplierPurchasingOrg ON Supplier = _SupplierPurchasingOrg.Supplier  -- association [1..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrg ON _PurchasingOrg.PurchasingOrganization = PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_JP_SubcontrgSubcontractorVH AS _Subcontract ON JP_SubcontractorType = _Subcontract.JP_SubcontractorType  -- association [1..1]
;