P_Consacct

DDL: P_CONSACCT SQL: PCONSACCT Type: view BASIC
5 Fields 2 Data Sources

P_Consacct is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (ska1, t004) and exposes 5 fields.

Data Sources (2)

SourceAliasJoin Type
ska1 a from
t004 b inner

Annotations (3)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PCONSACCT view

Fields (5)

KeyFieldSource TableSource FieldDescription
mandt ska1 mandt Editing Client
ktopl ska1 ktopl G/L Chart of Accounts
saknr ska1 saknr G/L Account
kktpl t004 kktpl Group ChtAccts
bilkt ska1 bilkt Group Account Number

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_Consacct.
-- 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: PCONSACCT

CREATE VIEW P_Consacct AS
SELECT
  a.mandt AS mandt,
  a.ktopl AS ktopl,
  a.saknr AS saknr,
  b.kktpl AS kktpl,
  a.bilkt AS bilkt
FROM ska1 AS a
INNER JOIN t004 AS b ON /* join condition not captured in parsed metadata */
;

Learn More