I_PaymentTermsConditions

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_PaymentTermsConditions.
-- 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_PaymentTermsConditions AS
SELECT
  cast( zterm as farp_dzterm preserving type ) AS PaymentTerms,
  cast( ztagg as dztagg_052 preserving type ) AS PaymentTermsValidityMonthDay,
  cast( koart as koart_z preserving type ) AS PaymentTermsFinAccountType,
  cast( zfael as dzfael preserving type ) AS BslnDteCalcDayOfMnth,
  cast( zmona as dzmona preserving type ) AS BslnDteCalcAddlMnths,
  cast( zschf as farp_dzlspr preserving type ) AS PaymentBlockingReason,
  xchpb AS PaymentBlockIsTransferred,
  cast( zlsch as farp_schzw_bseg preserving type ) AS PaymentMethod,
  xchpm AS PaymentMethodIsTransferred,
  xsplt AS PaymentIsInstallment,
  xscrc AS RecrrgEntPaytTrmsIsFrmAcctMstr,
  f_obsolete AS PaymentTermsIsHidden,
  cast( cast( ztag1 as abap.dec(3,0) ) as farp_dzbd1t preserving type ) AS CashDiscount1Days,
  cast( cast( ztag2 as abap.dec(3,0) ) as farp_dzbd2t preserving type ) AS CashDiscount2Days,
  cast( cast( ztag3 as abap.dec(3,0) ) as farp_dzbd3t preserving type ) AS NetPaymentDays,
  cast( zprz1 as dzbd1p_farp preserving type ) AS CashDiscount1Percent,
  cast( zprz2 as dzbd2p_farp preserving type ) AS CashDiscount2Percent,
  cast( zstg1 as abap.dec(2,0) ) AS CashDiscount1DayOfMonth,
  cast( zstg2 as abap.dec(2,0) ) AS CashDiscount2DayOfMonth,
  cast( zstg3 as abap.dec(2,0) ) AS CashDiscount3DayOfMonth,
  cast( zsmn1 as abap.dec(2,0) ) AS CashDiscount1AdditionalMonths,
  cast( zsmn2 as abap.dec(2,0) ) AS CashDiscount2AdditionalMonths,
  cast( zsmn3 as abap.dec(2,0) ) AS CashDiscount3AdditionalMonths
FROM P_PaymentTermsConditions2
LEFT OUTER JOIN I_PaymentTermsConditionsText AS _Text ON PaymentTerms = _Text.PaymentTerms AND PaymentTermsValidityMonthDay = _Text.PaymentTermsValidityMonthDay  -- association [0..*]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [1..1]
;