P_KNAS_GLO

DDL: P_KNAS_GLO SQL: PKNASGLO Type: view COMPOSITE
3 Fields 1 Data Sources

P_KNAS_GLO is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (knas) and exposes 3 fields with key fields kunnr, land1.

Data Sources (1)

SourceAliasJoin Type
knas knas from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PKNASGLO view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY kunnr knas kunnr Stock customer
KEY land1 knas land1 Trip Ctry/Reg
stceg knas stceg VAT Reg. No.

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_KNAS_GLO.
-- 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: PKNASGLO

CREATE VIEW P_KNAS_GLO AS
SELECT
  knas.kunnr AS kunnr,
  knas.land1 AS land1,
  knas.stceg AS stceg
FROM knas
;

Learn More