I_StorageLocationAddress

DDL: I_STORAGELOCATIONADDRESS SQL: IMM_STORLOCADDR Type: view BASIC Package: VDM_MM_GF
8 Fields 1 Data Sources 4 Associations

Assigned addresses of storage locations

I_StorageLocationAddress (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Database & Data Management

I_StorageLocationAddress is a Basic CDS View that provides data about "Assigned addresses of storage locations" in SAP S/4HANA. It reads from 1 data source (twlad) and exposes 8 fields with key fields Plant, StorageLocation, StorLocAddressSequenceNumber. It has 4 associations to related views. Part of development package VDM_MM_GF.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentMM
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
twlad twlad from

Associations (4)

CardinalityTargetAliasCondition
[1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1] I_StorageLocation _StorageLocation $projection.StorageLocation = _StorageLocation.StorageLocation and $projection.Plant = _StorageLocation.Plant
[1] I_Address _Address $projection.AddressID = _Address.AddressID
[1] I_OrganizationAddress _Address_2 $projection.AddressID = _Address_2.AddressID and _Address_2.AddressPersonID = '' and _Address_2.AddressRepresentationCode = ''

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMM_STORLOCADDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Assigned addresses of storage locations view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey StorLocAddressSequenceNumber view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Plant werks Receiving Plant
KEY StorageLocation lgort Storage Location
KEY StorLocAddressSequenceNumber lfdnr Sequential address number
AddressID adrnr Sold-To Address
_Plant _Plant
_StorageLocation _StorageLocation
_Address _Address
_Address_2 _Address_2

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_StorageLocationAddress.
-- 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: IMM_STORLOCADDR

CREATE VIEW I_StorageLocationAddress AS
SELECT
  werks AS Plant,
  lgort AS StorageLocation,
  lfdnr AS StorLocAddressSequenceNumber,
  adrnr AS AddressID
FROM twlad
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [1]
LEFT OUTER JOIN I_OrganizationAddress AS _Address_2 ON AddressID = _Address_2.AddressID AND _Address_2.AddressPersonID = '' AND _Address_2.AddressRepresentationCode = ''  -- association [1]
;

Learn More