P_Trrsobaseplan

DDL: P_TRRSOBASEPLAN SQL: PTRRSOBASEPLAN Type: view COMPOSITE

P_Trrsobaseplan is a Composite CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 5 fields with key fields vbeln, posnr, rldnr.

6 data source(s) 5 fields

Data Sources (6)

SourceAliasJoin Type
acdocp acdocp left_outer
fins_trr_acp acp inner
cskb cskb left_outer
P_Trrmonaccprin cust inner
vbap vbap from
Kkag_Werk_Bukrs_Kokrs werk inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PTRRSOBASEPLAN view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY vbeln vbap vbeln
KEY posnr vbap posnr
KEY rldnr P_Trrmonaccprin rldnr
PlannedCosAmtInCCCrcy
PlannedRevenueAmtInCCCrcy 
@AbapCatalog.sqlViewName: 'PTRRSOBASEPLAN'
//@ClientDependent: true

@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_Trrsobaseplan
  as

  select from       vbap                  as vbap

    inner join      Kkag_Werk_Bukrs_Kokrs as werk   on werk.werks = vbap.werks

    inner join      P_Trrmonaccprin       as cust   on  cust.abgsl = vbap.abgrs
                                                    and cust.bukrs = werk.bukrs

    inner join      fins_trr_acp          as acp    on  acp.bukrs         = werk.bukrs
                                                    and acp.acc_principle = cust.acc_principle

    left outer join acdocp                as acdocp on  acdocp.kdauf    = vbap.vbeln
                                                    and acdocp.kdpos    = vbap.posnr
                                                    and acdocp.rldnr    = cust.rldnr
                                                    and acdocp.category = acp.plan_category

    left outer join cskb                  as cskb   on  cskb.kokrs = acdocp.kokrs
                                                    and cskb.kstar = acdocp.racct
                                                    and cskb.datab <= $session.system_date
                                                    and cskb.datbi > $session.system_date
{
  key vbap.vbeln,
  key vbap.posnr,
  key cust.rldnr,
      sum( case when cskb.katyp <> '11' and cskb.katyp <> '12' then acdocp.hsl else 0 end )  as PlannedCosAmtInCCCrcy,
      sum( case when cskb.katyp = '11' or cskb.katyp = '12' then -1 * acdocp.hsl else 0 end) as PlannedRevenueAmtInCCCrcy
}

group by
  vbap.vbeln,
  vbap.posnr,
  cust.rldnr
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KKAG_WERK_BUKRS_KOKRS",
"P_TRRMONACCPRIN",
"ACDOCP",
"CSKB",
"FINS_TRR_ACP",
"VBAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More