ACE_ACESOBJ_PARAM

DDL: ACE_ACESOBJ_PARAM SQL: ACEV_SOBJ_PARAM Type: view
9 Fields 3 Data Sources

View From ACEOBJ ACEPSOH ACEDSOP

ACE_ACESOBJ_PARAM is a CDS View that provides data about "View From ACEOBJ ACEPSOH ACEDSOP" in SAP S/4HANA. It reads from 3 data sources (acedsop, aceobj, acepsoh) and exposes 9 fields with key fields comp, bukrs, ref_key, ref_subkey, param_name.

Data Sources (3)

SourceAliasJoin Type
acedsop acedsop from
aceobj aceobj inner
acepsoh acepsoh inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_SOBJ_PARAM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label View From ACEOBJ ACEPSOH ACEDSOP view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY comp acedsop comp Legal competence
KEY bukrs acedsop bukrs Value
KEY ref_key aceobj ref_key Source Reference Key
KEY ref_subkey acepsoh ref_subkey Ext Ref of Subobject
KEY param_name acedsop param_name Parameter Name
KEY date_to acedsop date_to Validity End Date
date_from acedsop date_from Validity Start Date
content acedsop content Trusted Site Content
content_xml acedsop content_xml Parameter Value

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 ACE_ACESOBJ_PARAM.
-- 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: ACEV_SOBJ_PARAM

CREATE VIEW ACE_ACESOBJ_PARAM AS
SELECT
  acedsop.comp AS comp,
  acedsop.bukrs AS bukrs,
  aceobj.ref_key AS ref_key,
  acepsoh.ref_subkey AS ref_subkey,
  acedsop.param_name AS param_name,
  acedsop.date_to AS date_to,
  acedsop.date_from AS date_from,
  acedsop.content AS content,
  acedsop.content_xml AS content_xml
FROM acedsop
INNER JOIN aceobj ON /* join condition not captured in parsed metadata */
INNER JOIN acepsoh ON /* join condition not captured in parsed metadata */
;

Learn More