I_PaymentAdviceSubItemTP

DDL: I_PAYMENTADVICESUBITEMTP SQL: IPAYADVSUBITMTP Type: view TRANSACTIONAL
32 Fields 1 Data Sources 4 Associations

Payment Advice Subitem

I_PaymentAdviceSubItemTP is a Transactional CDS View that provides data about "Payment Advice Subitem" in SAP S/4HANA. It reads from 1 data source (P_PaymentAdviceSubItem) and exposes 32 fields with key fields CompanyCode, PaymentAdviceAccountType, PaymentAdviceAccount, PaymentAdvice, PaymentAdviceItem. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_PaymentAdviceSubItem P_PaymentAdviceSubItem from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_PaymentAdviceTP _PaymentAdvice $projection.CompanyCode = _PaymentAdvice.CompanyCode and $projection.PaymentAdviceAccountType = _PaymentAdvice.PaymentAdviceAccountType and $projection.PaymentAdviceAccount = _PaymentAdvice.PaymentAdviceAccount and $projection.PaymentAdvice = _PaymentAdvice.PaymentAdvice
[1..1] I_PaymentAdviceItemTP _PaymentAdviceItem $projection.CompanyCode = _PaymentAdviceItem.CompanyCode and $projection.PaymentAdviceAccountType = _PaymentAdviceItem.PaymentAdviceAccountType and $projection.PaymentAdviceAccount = _PaymentAdviceItem.PaymentAdviceAccount and $projection.PaymentAdvice = _PaymentAdviceItem.PaymentAdvice and $projection.PaymentAdviceItem = _PaymentAdviceItem.PaymentAdviceItem
[1..1] I_CompanyCode _CompanyCodeForEdit $projection.CompanyCodeForEdit = _CompanyCodeForEdit.CompanyCode
[1..1] I_Customer _CustomerForEdit $projection.PaymentAdviceAccountForEdit = _CustomerForEdit.Customer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPAYADVSUBITMTP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.writeDraftPersistence AVIR_DRAFT view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Payment Advice Subitem view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PaymentAdviceSubItem CompanyCode Receiver Company Code
KEY PaymentAdviceAccountType P_PaymentAdviceSubItem PaymentAdviceAccountType Account Type
KEY PaymentAdviceAccount P_PaymentAdviceSubItem PaymentAdviceAccount Account
KEY PaymentAdvice P_PaymentAdviceSubItem PaymentAdvice Payment Advice Number
KEY PaymentAdviceItem P_PaymentAdviceSubItem PaymentAdviceItem Payt Adv. Item
KEY PaymentAdviceSubItem P_PaymentAdviceSubItem PaymentAdviceSubItem
CompanyCodeForEdit P_PaymentAdviceSubItem CompanyCode Receiver Company Code
PaytAdviceAccountTypeForEdit P_PaymentAdviceSubItem PaymentAdviceAccountType Account Type
PaymentAdviceAccountForEdit P_PaymentAdviceSubItem PaymentAdviceAccount Account
PaymentAdviceForEdit P_PaymentAdviceSubItem PaymentAdvice Payment Advice Number
PaymentAdviceItemForEdit P_PaymentAdviceSubItem PaymentAdviceItem Payt Adv. Item
PaymentAdviceSubItemForEdit P_PaymentAdviceSubItem PaymentAdviceSubItem
NetDeductionAmountInPaytCrcy P_PaymentAdviceSubItem NetDeductionAmountInPaytCrcy
GrossDeductionAmountInPaytCrcy P_PaymentAdviceSubItem GrossDeductionAmountInPaytCrcy
PaymentDifferenceReason P_PaymentAdviceSubItem PaymentDifferenceReason Reason Code
PaymentDifferenceReasonName P_PaymentAdviceSubItem PaymentDifferenceReasonName
PaymentDifferenceReasonDesc P_PaymentAdviceSubItem PaymentDifferenceReasonDesc
Reference1IDByBusinessPartner P_PaymentAdviceSubItem Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner P_PaymentAdviceSubItem Reference2IDByBusinessPartner Reference Key 2
PaytDifferenceReasonExtCode P_PaymentAdviceSubItem PaytDifferenceReasonExtCode Ext.Reason Code
Currency P_PaymentAdviceSubItem Currency Valuation Crcy
_PaymentAdvice _PaymentAdvice
_PaymentAdviceItem _PaymentAdviceItem
_CompanyCodeForEdit _CompanyCodeForEdit
_CustomerForEdit _CustomerForEdit
_Currency P_PaymentAdviceSubItem _Currency
_Customer P_PaymentAdviceSubItem _Customer
_CustomerCompany P_PaymentAdviceSubItem _CustomerCompany
_CompanyCode P_PaymentAdviceSubItem _CompanyCode
_PaymentDifferenceReason P_PaymentAdviceSubItem _PaymentDifferenceReason
_Supplier P_PaymentAdviceSubItem _Supplier
_SupplierCompany P_PaymentAdviceSubItem _SupplierCompany

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_PaymentAdviceSubItemTP.
-- 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: IPAYADVSUBITMTP

