P_RTPC_REM_ACTLCOST_FOR_STTLLD

DDL: P_RTPC_REM_ACTLCOST_FOR_STTLLD SQL: PFIRTPCREMACTSLD Type: view BASIC Package: FINS_PCC_RTPC_REM

REM Order Actual Cost For Settlement with Parallel Ledgers

P_RTPC_REM_ACTLCOST_FOR_STTLLD is a Basic CDS View that provides data about "REM Order Actual Cost For Settlement with Parallel Ledgers" in SAP S/4HANA. It reads from 1 data source (acdoca) and exposes 13 fields. Part of development package FINS_PCC_RTPC_REM.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
acdoca acdoca from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFIRTPCREMACTSLD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
lednr rldnr
objnr objnr
gjahr ryear
rbukrs rbukrs
fiscyearper fiscyearper
beknz co_beknz
bttype bttype
awtyp awtyp
awref awref
awitem awitem
aworg aworg
awsys awsys
subta subta 
@AbapCatalog.sqlViewName: 'PFIRTPCREMACTSLD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label      : 'REM Order Actual Cost For Settlement with Parallel Ledgers'

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@VDM.private:true
define view P_RTPC_REM_ACTLCOST_FOR_STTLLD
  as select from           acdoca           
{

  rldnr  as lednr,
  objnr,
  ryear  as gjahr,
  rbukrs,
  fiscyearper,
  co_beknz  as beknz,
  bttype,
  awtyp,
  awref,
  awitem,
  aworg,
  awsys,
  subta 
 }

where
  ( accasty  =  'OR' or accasty  =  'OP' )
  and  autyp    =  '05'
  and  xsettled =  ''
  and  bttype   <> 'TBCS' --ignore Transaction-Based Split
  and  bttype   <> 'EBVP' --ignore variance postings after migration
  and  bttype   <> 'EBWP' --ignore WIP postings after migration
  and  bttype   <> 'KOAE' --ignore wip & variance posting
  and  co_beknz <> 'A'    //exclude settlement line items

  and  objnr    <> ''

Learn More