ACE_ACEDSOI_FILTER

DDL: ACE_ACEDSOI_FILTER SQL: ACEIFIL Type: view
15 Fields 1 Data Sources

Gather Data from ACEDSOI

ACE_ACEDSOI_FILTER is a CDS View that provides data about "Gather Data from ACEDSOI" in SAP S/4HANA. It reads from 1 data source (acedsoi) and exposes 15 fields with key fields comp, bukrs, objid, subid, acrtype.

Data Sources (1)

SourceAliasJoin Type
acedsoi acedsoi from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEIFIL 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 Gather Data from ACEDSOI view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY comp comp Legal competence
KEY bukrs bukrs Value
KEY objid objid Work Center
KEY subid subid Topic ID
KEY acrtype acrtype Accrual Type
KEY accrule accrule Accounting Principle
KEY date_to
date_from
timestmp timestmp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
amount amount Value Amount
currency currency Valuation Crcy
quantity quantity Value
unit unit UoM
acrmethod acrmethod Accr/Defrl Method
xobsolete xobsolete 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 ACE_ACEDSOI_FILTER.
-- 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: ACEIFIL

CREATE VIEW ACE_ACEDSOI_FILTER AS
SELECT
  comp,
  bukrs,
  objid,
  subid,
  acrtype,
  accrule,
  max(date_to) AS date_to,
  min(date_from) AS date_from,
  timestmp,
  amount,
  currency,
  quantity,
  unit,
  acrmethod,
  xobsolete
FROM acedsoi
;

Learn More