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
/VSCEW/I_MRPAreaStorageLoc view_entity from MRP Area Storage Location
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 Move Products w/ RFID: Storage Location
C_MSPWStorageLocation view from CONSUMPTION MPW: Storage Location
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_MMIM_STOLOC_M_MSEG_LGO_01 view from COMPOSITE Storage locations with authority M_MSEG_LGO activity 01
P_MSPWMovableProduct view inner BASIC MPW: Worklist of proposed movements (helper)
P_ProdCmplncStorLoc view_entity from COMPOSITE Product Complliance Storage Location with Fallback

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
  association [1..1] to I_ConfignDeprecationCode  as _ConfignDeprecationCode on $projection.ConfigDeprecationCode = _ConfignDeprecationCode.ConfigurationDeprecationCode   
  association [0..*] to I_ConfignDeprecationCodeText     as _ConfignDeprecationCodeText      on  $projection.ConfigDeprecationCode= _ConfignDeprecationCodeText.DomainValue 
  association [0..*] to I_SalesOrganizationText          as _SalesOrganizationText           on  $projection.SalesOrganization = _SalesOrganizationText.SalesOrganization                                                                         
{
      @ObjectModel.foreignKey.association: '_Plant'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_PlantStdVH', element: 'Plant' }, useAsTemplate: true } ]
  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,
      @Consumption.valueHelpDefinition: [{ entity:  { name:    'I_SalesOrganizationStdVH', element: 'SalesOrganization' }, useAsTemplate: true    }]
//      @ObjectModel.text.association: '_SalesOrganizationText'  

      vkorg                     as SalesOrganization,
      vtweg                     as DistributionChannel,
      spart                     as Division,
      xblgo                     as IsStorLocAuthznCheckActive,
      xhupf                     as HandlingUnitIsRequired,
      @ObjectModel.foreignKey.association: '_ConfignDeprecationCode'
//     @Consumption.valueHelpDefinition: [{ entity:  { name:    'I_ConfignDeprecationCode', element: 'ConfigurationDeprecationCode' }, useAsTemplate: true    }]

//      @ObjectModel.text.association: '_ConfignDeprecationCodeText'  

      configdeprecationcode     as ConfigDeprecationCode,
      _Plant,
      _ConfignDeprecationCode,
     _ConfignDeprecationCodeText,
     _SalesOrganizationText
      
}

Learn More