I_PaymentAdviceItem

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_PaymentAdviceItem.
-- 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: IPAYTADVCITM

CREATE VIEW I_PaymentAdviceItem AS
SELECT
  bukrs AS CompanyCode,
  koart AS PaymentAdviceAccountType,
  konto AS PaymentAdviceAccount,
  cast(avsid as farp_pa_avsid preserving type) AS PaymentAdvice,
  avspo AS PaymentAdviceItem,
  abwko AS PaymentAdviceAltvAccount,
  cast(abwbu as farp_abwbu_av preserving type) AS AlternativeCompanyCode,
  belnr AS AccountingDocument,
  cast(xblnr as far_pa_xblnr1 preserving type) AS DocumentReferenceID,
  lbinvref AS LockboxInvoiceReference,
  vbeln AS BillingDocument,
  cast(filkd as farp_filkd preserving type) AS BranchAccount,
  cast(cpudt as farp_cpudt preserving type) AS AccountingDocumentCreationDate,
  gsber AS BusinessArea,
  cast(zuonr as farp_dzuonr preserving type) AS AssignmentReference,
  restg AS PaytDifferenceReasonExtCode,
  cast(sgtxt as farp_sgtxt preserving type) AS DocumentItemText,
  cast(mwsts as farp_mwsts preserving type) AS TaxAmountInCoCodeCrcy,
  mwskz AS TaxCode,
  wrbtr AS GrossAmountInPaymentCurrency,
  nebtr AS NetPaymentAmountInPaytCurrency,
  cast(wskto as far_pa_wskto_av preserving type ) AS CashDiscountAmountInPaytCrcy,
  gjahr AS FiscalYear,
  cast(buzei as farp_buzei preserving type) AS AccountingDocumentItem,
  cast(abwka as farp_abwka_av preserving type) AS PaymentAdviceAltvAccountType,
  zbdxp AS CashDiscountPercent,
  zbdxt AS CashDiscountDays,
  cast(difhw as farp_difhw preserving type) AS DifferenceAmountInCoCodeCrcy,
  cast(diffw as farp_diffw preserving type) AS DifferenceAmount,
  cast(difh2 as farp_difh2 preserving type) AS DiffAmtInAdditionalCurrency1,
  cast(difh3 as farp_difh3 preserving type) AS DiffAmtInAdditionalCurrency2,
  cast(xaktp as farp_xaktp preserving type) AS ItemIsActivated,
  cast(xakts as far_pa_xakts preserving type) AS CashDiscountIsActivated,
  cast(xppmt as farp_xppmt preserving type) AS IsPartialPayment,
  cast(xvort as farp_xvort preserving type) AS PaytDiffRsdlBalIsCarriedFwd,
  rstgn AS PaymentDifferenceReason,
  waers AS Currency,
  cast(xref1 as farp_xref1 preserving type) AS Reference1IDByBusinessPartner,
  cast(xref2 as farp_xref2 preserving type) AS Reference2IDByBusinessPartner,
  liefn AS DeliveryDocument,
  cast(redat as farp_pa_redat preserving type) AS InvoiceDate,
  bstnk AS PurchasingDocReferenceByCust,
  xacon AS IsPostedOnAccount,
  cast(astat as farp_astat_avik preserving type) AS PaymentAdviceStatus,
  cast(abbtr as far_pa_abbtr_av preserving type) AS DeductionAmountInPaytCurrency,
  cast(kidno as farp_kidno preserving type) AS PaymentReference,
  sfeld AS PaymentAdviceSelectionField,
  swert AS PaymentAdviceSelectionValue,
  cast(afeld as farp_afeld_av preserving type) AS PaytAdvcExternalSelectionField,
  fica_selw1 AS CASelectionValue,
  fica_selt1 AS CASelectionCategory,
  fica_opbel AS CADocumentNumber,
  fica_betrw_ac AS CAAssignedAmountInPaytCrcy,
  cast(_CompanyCode._Country.TaxCalculationProcedure as farp_kalsm_d preserving type ) AS TaxCalculationProcedure,
  _OperationalAcctgDocItem.AdditionalCurrency1 AS AdditionalCurrency1,
  _OperationalAcctgDocItem.AdditionalCurrency2 AS AdditionalCurrency2,
  _CompanyCode.Currency AS CompanyCodeCurrency
FROM avip
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _AlternativeCompanyCode ON AlternativeCompanyCode = _AlternativeCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [1..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCode = _TaxCode.TaxCode AND TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure  -- association [1..1]
LEFT OUTER JOIN I_PaymentDifferenceReason AS _PaymentDifferenceReason ON CompanyCode = _PaymentDifferenceReason.CompanyCode AND PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PaymentAdviceSubItem AS _PaymentAdviceSubItem ON CompanyCode = _PaymentAdviceSubItem.CompanyCode AND PaymentAdviceAccountType = _PaymentAdviceSubItem.PaymentAdviceAccountType AND PaymentAdviceAccount = _PaymentAdviceSubItem.PaymentAdviceAccount AND PaymentAdvice = _PaymentAdviceSubItem.PaymentAdvice AND PaymentAdviceItem = _PaymentAdviceSubItem.PaymentAdviceItem  -- association [1..*]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure  -- association [1..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND CompanyCode = _OperationalAcctgDocItem.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON PaymentAdviceAccount = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON PaymentAdviceAccount = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON PaymentAdviceAccount = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON PaymentAdviceAccount = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON PaymentAdviceAccount = _BusinessPartner.BusinessPartner AND PaymentAdviceAccountType = 'G'  -- association [0..1]
;