ACE_ACEPSOIT

DDL: ACE_ACEPSOIT SQL: ACEV_ACEPSOIT Type: view Package: ACE_MIG
18 Fields 1 Data Sources

Compatibility view for ACEPSOIT

ACE_ACEPSOIT is a CDS View that provides data about "Compatibility view for ACEPSOIT" in SAP S/4HANA. It reads from 1 data source (ACE_ACDOCA_MIG) and exposes 18 fields with key fields comp, bukrs, gjahr, objid, subid. Part of development package ACE_MIG.

Data Sources (1)

SourceAliasJoin Type
ACE_ACDOCA_MIG acdoca from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACEPSOIT 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 Compatibility view for ACEPSOIT view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY comp ACE_ACDOCA_MIG comp Legal competence
KEY bukrs ACE_ACDOCA_MIG bukrs Value
KEY gjahr ACE_ACDOCA_MIG gjahr Settlement Year
KEY objid ACE_ACDOCA_MIG objid Work Center
KEY subid ACE_ACDOCA_MIG subid Topic ID
KEY acrtype ACE_ACDOCA_MIG acrtype Accrual Type
KEY accrule accrule Accounting Principle
valtbp valtbp Posted
currency ACE_ACDOCA_MIG currency Valuation Crcy
transtype transtype ACE Transaction
effdate effdate Key Date for Accrls
podate podate Posting Date
poper poper Posting periods
poyear poyear FI Fiscal Year
awtyp awtyp Reference Document Type
awkey awkey RefKey GJE
awsys awsys Logical System
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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

CREATE VIEW ACE_ACEPSOIT AS
SELECT
  acdoca.comp AS comp,
  acdoca.bukrs AS bukrs,
  acdoca.gjahr AS gjahr,
  acdoca.objid AS objid,
  acdoca.subid AS subid,
  acdoca.acrtype AS acrtype,
  accrule,
  valtbp,
  acdoca.currency AS currency,
  transtype,
  effdate,
  podate,
  poper,
  poyear,
  awtyp,
  awkey,
  awsys,
  timestamp
FROM ACE_ACDOCA_MIG AS acdoca
;

Learn More