P_AUDIT_AT_SKA1

DDL: P_AUDIT_AT_SKA1 SQL: PAUDITATSKA1 Type: view BASIC
10 Fields 2 Data Sources

P_AUDIT_AT_SKA1 is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (ska1, skat) and exposes 10 fields with key fields bukrs, ktopl.

Data Sources (2)

SourceAliasJoin Type
ska1 ska1 from
skat skat left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PAUDITATSKA1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MASTER view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY bukrs skb1 bukrs Value
KEY ktopl ska1 ktopl G/L Chart of Accounts
saknr ska1 saknr G/L Account
xbilk ska1 xbilk Checkbox
sakan ska1 sakan G/L Account
bilkt ska1 bilkt Group Account Number
gvtyp ska1 gvtyp P&L state. acct
mcod1 ska1 mcod1 Search Term
ktext skat txt20 Text 20
ltext skat txt50 Status Name

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_AUDIT_AT_SKA1.
-- 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: PAUDITATSKA1

CREATE VIEW P_AUDIT_AT_SKA1 AS
SELECT
  skb1.bukrs AS bukrs,
  ska1.ktopl AS ktopl,
  ska1.saknr AS saknr,
  ska1.xbilk AS xbilk,
  ska1.sakan AS sakan,
  ska1.bilkt AS bilkt,
  ska1.gvtyp AS gvtyp,
  ska1.mcod1 AS mcod1,
  skat.txt20 AS ktext,
  skat.txt50 AS ltext
FROM ska1
LEFT OUTER JOIN skat ON /* join condition not captured in parsed metadata */
;

Learn More