P_VCC_TEXTS

DDL: P_VCC_TEXTS SQL: P_SQL_VCC_TEXTS Type: view Package: SUSR_IS

Texts for Variante for CC

P_VCC_TEXTS is a CDS View that provides data about "Texts for Variante for CC" in SAP S/4HANA. It reads from 5 data sources (uscrauidt, uscrauth, uscrcomid, usrcombt, usrvarcomt) and exposes 6 fields with key field vcc. Part of development package SUSR_IS.

Data Sources (5)

SourceAliasJoin Type
uscrauidt uscrauidt inner
uscrauth uscrauth inner
uscrcomid uscrcomid inner
usrcombt usrcombt inner
usrvarcomt usrvarcomt inner

Parameters (1)

NameTypeDefault
VCC_ID comb_id

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_SQL_VCC_TEXTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Texts for Variante for CC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY vcc usrcrcomb varname Variant
vtext usrvarcomt vtext Wgh.Dat.Ty.Txt.
cc usrcombt comb_id CombTypeNo.
ctext usrcombt ctext Text
ca uscrauidt auth_id Authorization ID
text uscrauidt text User Group

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_VCC_TEXTS.
-- 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: P_SQL_VCC_TEXTS
-- Parameters: VCC_ID : comb_id

CREATE VIEW P_VCC_TEXTS AS
SELECT
  usrcrcomb.varname AS vcc,
  usrvarcomt.vtext AS vtext,
  usrcombt.comb_id AS cc,
  usrcombt.ctext AS ctext,
  uscrauidt.auth_id AS ca,
  uscrauidt.text AS text
INNER JOIN usrvarcomt ON /* join condition not captured in parsed metadata */
INNER JOIN uscrcomid ON /* join condition not captured in parsed metadata */
INNER JOIN usrcombt ON /* join condition not captured in parsed metadata */
INNER JOIN uscrauth ON /* join condition not captured in parsed metadata */
INNER JOIN uscrauidt ON /* join condition not captured in parsed metadata */
;