ACE_ACEDSOH_STATUS_F_01

DDL: ACE_ACEDSOH_STATUS_F_01 SQL: ACEV_ACEDSOH_S_1 Type: view
12 Fields 2 Data Sources

Finilize status field in ACEDSOH table

ACE_ACEDSOH_STATUS_F_01 is a CDS View that provides data about "Finilize status field in ACEDSOH table" in SAP S/4HANA. It reads from 2 data sources (acedsoh, acepsoh) and exposes 12 fields with key fields comp, bukrs, objid, subid, date_to.

Data Sources (2)

SourceAliasJoin Type
acedsoh acedsoh from
acepsoh acepsoh inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEDSOH_S_1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Finilize status field in ACEDSOH table view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY comp acedsoh comp Legal competence
KEY bukrs acedsoh bukrs Value
KEY objid acedsoh objid Work Center
KEY subid acedsoh subid Topic ID
KEY date_to acedsoh date_to Validity End Date
date_from acedsoh date_from Validity Start Date
vality_from acedsoh vality_from Start of Life
vality_to acedsoh vality_to End of Life
ref_subkey acedsoh ref_subkey Ext Ref of Subobject
uname acedsoh uname User Name
cpudt acedsoh cpudt Imported On
cputm acedsoh cputm Time

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_ACEDSOH_STATUS_F_01.
-- 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_ACEDSOH_S_1

CREATE VIEW ACE_ACEDSOH_STATUS_F_01 AS
SELECT
  acedsoh.comp AS comp,
  acedsoh.bukrs AS bukrs,
  acedsoh.objid AS objid,
  acedsoh.subid AS subid,
  acedsoh.date_to AS date_to,
  acedsoh.date_from AS date_from,
  acedsoh.vality_from AS vality_from,
  acedsoh.vality_to AS vality_to,
  acedsoh.ref_subkey AS ref_subkey,
  acedsoh.uname AS uname,
  acedsoh.cpudt AS cpudt,
  acedsoh.cputm AS cputm
FROM acedsoh
INNER JOIN acepsoh ON /* join condition not captured in parsed metadata */
;

Learn More