ACE_ACDOCA_MIG

DDL: ACE_ACDOCA_MIG SQL: ACEV_ACDOCAMIG Type: view

Get original source from ACDOCA

ACE_ACDOCA_MIG is a CDS View that provides data about "Get original source from ACDOCA" in SAP S/4HANA. It reads from 2 data sources (ACE_ACDOCA_MIG_CONCAT, ACE_ACDOCA_MIG_NO_CONCAT) and exposes 46 fields with key fields comp, bukrs, gjahr, objid, subid.

Data Sources (2)

SourceAliasJoin Type
ACE_ACDOCA_MIG_CONCAT concat union_all
ACE_ACDOCA_MIG_NO_CONCAT no_concat from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ACDOCAMIG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Get original source from ACDOCA view
AbapCatalog.preserveKey true view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY comp ACE_ACDOCA_MIG_NO_CONCAT acrobjtype Accrual Object Type
KEY bukrs ACE_ACDOCA_MIG_NO_CONCAT rbukrs Company Code
KEY gjahr ACE_ACDOCA_MIG_NO_CONCAT gjahr Settlement Year
KEY objid ACE_ACDOCA_MIG_NO_CONCAT objid Work Center
KEY subid ACE_ACDOCA_MIG_NO_CONCAT subid Topic ID
KEY acrtype ACE_ACDOCA_MIG_NO_CONCAT acrtype Accrual Type
KEY accrule ACE_ACDOCA_MIG_NO_CONCAT accrule Accounting Principle
pre_gjahr pre_gjahr
acrobj_id acrobj_id Accrual Object
acrsobj_id acrsobj_id Accrual Subobject
acritmtype acritmtype Accrual Item Type
slalittype slalittype SLALineItemType
valtbp valtbp Posted
currency 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)
KEY bukrs ACE_ACDOCA_MIG_CONCAT rbukrs Company Code
KEY gjahr ACE_ACDOCA_MIG_CONCAT gjahr Settlement Year
KEY objid ACE_ACDOCA_MIG_CONCAT objid Work Center
KEY subid ACE_ACDOCA_MIG_CONCAT subid Topic ID
KEY acrtype ACE_ACDOCA_MIG_CONCAT acrtype Accrual Type
KEY accrule ACE_ACDOCA_MIG_CONCAT accrule Accounting Principle
pre_gjahr pre_gjahr
acrobj_id acrobj_id Accrual Object
acrsobj_id acrsobj_id Accrual Subobject
acritmtype acritmtype Accrual Item Type
slalittype slalittype SLALineItemType
valtbp valtbp Posted
currency 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)
mig_source mig_source Migr. Source

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_ACDOCA_MIG.
-- 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_ACDOCAMIG

CREATE VIEW ACE_ACDOCA_MIG AS
SELECT
  no_concat.acrobjtype AS comp,
  no_concat.rbukrs AS bukrs,
  no_concat.gjahr AS gjahr,
  no_concat.objid AS objid,
  no_concat.subid AS subid,
  no_concat.acrtype AS acrtype,
  no_concat.accrule AS accrule,
  pre_gjahr,
  acrobj_id,
  acrsobj_id,
  acritmtype,
  slalittype,
  valtbp,
  currency,
  transtype,
  effdate,
  podate,
  poper,
  poyear,
  awtyp,
  awkey,
  awsys,
  timestamp,
  mig_source
FROM ACE_ACDOCA_MIG_NO_CONCAT AS no_concat
-- UNION ALL with additional select branch(es): ACE_ACDOCA_MIG_CONCAT
;