FEE_CDS_ST

DDL: FEE_CDS_ST SQL: STUDENT_INFO Type: view
31 Fields 10 Data Sources

FEE_CDS_ST is a CDS View in SAP S/4HANA. It reads from 10 data sources and exposes 31 fields with key fields CLIENT, PARTNER, STOBJID, STNUMBER, OPBUK.

Data Sources (10)

SourceAliasJoin Type
cmacbpst A from
fkkvkp B left_outer
t001 C left_outer
hrp1702 D left_outer
tfk033d E left_outer
hrp1706 f left_outer
hrp1712 g left_outer
hrp1001 h left_outer
hrp1705 i left_outer
hrp1001 j left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName STUDENT_INFO view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CLIENT cmacbpst client Workflow definition: Client
KEY PARTNER cmacbpst partner With Partner
KEY STOBJID cmacbpst stobjid Student ID
KEY STNUMBER cmacbpst student12 Student Number
KEY OPBUK fkkvkp opbuk Paying Co. Code
KEY BUKRS fkkvkp stdbk Standard CoCode
KEY WAERS t001 waers Transaction Currency
KEY PLVAR hrp1702 plvar Plan version
KEY NATIO hrp1702 natio Nationality
KEY begda_1702 hrp1702 begda Valid From
KEY endda_1702 hrp1702 endda Valid To
KEY begda_1706 hrp1706 begda Valid From
KEY endda_1706 hrp1706 endda Valid To
KEY begda_1712 hrp1712 begda Valid From
KEY endda_1712 hrp1712 endda Valid To
KEY begda_1705 hrp1705 begda Valid From
KEY endda_1705 hrp1705 endda Valid To
KEY FUN01 tfk033d fun01 Function
KEY STFEECAT hrp1706 stfeecat Fee Category
KEY BENCAT hrp1706 bencat Benefit Cat.
KEY PDISCT1 hrp1706 pdisct1 Disc./Sur. 1
KEY PDISCT2 hrp1706 pdisct2 Disc./Sur. 2
KEY PDISCT3 hrp1706 pdisct3 Disc./Sur. 3
KEY PDISCT4 hrp1706 pdisct4 Disc./Sur. 4
KEY PDISCT5 hrp1706 pdisct5 Disc./Sur. 5
KEY PDISCT6 hrp1706 pdisct6 Disc./Sur. 6
KEY VISATYPE hrp1712 visatype Visa Type
KEY f_objid hrp1001 sobid ID rel.object
KEY STGRP hrp1705 stgrp Tax Type
KEY PREVHE hrp1705 prevhe Reserved field/unused field of length 1
KEY o_objid hrp1001 sobid ID rel.object

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 FEE_CDS_ST.
-- 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: STUDENT_INFO

CREATE VIEW FEE_CDS_ST AS
SELECT
  A.client AS CLIENT,
  A.partner AS PARTNER,
  A.stobjid AS STOBJID,
  A.student12 AS STNUMBER,
  B.opbuk AS OPBUK,
  B.stdbk AS BUKRS,
  C.waers AS WAERS,
  D.plvar AS PLVAR,
  D.natio AS NATIO,
  D.begda AS begda_1702,
  D.endda AS endda_1702,
  f.begda AS begda_1706,
  f.endda AS endda_1706,
  g.begda AS begda_1712,
  g.endda AS endda_1712,
  i.begda AS begda_1705,
  i.endda AS endda_1705,
  E.fun01 AS FUN01,
  f.stfeecat AS STFEECAT,
  f.bencat AS BENCAT,
  f.pdisct1 AS PDISCT1,
  f.pdisct2 AS PDISCT2,
  f.pdisct3 AS PDISCT3,
  f.pdisct4 AS PDISCT4,
  f.pdisct5 AS PDISCT5,
  f.pdisct6 AS PDISCT6,
  g.visatype AS VISATYPE,
  h.sobid AS f_objid,
  i.stgrp AS STGRP,
  i.prevhe AS PREVHE,
  j.sobid AS o_objid
FROM cmacbpst AS A
LEFT OUTER JOIN fkkvkp AS B ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001 AS C ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1702 AS D ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tfk033d AS E ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1706 AS f ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1712 AS g ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1001 AS h ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1705 AS i ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1001 AS j ON /* join condition not captured in parsed metadata */
;

Learn More