SACMRT_ASPPFCG

DDL: SACMRT_ASPPFCG Type: view_entity
7 Fields 2 Data Sources

ACM RT: Buffered access to PFCG Aspects

SACMRT_ASPPFCG is a CDS View that provides data about "ACM RT: Buffered access to PFCG Aspects" in SAP S/4HANA. It reads from 2 data sources (acmaspectpfcg, formerly) and exposes 7 fields.

Data Sources (2)

SourceAliasJoin Type
acmaspectpfcg acmaspectpfcg from
formerly formerly inner

Annotations (3)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label ACM RT: Buffered access to PFCG Aspects view

Fields (7)

KeyFieldSource TableSource FieldDescription
auth_object acmaspectpfcg auth_object Object
detailpos acmasppfcgdetail pos Table position
auth_field acmasppfcgdetail auth_field Field Name
fix_value acmasppfcgdetail fix_value Value
mapping_id acmasppfcgdetail mapping_id Mapping ID
mapping_name acmpfcgmapping name Zone name
idasdummy0

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 SACMRT_ASPPFCG.
-- 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 SACMRT_ASPPFCG AS
SELECT
  acmaspectpfcg.auth_object AS auth_object,
  acmasppfcgdetail.pos AS detailpos,
  acmasppfcgdetail.auth_field AS auth_field,
  acmasppfcgdetail.fix_value AS fix_value,
  acmasppfcgdetail.mapping_id AS mapping_id,
  acmpfcgmapping.name AS mapping_name
FROM acmaspectpfcg
INNER JOIN formerly ON /* join condition not captured in parsed metadata */
;

Learn More