I_CAPaymentRunItem

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_CAPaymentRunItem.
-- 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_CAPaymentRunItem AS
SELECT
  laufd AS CAMassRunDate,
  cast(laufi as laufi_kk) AS CAMassRunID,
  payno AS CAIntPaymentIdentification,
  subno AS CAIntAddlPaymentIdentification,
  doc2t AS CAPaymentObjectReferenceType,
  doc2r AS CAPaymentObjectReference,
  cast (left(cast(substring(doc2r, 1, 22) as fkkop_key_kk preserving type ) , 12) as opbel_kk preserving type ) AS CADocumentNumber,
  gpa2r AS CABusinessPartnerReference,
  cast(substring(acc1r,1,12) as vkont_kk preserving type ) AS ContractAccount,
  acc1r AS ContractAccountReference,
  vtref AS CAContract,
  vtpos AS CAProviderContractItemNumber,
  cast(vtre2 as vtre2_kk preserving type ) AS CAAdditionalContract,
  subap AS CASubApplication,
  cast(vor1r as hvorg_kk preserving type ) AS CAMainTransaction,
  cast(vor2r as tvorg_kk preserving type ) AS CASubTransaction,
  adrnr AS AddressID,
  name1 AS PayeeName,
  land1 AS PayeeCountry,
  regio AS Region,
  ort01 AS CityName,
  bldat AS DocumentDate,
  budat AS CAPostingDate,
  faedt AS PaidItemDueDate,
  sktpa AS CAAcceptedCashDiscountRate,
  waers AS TransactionCurrency,
  betrw AS CAAmountInTransactionCurrency,
  augbh AS CAClearingAmountInLocalCrcy,
  augbw AS CAClearingAmountInTransCrcy,
  askth AS CACashDiscountInLocalCurrency,
  asktw AS CACashDiscountInTransCurrency,
  sttax AS CATaxPortionInTransCurrency,
  poken AS CAPaymentExceptionReason,
  zlspr AS CAPaymentLockReason,
  clrlo AS CAClearingLockReason,
  bukrs AS CompanyCode,
  gsber AS BusinessArea,
  c4eye AS CAWorkflowCheckReason,
  optxt AS DocumentItemText,
  cast(substring(ref1r, 1, 16) as xblnr_kk preserving type ) AS CAReferenceDocument,
  lzbkz AS StateCentralBankPaymentReason,
  aqsbw AS CAWhldgTaxAmountInTransCrcy,
  aqsbh AS CAWhldgTaxAmountInLocalCrcy,
  qsskz AS WithholdingTaxCode,
  _CompanyCode.Currency AS CompanyCodeCurrency
FROM dpayp
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentExceptionReason AS _CAPaymentExceptionReason ON CAPaymentExceptionReason = _CAPaymentExceptionReason.CAPaymentExceptionReason  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentLockReason AS _CAPaymentLockReason ON CAPaymentLockReason = _CAPaymentLockReason.CAPaymentLockReason  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentRunHeader AS _CAPaymentRun ON CAMassRunDate = _CAPaymentRun.CAMassRunDate AND CAMassRunID = _CAPaymentRun.CAMassRunID AND CAIntPaymentIdentification = _CAPaymentRun.CAIntPaymentIdentification AND CAIntAddlPaymentIdentification = _CAPaymentRun.CAIntAddlPaymentIdentification  -- association [0..1]
LEFT OUTER JOIN I_CAPostgAndClrgLockReason AS _CAClearingLockReason ON CAClearingLockReason = _CAClearingLockReason.CAPostgAndClrgLockReason  -- association [0..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _CAProviderContract ON CASubApplication = 'P' AND CAContract = _CAProviderContract.CAProviderContract  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON BusinessPartner = _ContractAccountPartner.BusinessPartner AND ContractAccount = _ContractAccountPartner.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_Country AS _PayeeCountry ON PayeeCountry = _PayeeCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Region AS _Region ON PayeeCountry = _Region.Country AND Region = _Region.Region  -- association [0..1]
LEFT OUTER JOIN I_CADocument AS _CADocument ON CADocumentNumber = _CADocument.CADocumentNumber  -- association [0..1]
;