P_AP_CLOSING

DDL: P_AP_CLOSING SQL: PFIAPCLS Type: view BASIC

P_AP_CLOSING is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (P_LDCMP, t001, P_APCOA) and exposes 3 fields with key fields rldnr, bukrs.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
P_LDCMP datasource1 from
t001 datasource2 left_outer
P_APCOA datasource3 left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFIAPCLS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY rldnr P_LDCMP rldnr
KEY bukrs P_LDCMP bukrs
ktopl t001 ktopl 
@AbapCatalog.sqlViewName: 'PFIAPCLS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE


define view P_AP_CLOSING 
  as select from    P_LDCMP as datasource1
    left outer join t001    as datasource2 on datasource1.bukrs = datasource2.bukrs
    left outer join P_APCOA as datasource3 on  datasource1.acc_principle = datasource3.acc_principle
                                           and datasource2.ktopl         = datasource3.ktopl
{

  key datasource1.rldnr         , //        as   Ledger,

  key datasource1.bukrs          ,  //      as   CompanyCode,

      datasource1.acc_principle   ,   //    as   AccountingPrinciple,

      functional_currency         ,  //     as   FunctionalCurrency,

      datasource2.ktopl           ,    //   as   ChartOfAccounts,

      datasource3.fsv_financials      //   as   GLAccountHierarchy

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_APCOA",
"P_LDCMP",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More