P_Cosb

DDL: P_COSB SQL: pcosb Type: view BASIC
17 Fields 1 Data Sources

P_Cosb is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (cosb) and exposes 17 fields.

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 Ledger
ControllingObject cosb objnr Val. Obj. No.
ControllingValueType cosb wrttp Value Type
Version cosb versn Version
TransactionCurrency cosb twaer Trans. Currency
TransactionCurrency001 cosb wtg001 Value TranCurr
TransactionCurrency002 cosb wtg002 Value TranCurr
TransactionCurrency003 cosb wtg003 Value TranCurr
TransactionCurrency004 cosb wtg004 Value TranCurr
TransactionCurrency005 cosb wtg005 Value TranCurr
TransactionCurrency006 cosb wtg006 Value TranCurr
TransactionCurrency007 cosb wtg007 Value TranCurr
TransactionCurrency008 cosb wtg008 Value TranCurr
TransactionCurrency009 cosb wtg009 Value TranCurr
TransactionCurrency010 cosb wtg010 Value TranCurr
TransactionCurrency011 cosb wtg011 Value TranCurr
TransactionCurrency012 cosb wtg012 Value TranCurr

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_Cosb.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: pcosb

CREATE VIEW P_Cosb AS
SELECT
  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
FROM cosb
;

Learn More