I_PaymentAdviceTP

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_PaymentAdviceTP.
-- 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: IPAYTADVCTP

CREATE VIEW I_PaymentAdviceTP AS
SELECT
  P_PaymentAdvice.CompanyCode AS CompanyCode,
  P_PaymentAdvice.PaymentAdviceAccountType AS PaymentAdviceAccountType,
  P_PaymentAdvice.PaymentAdviceAccount AS PaymentAdviceAccount,
  P_PaymentAdvice.PaymentAdvice AS PaymentAdvice,
  P_PaymentAdvice.CompanyCode AS CompanyCodeForEdit,
  cast( P_PaymentAdvice.PaymentAdviceAccountType as far_pa_subledger preserving type ) AS PaytAdviceAccountTypeForEdit,
  P_PaymentAdvice.PaymentAdviceAccount AS PaymentAdviceAccountForEdit,
  P_PaymentAdvice.PaymentAdvice AS PaymentAdviceForEdit,
  P_PaymentAdvice.PaymentDocument AS PaymentDocument,
  P_PaymentAdvice.AccountByShipper AS AccountByShipper,
  P_PaymentAdvice.PaymentCurrency AS PaymentCurrency,
  P_PaymentAdvice.PaymentDate AS PaymentDate,
  P_PaymentAdvice.PaidAmountInPaytCurrency AS PaidAmountInPaytCurrency,
  P_PaymentAdvice.CashDiscountAmountInPaytCrcy AS CashDiscountAmountInPaytCrcy,
  P_PaymentAdvice.PartnerBankCountry AS PartnerBankCountry,
  P_PaymentAdvice.PartnerBankSWIFTCode AS PartnerBankSWIFTCode,
  P_PaymentAdvice.CreatedByUser AS CreatedByUser,
  P_PaymentAdvice.CreationDate AS CreationDate,
  P_PaymentAdvice.LastChangeDate AS LastChangeDate,
  P_PaymentAdvice.LastChangedByUser AS LastChangedByUser,
  P_PaymentAdvice.PaymentAdviceHeaderText AS PaymentAdviceHeaderText,
  P_PaymentAdvice.PaymentAdviceType AS PaymentAdviceType,
  P_PaymentAdvice.PaymentAdviceTypeName AS PaymentAdviceTypeName,
  P_PaymentAdvice.CreationTime AS CreationTime,
  cast(dats_tims_to_tstmp(CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as timestamp ) AS CreationDateTime,
  P_PaymentAdvice.PaymentAdviceStatus AS PaymentAdviceStatus,
  P_PaymentAdvice.PaytAdvcDiffDeterminationRule AS PaytAdvcDiffDeterminationRule,
  P_PaymentAdvice.PaytAdvcDiffDetnRuleDesc AS PaytAdvcDiffDetnRuleDesc,
  P_PaymentAdvice.PaymentAdviceSelectionRule AS PaymentAdviceSelectionRule,
  P_PaymentAdvice.PaytAdviceSelectionRuleDesc AS PaytAdviceSelectionRuleDesc,
  P_PaymentAdvice.OriginalReferenceDocument AS OriginalReferenceDocument,
  P_PaymentAdvice.FullName AS FullName,
  P_PaymentAdvice.OrganizationBPName1 AS OrganizationBPName1,
  P_PaymentAdvice.OrganizationBPName2 AS OrganizationBPName2,
  P_PaymentAdvice.PaymentAdviceIsHeld AS PaymentAdviceIsHeld,
  CompanyCodeName,
  cast('' as avik_ml_is_processed) AS PaymentAdviceIsExtracted,
  cast( 0 as avik_ml_confidence) AS PaytAdviceExtractorConfidence,
  cast('' as avik_ml_uuid) AS PaymentAdviceExtractorUUID,
  P_PaymentAdvice.PaymentAdviceUUID AS PaymentAdviceUUID,
  cast('' as far_pa_ml_extraction_status) AS PaymentAdviceExtractionStatus,
  cast ('' as far_pa_extractor_type) AS PaymentAdviceExtractorType,
  cast( 0 as farp_pa_total_pages) AS PaytAdviceTotalNumberOfPages,
  AccountingClerk,
  cast( P_PaymentAdvice._AccountingClerk.AccountingClerkName as farp_accounting_clerk_name preserving type ) AS AccountingClerkName,
  Customer,
  cast( 0 as farp_pa_item_total_amount) AS PaymentAdviceItemTotalAmount,
  BankReference,
  BusinessPartnerName,
  CAPaymentDocument,
  ContractAccount,
  CAPaymentAdvice,
  P_PaymentAdvice._BusinessPartner AS _BusinessPartner,
  P_PaymentAdvice._AccountingClerk AS _AccountingClerk,
  P_PaymentAdvice._Customer AS _Customer,
  P_PaymentAdvice._CustomerCompany AS _CustomerCompany,
  P_PaymentAdvice._Supplier AS _Supplier,
  P_PaymentAdvice._SupplierCompany AS _SupplierCompany,
  P_PaymentAdvice._CompanyCode AS _CompanyCode,
  P_PaymentAdvice._Currency AS _Currency,
  P_PaymentAdvice._PaytAdvcDiffDeterminationRule AS _PaytAdvcDiffDeterminationRule,
  P_PaymentAdvice._PaytAdviceSelRules AS _PaytAdviceSelRules,
  P_PaymentAdvice._UserContactCard AS _UserContactCard,
  P_PaymentAdvice._PaymentAdviceType AS _PaymentAdviceType
FROM P_PaymentAdvice
LEFT OUTER JOIN I_PaymentAdviceItemTP AS _PaymentAdviceItem ON CompanyCode = _PaymentAdviceItem.CompanyCode AND PaymentAdviceAccountType = _PaymentAdviceItem.PaymentAdviceAccountType AND PaymentAdviceAccount = _PaymentAdviceItem.PaymentAdviceAccount AND PaymentAdvice = _PaymentAdviceItem.PaymentAdvice  -- association [1..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeForEdit ON CompanyCodeForEdit = _CompanyCodeForEdit.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _CustomerForEdit ON PaymentAdviceAccountForEdit = _CustomerForEdit.Customer AND PaytAdviceAccountTypeForEdit = 'D'  -- association [0..1]
LEFT OUTER JOIN I_PaymentAdviceSubledger AS _PaymentAdviceSubledger ON PaytAdviceAccountTypeForEdit = _PaymentAdviceSubledger.PaymentAdviceSubledger  -- association [0..1]
;