I_WarehouseGateText

DDL: I_WAREHOUSEGATETEXT SQL: ILEWRHSGATET Type: view BASIC Package: VDM_LE_SHP_COMMON
7 Fields 1 Data Sources 1 OData Services

Warehouse Gate - Text

I_WarehouseGateText is a Basic CDS View that provides data about "Warehouse Gate - Text" in SAP S/4HANA. It reads from 1 data source (t30bt) and exposes 7 fields with key fields Warehouse, WarehouseGate, Language. It is exposed through 1 OData service (ASQL_F4557). Part of development package VDM_LE_SHP_COMMON.

Data Sources (1)

SourceAliasJoin Type
t30bt t30bt from

Annotations (11)

NameValueLevelField
Analytics.dataExtraction.enabled false view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey WarehouseGate view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Warehouse Gate - Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ILEWRHSGATET view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4557 ASQL_F4557 C2 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Warehouse lgnum Whse Number
KEY WarehouseGate lgtor Door for Whse
KEY Language spras Off. Language
WarehouseGateName ltort Whse door text
_Warehouse _Warehouse
_WarehouseGate _WarehouseGate
_Language _Language

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_WarehouseGateText.
-- 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: ILEWRHSGATET

CREATE VIEW I_WarehouseGateText AS
SELECT
  lgnum AS Warehouse,
  lgtor AS WarehouseGate,
  spras AS Language,
  ltort AS WarehouseGateName
FROM t30bt
;

Learn More