ACE_ITEMTYPEL

DDL: ACE_ITEMTYPEL SQL: ACEV_ITMTYPEL Type: view
6 Fields 1 Data Sources

Basic Item Type

ACE_ITEMTYPEL is a CDS View that provides data about "Basic Item Type" in SAP S/4HANA. It reads from 1 data source (tace_itemtypel) and exposes 6 fields with key fields comp, bukrs, itemtype, ldgrp.

Data Sources (1)

SourceAliasJoin Type
tace_itemtypel tace_itemtypel from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ACEV_ITMTYPEL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Basic Item Type view
AbapCatalog.preserveKey true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY comp comp Legal competence
KEY bukrs bukrs Value
KEY itemtype itemtype Object Type
KEY ldgrp ldgrp Target Ledger Group
acrtype acrtype Accrual Type
xinactive xinactive Inactive

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_ITEMTYPEL.
-- 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_ITMTYPEL

CREATE VIEW ACE_ITEMTYPEL AS
SELECT
  comp,
  bukrs,
  itemtype,
  ldgrp,
  acrtype,
  xinactive
FROM tace_itemtypel
;

Learn More