P_Cosb

DDL: P_COSB SQL: pcosb Type: view BASIC Package: VDM_CPM_WS

CO Object: Total Variances/Results Analysis

P_Cosb is a Basic CDS View that provides data about "CO Object: Total Variances/Results Analysis" in SAP S/4HANA. It reads from 1 data source (cosb) and exposes 17 fields. Part of development package VDM_CPM_WS.

Data Sources (1)

SourceAliasJoin Type
cosb cosb from

Annotations (6)

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

Fields (17)

KeyFieldSource TableSource FieldDescription
Ledger cosb lednr
ControllingObject cosb objnr
ControllingValueType cosb wrttp
Version cosb versn
TransactionCurrency cosb twaer
TransactionCurrency001 cosb wtg001
TransactionCurrency002 cosb wtg002
TransactionCurrency003 cosb wtg003
TransactionCurrency004 cosb wtg004
TransactionCurrency005 cosb wtg005
TransactionCurrency006 cosb wtg006
TransactionCurrency007 cosb wtg007
TransactionCurrency008 cosb wtg008
TransactionCurrency009 cosb wtg009
TransactionCurrency010 cosb wtg010
TransactionCurrency011 cosb wtg011
TransactionCurrency012 cosb wtg012
@AbapCatalog.sqlViewName: 'pcosb'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC

define view P_Cosb as select from cosb {
  cosb.lednr  as Ledger, 
  cosb.objnr  as ControllingObject, 
  cosb.wrttp  as ControllingValueType, 
  cosb.versn  as Version, 
  cosb.twaer  as TransactionCurrency, 
  cosb.wtg001 as TransactionCurrency001, 
  cosb.wtg002 as TransactionCurrency002, 
  cosb.wtg003 as TransactionCurrency003, 
  cosb.wtg004 as TransactionCurrency004, 
  cosb.wtg005 as TransactionCurrency005, 
  cosb.wtg006 as TransactionCurrency006, 
  cosb.wtg007 as TransactionCurrency007, 
  cosb.wtg008 as TransactionCurrency008, 
  cosb.wtg009 as TransactionCurrency009, 
  cosb.wtg010 as TransactionCurrency010, 
  cosb.wtg011 as TransactionCurrency011, 
  cosb.wtg012 as TransactionCurrency012
}