C_PaymentAdvice

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 C_PaymentAdvice.
-- 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: CPAYTADVC

CREATE VIEW C_PaymentAdvice AS
SELECT
  I_PaymentAdviceTP.CompanyCode AS CompanyCode,
  I_PaymentAdviceTP.PaymentAdviceAccountType AS PaymentAdviceAccountType,
  I_PaymentAdviceTP.PaymentAdviceAccount AS PaymentAdviceAccount,
  I_PaymentAdviceTP.PaymentAdvice AS PaymentAdvice,
  I_PaymentAdviceTP.CompanyCodeForEdit AS CompanyCodeForEdit,
  I_PaymentAdviceTP.PaytAdviceAccountTypeForEdit AS PaytAdviceAccountTypeForEdit,
  I_PaymentAdviceTP.PaymentAdviceAccountForEdit AS PaymentAdviceAccountForEdit,
  I_PaymentAdviceTP.PaymentAdviceForEdit AS PaymentAdviceForEdit,
  I_PaymentAdviceTP.PaidAmountInPaytCurrency AS PaidAmountInPaytCurrency,
  I_PaymentAdviceTP.PaymentCurrency AS PaymentCurrency,
  I_PaymentAdviceTP.CashDiscountAmountInPaytCrcy AS CashDiscountAmountInPaytCrcy,
  I_PaymentAdviceTP.PaymentDocument AS PaymentDocument,
  I_PaymentAdviceTP.PaymentDate AS PaymentDate,
  I_PaymentAdviceTP.PaytAdvcDiffDeterminationRule AS PaytAdvcDiffDeterminationRule,
  I_PaymentAdviceTP.PaytAdvcDiffDetnRuleDesc AS PaytAdvcDiffDetnRuleDesc,
  I_PaymentAdviceTP.PaymentAdviceSelectionRule AS PaymentAdviceSelectionRule,
  I_PaymentAdviceTP.PaytAdviceSelectionRuleDesc AS PaytAdviceSelectionRuleDesc,
  I_PaymentAdviceTP.AccountByShipper AS AccountByShipper,
  I_PaymentAdviceTP.PaymentAdviceHeaderText AS PaymentAdviceHeaderText,
  I_PaymentAdviceTP.PaymentAdviceType AS PaymentAdviceType,
  I_PaymentAdviceTP.PaymentAdviceTypeName AS PaymentAdviceTypeName,
  I_PaymentAdviceTP.CustomerName AS CustomerName,
  I_PaymentAdviceTP.AccountingClerk AS AccountingClerk,
  I_PaymentAdviceTP.AccountingClerkName AS AccountingClerkName,
  I_PaymentAdviceTP.Customer AS Customer,
  I_PaymentAdviceTP.OrganizationBPName1 AS OrganizationBPName1,
  I_PaymentAdviceTP.OrganizationBPName2 AS OrganizationBPName2,
  I_PaymentAdviceTP.CreationDate AS CreationDate,
  I_PaymentAdviceTP.CreatedByUser AS CreatedByUser,
  I_PaymentAdviceTP.FullName AS FullName,
  I_PaymentAdviceTP.LastChangeDate AS LastChangeDate,
  I_PaymentAdviceTP.LastChangedByUser AS LastChangedByUser,
  I_PaymentAdviceTP.CreationTime AS CreationTime,
  I_PaymentAdviceTP.CreationDateTime AS CreationDateTime,
  I_PaymentAdviceTP.PaymentAdviceIsHeld AS PaymentAdviceIsHeld,
  I_PaymentAdviceTP.PaymentAdviceStatus AS PaymentAdviceStatus,
  I_PaymentAdviceTP.UxFcPaymentAdviceAccount AS UxFcPaymentAdviceAccount,
  I_PaymentAdviceTP.PaymentAdviceIsExtracted AS PaymentAdviceIsExtracted,
  I_PaymentAdviceTP.PaytAdviceExtractorConfidence AS PaytAdviceExtractorConfidence,
  I_PaymentAdviceTP.PaytAdviceTotalNumberOfPages AS PaytAdviceTotalNumberOfPages,
  I_PaymentAdviceTP.PaymentAdviceExtractorUUID AS PaymentAdviceExtractorUUID,
  I_PaymentAdviceTP.PaymentAdviceUUID AS PaymentAdviceUUID,
  I_PaymentAdviceTP.PaymentAdviceExtractionStatus AS PaymentAdviceExtractionStatus,
  PaymentAdviceExtractorType,
  CompanyCodeName,
  PaymentAdviceItemTotalAmount,
  BankReference,
  BusinessPartnerName,
  _PaymentAdviceSubledger._Text[ 1:Language = $session.system_language ].PaymentAdviceSubledgerText AS PaymentAdviceSubledgerText,
  CAPaymentDocument,
  ContractAccount,
  CAPaymentAdvice,
  BusinessPartner,
  Supplier,
  I_PaymentAdviceTP._CompanyCode AS _CompanyCode,
  I_PaymentAdviceTP._CompanyCodeForEdit AS _CompanyCodeForEdit,
  I_PaymentAdviceTP._Currency AS _Currency,
  I_PaymentAdviceTP._Customer AS _Customer,
  I_PaymentAdviceTP._CustomerCompany AS _CustomerCompany,
  I_PaymentAdviceTP._Supplier AS _Supplier,
  I_PaymentAdviceTP._SupplierCompany AS _SupplierCompany,
  I_PaymentAdviceTP._CustomerForEdit AS _CustomerForEdit,
  I_PaymentAdviceTP._PaymentAdviceType AS _PaymentAdviceType,
  I_PaymentAdviceTP._PaytAdviceSelRules AS _PaytAdviceSelRules,
  I_PaymentAdviceTP._PaytAdvcDiffDeterminationRule AS _PaytAdvcDiffDeterminationRule,
  I_PaymentAdviceTP._UserContactCard AS _UserContactCard,
  I_PaymentAdviceTP._BusinessPartner AS _BusinessPartner
FROM I_PaymentAdviceTP
LEFT OUTER JOIN C_PaymentAdviceItem AS _PaymentAdviceItem ON CompanyCode = _PaymentAdviceItem.CompanyCode AND PaymentAdviceAccountType = _PaymentAdviceItem.PaymentAdviceAccountType AND PaymentAdviceAccount = _PaymentAdviceItem.PaymentAdviceAccount AND PaymentAdvice = _PaymentAdviceItem.PaymentAdvice  -- association [0..*]
LEFT OUTER JOIN I_PaymentAdviceUserVH AS _UserVH ON CompanyCode = _UserVH.CompanyCode AND PaymentAdviceAccountType = _UserVH.PaymentAdviceAccountType AND PaymentAdviceAccount = _UserVH.PaymentAdviceAccount AND PaymentAdvice = _UserVH.PaymentAdvice  -- association [1..1]
;