P_T011

DDL: P_T011 SQL: PT011 Type: view BASIC
14 Fields 1 Data Sources

P_T011 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (t011) and exposes 14 fields with key field versn.

Data Sources (1)

SourceAliasJoin Type
t011 t011 from

Annotations (5)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PT011 view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY versn t011 versn Version
dspra t011 dspra Maint. Language
aspra t011 aspra Altern.Language
xergs t011 xergs Group Account Number
ktopl t011 ktopl G/L Chart of Accounts
aktva t011 aktva Assets
pssva t011 pssva Liabilities
ergak t011 ergak Net Loss
ergpa t011 ergpa Net Profit/Year
erggv t011 erggv P+L Profit
zuord t011 zuord Not Assignable
xauto t011 xauto Auto. Item Keys
xfber t011 xfber Fun.Area Perm.
anhng t011 anhng Fin.Stmt Notes

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_T011.
-- 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: PT011

CREATE VIEW P_T011 AS
SELECT
  t011.versn AS versn,
  t011.dspra AS dspra,
  t011.aspra AS aspra,
  t011.xergs AS xergs,
  t011.ktopl AS ktopl,
  t011.aktva AS aktva,
  t011.pssva AS pssva,
  t011.ergak AS ergak,
  t011.ergpa AS ergpa,
  t011.erggv AS erggv,
  t011.zuord AS zuord,
  t011.xauto AS xauto,
  t011.xfber AS xfber,
  t011.anhng AS anhng
FROM t011
;

Learn More