I_STORAGELOCATION

CDS View

Storage Location

I_STORAGELOCATION is a CDS View in S/4HANA. Storage Location. It contains 8 fields. 22 CDS views read from this table.

Used by 22 CDS view(s) 8 fields

CDS Views using this table (22)

ViewTypeJoinVDMDescription
A_DigitalVehicleStorageLoc view_entity from CONSUMPTION Digital Vehicle Storage Location
A_StorageLocation view from COMPOSITE Storage Location
C_CSPRStorageLocation view from CONSUMPTION Count Products with RFID: Storage Locatn
C_MassUpdtStorLocVH view from CONSUMPTION Storage Location Value Help
C_MM_StorLocValueHelp view from CONSUMPTION Storage Location Value Help
C_MSPRStorageLocation view from CONSUMPTION
C_MSPWStorageLocation view from CONSUMPTION
C_ProcmtHubStorageLocationVH view from CONSUMPTION C-View for Storage Location Value Help in Central Contracts
C_ProdStorageLocationVH view from CONSUMPTION Product Storage Location Value Help View
C_PurOrdMaintainStorLocValHelp view from CONSUMPTION PO Maintenance: Value Help for Storage Location
C_StorageLocMalfuncManageVH view from CONSUMPTION Material Storage Location
C_SubcontrgStorageLocVH view from CONSUMPTION Storage Location Value Help
C_SupProtStorageLocationVH view_entity from CONSUMPTION Supply Protection Storage Location
I_FldLogsStorLocation view inner COMPOSITE Storage location
I_MaterialStorLocMRPArea view inner COMPOSITE Material Storage Location MRP Area Assignment
I_PhysInvtryStorageLocationVH view_entity from COMPOSITE Storage Locations in Physical Inventory
I_StorageLocationLastRFIDCount view from COMPOSITE Last RFID Count for Storage Location
I_StorageLocationStdVH view from BASIC Storage Location
P_DGR_PlantCmmdtyStrLoc view left_outer COMPOSITE
P_MMIM_STOLOC_M_MSEG_LGO_01 view from COMPOSITE
P_MSPWMovableProduct view inner BASIC
P_ProdCmplncStorLoc view_entity from COMPOSITE

Fields (8)

KeyField CDS FieldsUsed in Views
KEY Plant Plant,Store 8
KEY StorageLocation StorageLocation 10
_Plant _Plant 1
DistributionChannel DistributionChannel 1
Division Division 1
IsStorLocAuthznCheckActive IsStorLocAuthznCheckActive 1
SalesOrganization SalesOrganization 1
StorageLocationName StorageLocationName 10 
@AbapCatalog: {
                sqlViewName: 'ISTORAGELOCATION',
                preserveKey: true,
                compiler.compareFilter: true
              }
@EndUserText.label: 'Storage Location'
@ObjectModel: {
                usageType: {
                             sizeCategory: #S,
                             serviceQuality: #A,
                             dataClass:#CUSTOMIZING
                           },
                representativeKey: 'StorageLocation',
                sapObjectNodeType: {
                                     name: 'StorageLocation'
                                   },
                modelingPattern: #ANALYTICAL_DIMENSION,
                supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
              }
@VDM: {
        viewType: #BASIC,
        lifecycle.contract.type: #PUBLIC_LOCAL_API
      }
@AccessControl: {
                  authorizationCheck: #NOT_REQUIRED,
                  personalData.blocking: #NOT_REQUIRED
                }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics: {
              dataCategory: #DIMENSION,
              dataExtraction.enabled: true
            }
@Search.searchable: true
@Metadata: {
             allowExtensions: true,
             ignorePropagatedAnnotations: true
           }

define view I_StorageLocation
  as select from t001l
  association [1..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
{
      @ObjectModel.foreignKey.association: '_Plant'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key werks                     as Plant,
      @ObjectModel.text.element: 'StorageLocationName'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key lgort                     as StorageLocation,
      @Semantics.text: true
      cast(lgobe as lgort_name) as StorageLocationName,
      vkorg                     as SalesOrganization,
      vtweg                     as DistributionChannel,
      spart                     as Division,
      xblgo                     as IsStorLocAuthznCheckActive,
      xhupf                     as HandlingUnitIsRequired,
      configdeprecationcode     as ConfigDeprecationCode,
      _Plant
}     
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001L"
],
"ASSOCIATED":
[
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More