I_ACMLocation

DDL: I_ACMLOCATION SQL: IACMLOCATION Type: view BASIC
3 Fields 1 Data Sources

ACM Location details

I_ACMLocation is a Basic CDS View that provides data about "ACM Location details" in SAP S/4HANA. It reads from 1 data source (oijloc) and exposes 3 fields with key field ACMLocationID.

Data Sources (1)

SourceAliasJoin Type
oijloc oijloc from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMLOCATION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label ACM Location details view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ACMLocationID locid Single-Character Flag
ACMLocationName locnam Location name
ACMLocationType loctyp Location type

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 I_ACMLocation.
-- 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: IACMLOCATION

CREATE VIEW I_ACMLocation AS
SELECT
  locid AS ACMLocationID,
  locnam AS ACMLocationName,
  loctyp AS ACMLocationType
FROM oijloc
;

Learn More