I_WarehouseGate

DDL: I_WAREHOUSEGATE SQL: ILEWRHSGATE Type: view BASIC

Warehouse Gate

I_WarehouseGate is a Basic CDS View (Dimension) that provides data about "Warehouse Gate" in SAP S/4HANA. It reads from 1 data source (t30b) and exposes 4 fields with key fields Warehouse, WarehouseGate. It has 2 associations to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
t30b t30b from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Warehouse _Warehouse $projection.Warehouse = _Warehouse.Warehouse
[0..*] I_WarehouseGateText _Text $projection.Warehouse = _Text.Warehouse and $projection.WarehouseGate = _Text.WarehouseGate

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey WarehouseGate view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Warehouse Gate view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ILEWRHSGATE view
Metadata.allowExtensions true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Warehouse lgnum
KEY WarehouseGate lgtor
_Warehouse _Warehouse
_Text _Text 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.representativeKey: 'WarehouseGate'
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
//Commented by VDM CDS Suite Plugin:@ObjectModel.representativeKey: 'WarehouseGate'

@EndUserText.label: 'Warehouse Gate'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: false }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ILEWRHSGATE'
@Metadata.allowExtensions: true

define view I_WarehouseGate
as select from
t30b
association [0..1] to I_Warehouse as _Warehouse on $projection.Warehouse = _Warehouse.Warehouse
association [0..*] to I_WarehouseGateText as _Text on $projection.Warehouse  = _Text.Warehouse and $projection.WarehouseGate = _Text.WarehouseGate
{
    @ObjectModel.foreignKey.association: '_Warehouse'
    key lgnum as Warehouse,
    @ObjectModel.text.association: '_Text'
    key lgtor as WarehouseGate,

    _Warehouse,
    _Text
};
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T30B"
],
"ASSOCIATED":
[
"I_WAREHOUSE",
"I_WAREHOUSEGATETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More