CREATE VIEW I_PaymentAdviceSubItemTP AS
SELECT
  P_PaymentAdviceSubItem.CompanyCode AS CompanyCode,
  P_PaymentAdviceSubItem.PaymentAdviceAccountType AS PaymentAdviceAccountType,
  P_PaymentAdviceSubItem.PaymentAdviceAccount AS PaymentAdviceAccount,
  P_PaymentAdviceSubItem.PaymentAdvice AS PaymentAdvice,
  P_PaymentAdviceSubItem.PaymentAdviceItem AS PaymentAdviceItem,
  P_PaymentAdviceSubItem.PaymentAdviceSubItem AS PaymentAdviceSubItem,
  P_PaymentAdviceSubItem.CompanyCode AS CompanyCodeForEdit,
  P_PaymentAdviceSubItem.PaymentAdviceAccountType AS PaytAdviceAccountTypeForEdit,
  P_PaymentAdviceSubItem.PaymentAdviceAccount AS PaymentAdviceAccountForEdit,
  P_PaymentAdviceSubItem.PaymentAdvice AS PaymentAdviceForEdit,
  P_PaymentAdviceSubItem.PaymentAdviceItem AS PaymentAdviceItemForEdit,
  P_PaymentAdviceSubItem.PaymentAdviceSubItem AS PaymentAdviceSubItemForEdit,
  P_PaymentAdviceSubItem.NetDeductionAmountInPaytCrcy AS NetDeductionAmountInPaytCrcy,
  P_PaymentAdviceSubItem.GrossDeductionAmountInPaytCrcy AS GrossDeductionAmountInPaytCrcy,
  P_PaymentAdviceSubItem.PaymentDifferenceReason AS PaymentDifferenceReason,
  P_PaymentAdviceSubItem.PaymentDifferenceReasonName AS PaymentDifferenceReasonName,
  P_PaymentAdviceSubItem.PaymentDifferenceReasonDesc AS PaymentDifferenceReasonDesc,
  P_PaymentAdviceSubItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  P_PaymentAdviceSubItem.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  P_PaymentAdviceSubItem.PaytDifferenceReasonExtCode AS PaytDifferenceReasonExtCode,
  P_PaymentAdviceSubItem.Currency AS Currency,
  P_PaymentAdviceSubItem._Currency AS _Currency,
  P_PaymentAdviceSubItem._Customer AS _Customer,
  P_PaymentAdviceSubItem._CustomerCompany AS _CustomerCompany,
  P_PaymentAdviceSubItem._CompanyCode AS _CompanyCode,
  P_PaymentAdviceSubItem._PaymentDifferenceReason AS _PaymentDifferenceReason,
  P_PaymentAdviceSubItem._Supplier AS _Supplier,
  P_PaymentAdviceSubItem._SupplierCompany AS _SupplierCompany
FROM P_PaymentAdviceSubItem
LEFT OUTER JOIN I_PaymentAdviceTP AS _PaymentAdvice ON CompanyCode = _PaymentAdvice.CompanyCode AND PaymentAdviceAccountType = _PaymentAdvice.PaymentAdviceAccountType AND PaymentAdviceAccount = _PaymentAdvice.PaymentAdviceAccount AND PaymentAdvice = _PaymentAdvice.PaymentAdvice  -- association [1..1]
LEFT OUTER JOIN I_PaymentAdviceItemTP AS _PaymentAdviceItem ON CompanyCode = _PaymentAdviceItem.CompanyCode AND PaymentAdviceAccountType = _PaymentAdviceItem.PaymentAdviceAccountType AND PaymentAdviceAccount = _PaymentAdviceItem.PaymentAdviceAccount AND PaymentAdvice = _PaymentAdviceItem.PaymentAdvice AND PaymentAdviceItem = _PaymentAdviceItem.PaymentAdviceItem  -- association [1..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  -- association [1..1]
;

Learn More