ACE_ACDOCA_MIG_CONCAT

DDL: ACE_ACDOCA_MIG_CONCAT SQL: ACEV_MIG_CON Type: view
24 Fields 1 Data Sources

Get original source from ACDOCA

ACE_ACDOCA_MIG_CONCAT is a CDS View that provides data about "Get original source from ACDOCA" in SAP S/4HANA. It reads from 1 data source (ACE_ACDOCA_MIG_ACRTYPE_RULE) and exposes 24 fields with key fields acrobjtype, rbukrs, gjahr, objid, subid.

Data Sources (1)

SourceAliasJoin Type
ACE_ACDOCA_MIG_ACRTYPE_RULE acdoca from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_MIG_CON 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 (24)

KeyFieldSource TableSource FieldDescription
KEY acrobjtype ACE_ACDOCA_MIG_ACRTYPE_RULE acrobjtype Accrual Object Type
KEY rbukrs ACE_ACDOCA_MIG_ACRTYPE_RULE rbukrs Company Code
KEY gjahr ACE_ACDOCA_MIG_ACRTYPE_RULE gjahr Settlement Year
KEY objid ACE_ACDOCA_MIG_ACRTYPE_RULE objid Work Center
KEY subid ACE_ACDOCA_MIG_ACRTYPE_RULE subid Topic ID
KEY acrtype ACE_ACDOCA_MIG_ACRTYPE_RULE acrtype Accrual Type
KEY accrule ACE_ACDOCA_MIG_ACRTYPE_RULE accrule Accounting Principle
acritmtype ACE_ACDOCA_MIG_ACRTYPE_RULE acritmtype Accrual Item Type
acrobj_id ACE_ACDOCA_MIG_ACRTYPE_RULE acrobj_id Accrual Object
acrsobj_id ACE_ACDOCA_MIG_ACRTYPE_RULE acrsobj_id Accrual Subobject
pre_gjahr ACE_ACDOCA_MIG_ACRTYPE_RULE pre_gjahr
slalittype ACE_ACDOCA_MIG_ACRTYPE_RULE slalittype SLALineItemType
valtbp ACE_ACDOCA_MIG_ACRTYPE_RULE valtbp Posted
currency ACE_ACDOCA_MIG_ACRTYPE_RULE currency Valuation Crcy
transtype ACE_ACDOCA_MIG_ACRTYPE_RULE transtype ACE Transaction
effdate ACE_ACDOCA_MIG_ACRTYPE_RULE effdate Key Date for Accrls
podate ACE_ACDOCA_MIG_ACRTYPE_RULE podate Posting Date
poper ACE_ACDOCA_MIG_ACRTYPE_RULE poper Posting periods
poyear ACE_ACDOCA_MIG_ACRTYPE_RULE poyear FI Fiscal Year
awtyp ACE_ACDOCA_MIG_ACRTYPE_RULE awtyp Reference Document Type
awkey ACE_ACDOCA_MIG_ACRTYPE_RULE awkey RefKey GJE
awsys ACE_ACDOCA_MIG_ACRTYPE_RULE awsys Logical System
timestamp ACE_ACDOCA_MIG_ACRTYPE_RULE timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
mig_source ACE_ACDOCA_MIG_ACRTYPE_RULE 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_CONCAT.
-- 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_MIG_CON

CREATE VIEW ACE_ACDOCA_MIG_CONCAT AS
SELECT
  acdoca.acrobjtype AS acrobjtype,
  acdoca.rbukrs AS rbukrs,
  acdoca.gjahr AS gjahr,
  acdoca.objid AS objid,
  acdoca.subid AS subid,
  acdoca.acrtype AS acrtype,
  acdoca.accrule AS accrule,
  acdoca.acritmtype AS acritmtype,
  acdoca.acrobj_id AS acrobj_id,
  acdoca.acrsobj_id AS acrsobj_id,
  acdoca.pre_gjahr AS pre_gjahr,
  acdoca.slalittype AS slalittype,
  acdoca.valtbp AS valtbp,
  acdoca.currency AS currency,
  acdoca.transtype AS transtype,
  acdoca.effdate AS effdate,
  acdoca.podate AS podate,
  acdoca.poper AS poper,
  acdoca.poyear AS poyear,
  acdoca.awtyp AS awtyp,
  acdoca.awkey AS awkey,
  acdoca.awsys AS awsys,
  acdoca.timestamp AS timestamp,
  acdoca.mig_source AS mig_source
FROM ACE_ACDOCA_MIG_ACRTYPE_RULE AS acdoca
;

Learn More