P_APCshDiscUtilization5

DDL: P_APCSHDISCUTILIZATION5 SQL: PFIAPCSHDISUTI5 Type: view COMPOSITE Package: FINS_FIS_AP_APPS

Account Payable Cash Discount Utilization

P_APCshDiscUtilization5 is a Composite CDS View that provides data about "Account Payable Cash Discount Utilization" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocument, I_ChangeDocumentItem) and exposes 10 fields with key fields objectclas, objectid, changenr, tabname, tabkey. Part of development package FINS_FIS_AP_APPS.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocument cdhdr from
I_ChangeDocumentItem cdpos inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFIAPCSHDISUTI5 view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY objectclas I_ChangeDocument ChangeDocObjectClass
KEY objectid I_ChangeDocument ChangeDocObject
KEY changenr I_ChangeDocument ChangeDocument
KEY tabname I_ChangeDocumentItem DatabaseTable
KEY tabkey I_ChangeDocumentItem ChangeDocTableKey
KEY fname I_ChangeDocumentItem ChangeDocDatabaseTableField
KEY chngind I_ChangeDocumentItem ChangeDocItemChangeType
udate I_ChangeDocument CreationDate
value_new I_ChangeDocumentItem ChangeDocNewFieldValue
value_old I_ChangeDocumentItem ChangeDocPreviousFieldValue 
@AbapCatalog.sqlViewName: 'PFIAPCSHDISUTI5'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view P_APCshDiscUtilization5
as select from
I_ChangeDocument as cdhdr
inner join
I_ChangeDocumentItem as cdpos
on 
    cdhdr.ChangeDocObjectClass = cdpos.ChangeDocObjectClass
    and cdhdr.ChangeDocObject = cdpos.ChangeDocObject
    and cdhdr.ChangeDocument = cdpos.ChangeDocument
{
    //key cdhdr.mandant,

    key cdhdr.ChangeDocObjectClass as objectclas,
    key cdhdr.ChangeDocObject as objectid,
    key cdhdr.ChangeDocument as changenr,
    key cdpos.DatabaseTable as tabname,
    key cdpos.ChangeDocTableKey as tabkey,
    key cdpos.ChangeDocDatabaseTableField as fname,
    key cdpos.ChangeDocItemChangeType as chngind,
    cdhdr.CreationDate as udate,
    cdpos.ChangeDocNewFieldValue as value_new,
    cdpos.ChangeDocPreviousFieldValue as value_old
}
where 
    cdhdr.ChangeDocObjectClass = 'BELEG' and cdpos.ChangeDocObjectClass = 'BELEG'
    and cdpos.DatabaseTable = 'BSEG'
    and cdpos.ChangeDocDatabaseTableField = 'ZLSPR'
    and cdpos.ChangeDocNewFieldValue != '';

Learn More