I_PaytAdviceItemFromAssignment

DDL: I_PAYTADVICEITEMFROMASSIGNMENT SQL: IPAYTADVITEFASGN Type: view COMPOSITE
28 Fields 1 Data Sources 1 Associations

Payment advice items created from assignment

I_PaytAdviceItemFromAssignment is a Composite CDS View that provides data about "Payment advice items created from assignment" in SAP S/4HANA. It reads from 1 data source (I_PaymentAdviceItem) and exposes 28 fields with key fields CompanyCode, PaymentAdviceAccountType, PaymentAdviceAccount, PaymentAdvice, PaymentAdviceItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PaymentAdviceItem I_PaymentAdviceItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_OperationalAcctgDocItem _OperationalAcctgDocItem $projection.CompanyCode = _OperationalAcctgDocItem.CompanyCode and $projection.AccountingDocument = _OperationalAcctgDocItem.AccountingDocument and $projection.FiscalYear = _OperationalAcctgDocItem.FiscalYear and $projection.AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPAYTADVITEFASGN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Payment advice items created from assignment view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PaymentAdviceAccountType PaymentAdviceAccountType Account Type
KEY PaymentAdviceAccount PaymentAdviceAccount Account
KEY PaymentAdvice PaymentAdvice Payment Advice Number
KEY PaymentAdviceItem PaymentAdviceItem Payt Adv. Item
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
AccountingDocumentItem AccountingDocumentItem Posting View Item
AmountInTransactionCurrency
NetPaymentAmountInPaytCurrency NetPaymentAmountInPaytCurrency Payment Amount
Currency Currency Valuation Crcy
AlternativeCompanyCode AlternativeCompanyCode Alternative Company Code
PaymentAdviceAltvAccount PaymentAdviceAltvAccount Altern. Account
SpecialGLCode _OperationalAcctgDocItem SpecialGLCode Special G/L Ind
Customer _OperationalAcctgDocItem Customer Sold-to Party
CustomerName
AccountingDocumentType _OperationalAcctgDocItem AccountingDocumentType Journal Entry Type
PostingKey _OperationalAcctgDocItem PostingKey Posting Key
DocumentDate _OperationalAcctgDocItem DocumentDate Journal Entry Date
ClearingDate _OperationalAcctgDocItem ClearingDate Clearing Date
ClearingAccountingDocument _OperationalAcctgDocItem ClearingAccountingDocument Clearing Journal Entry
ClearingJournalEntry _OperationalAcctgDocItem ClearingJournalEntry Clrng doc.
AssignmentReference _OperationalAcctgDocItem AssignmentReference Assignment Reference
DocumentItemText _OperationalAcctgDocItem DocumentItemText Text
DebitCreditCode _OperationalAcctgDocItem DebitCreditCode Single-Character Flag
_OperationalAcctgDocItem _OperationalAcctgDocItem
_Customer _Customer
_Supplier _Supplier

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_PaytAdviceItemFromAssignment.
-- 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: IPAYTADVITEFASGN

CREATE VIEW I_PaytAdviceItemFromAssignment AS
SELECT
  CompanyCode,
  PaymentAdviceAccountType,
  PaymentAdviceAccount,
  PaymentAdvice,
  PaymentAdviceItem,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  cast(_OperationalAcctgDocItem.AmountInTransactionCurrency as farp_transaction_amount preserving type) AS AmountInTransactionCurrency,
  NetPaymentAmountInPaytCurrency,
  Currency,
  AlternativeCompanyCode,
  PaymentAdviceAltvAccount,
  _OperationalAcctgDocItem.SpecialGLCode AS SpecialGLCode,
  _OperationalAcctgDocItem.Customer AS Customer,
  _OperationalAcctgDocItem._Customer.CustomerName AS CustomerName,
  _OperationalAcctgDocItem.AccountingDocumentType AS AccountingDocumentType,
  _OperationalAcctgDocItem.PostingKey AS PostingKey,
  _OperationalAcctgDocItem.DocumentDate AS DocumentDate,
  _OperationalAcctgDocItem.ClearingDate AS ClearingDate,
  _OperationalAcctgDocItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  _OperationalAcctgDocItem.ClearingJournalEntry AS ClearingJournalEntry,
  _OperationalAcctgDocItem.AssignmentReference AS AssignmentReference,
  _OperationalAcctgDocItem.DocumentItemText AS DocumentItemText,
  _OperationalAcctgDocItem.DebitCreditCode AS DebitCreditCode
FROM I_PaymentAdviceItem
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
;

Learn More