satc_ci_approvr_area_respbilty

DDL: SATC_CI_APPROVR_AREA_RESPBILTY Type: view_entity
2 Fields 4 Data Sources

Approver Area Responsibility

satc_ci_approvr_area_respbilty is a CDS View that provides data about "Approver Area Responsibility" in SAP S/4HANA. It reads from 4 data sources (df14l, satc_ci_exempt, tadir, tdevc) and exposes 2 fields with key field exemption_id.

Data Sources (4)

SourceAliasJoin Type
df14l df14l left_outer
satc_ci_exempt exemp from
tadir tadir left_outer
tdevc tdevc left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Approver Area Responsibility view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY exemption_id satc_ci_exempt exemption_id Exemption ID
package_name tadir devclass Package (Obsolete)

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 satc_ci_approvr_area_respbilty.
-- 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.

CREATE VIEW satc_ci_approvr_area_respbilty AS
SELECT
  exemp.exemption_id AS exemption_id,
  tadir.devclass AS package_name
FROM satc_ci_exempt AS exemp
LEFT OUTER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l ON /* join condition not captured in parsed metadata */
;

Learn More