P_PaymentReceiptDocClass

DDL: P_PAYMENTRECEIPTDOCCLASS SQL: PPRDOCCLASS Type: view COMPOSITE Package: GLO_FIN_PAYMENT_RECEIPT

Get doc class description for accounting document

P_PaymentReceiptDocClass is a Composite CDS View that provides data about "Get doc class description for accounting document" in SAP S/4HANA. It reads from 1 data source (I_AccountingDocumentType) and exposes 3 fields with key field AccountingDocumentType. Part of development package GLO_FIN_PAYMENT_RECEIPT.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_AccountingDocumentType AccountingDocumentType from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPRDOCCLASS view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocumentType I_AccountingDocumentType AccountingDocumentType
ODNDocumentClassName ODNDocumentClassText ODNDocumentClassName
AccountingDocumentTypeName AccountingDocumentTypeText AccountingDocumentTypeName 
@AbapCatalog.sqlViewName: 'PPRDOCCLASS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.private: true
define view P_PaymentReceiptDocClass
  with parameters
    P_Language : sylangu

  as select from    I_AccountingDocumentType     as AccountingDocumentType
    left outer to one join I_AccountingDocumentTypeText as AccountingDocumentTypeText on  AccountingDocumentType.AccountingDocumentType = AccountingDocumentTypeText.AccountingDocumentType
                                                                               and AccountingDocumentTypeText.Language           = :P_Language
    left outer to one join I_DocTypeOfclDocClassAssgmt  as DocTypeOfclDocClassAssgmt  on  Country                                          = 'AR'
                                                                               and DocTypeOfclDocClassAssgmt.AccountingDocumentType = AccountingDocumentType.AccountingDocumentType
    left outer to one join   I_ODNDocumentClassText       as ODNDocumentClassText       on  CountryCode                           = 'AR'
                                                                               and ODNDocumentClassText.ODNDocumentClass = DocTypeOfclDocClassAssgmt.ODNDocumentClass
                                                                               and ODNDocumentClassText.Language         = :P_Language

{
  key AccountingDocumentType.AccountingDocumentType,
     ODNDocumentClassText.ODNDocumentClassName,
     AccountingDocumentTypeText.AccountingDocumentTypeName

}

Learn More