I_MaterialInclStorLocation

DDL: I_MATERIALINCLSTORLOCATION SQL: IMATSTLOC Type: view COMPOSITE Package: ODATA_EAM_MALFUNCTION_MANAGE
88 Fields 1 Data Sources 7 Associations

Material including Storage Location

I_MaterialInclStorLocation is a Composite CDS View that provides data about "Material including Storage Location" in SAP S/4HANA. It reads from 1 data source (P_MaterialPlantStorageLocation) and exposes 88 fields with key fields Material, Plant, StorageLocation. It has 7 associations to related views. Part of development package ODATA_EAM_MALFUNCTION_MANAGE.

Data Sources (1)

SourceAliasJoin Type
P_MaterialPlantStorageLocation P_MaterialPlantStorageLocation from

Associations (7)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _Text $projection.Material = _Text.Material
[0..1] I_MaterialType _MaterialType $projection.MaterialType = _MaterialType.MaterialType
[0..1] I_MaterialGroup _MaterialGroup $projection.MaterialGroup = _MaterialGroup.MaterialGroup
[0..1] I_UnitOfMeasure _BaseUnit $projection.MaterialBaseUnit = _BaseUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _WeightUnit $projection.MaterialWeightUnit = _WeightUnit.UnitOfMeasure
[0..1] I_StorageLocation _StorageLocation $projection.Plant = _StorageLocation.Plant and $projection.StorageLocation = _StorageLocation.StorageLocation
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IMATSTLOC view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Material including Storage Location view

Fields (88)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
ABCIndicator ABCIndicator ABC Indicator
AvailabilityCheckType AvailabilityCheckType Avail. check
Commodity Commodity Commodity Code
ConsignmentControl ConsignmentControl Consign.Control
ConsumptionQtyMultiplier ConsumptionQtyMultiplier Multiplier
ConsumptionRefUsageEndDate ConsumptionRefUsageEndDate Date to
ConsumptionReferencePlant ConsumptionReferencePlant Ref.plant:cons.
ConsumptionReferenceProduct ConsumptionReferenceProduct Ref.matl: cons.
ConsumptionTaxCtrlCode ConsumptionTaxCtrlCode Taxes F.Trade
CountryOfOrigin CountryOfOrigin Country/Region of Origin
CreationDate CreationDate Time Stamp
DateOfLastPostedCntUnRstrcdStk DateOfLastPostedCntUnRstrcdStk Last Count Date
DistrCntrDistributionProfile DistrCntrDistributionProfile Dist.prof.
FiscalMonthCurrentPeriod FiscalMonthCurrentPeriod Current period
FiscalYearCurrentInvtryPeriod FiscalYearCurrentInvtryPeriod Fiscal Year of Current Physical Inventory Indicator
FiscalYearCurrentPeriod FiscalYearCurrentPeriod Year cur.period
FiscalYearVariant FiscalYearVariant FY Variant
FixedLotSizeQuantity FixedLotSizeQuantity Fixed lot size
GoodIssueProcessingDays GoodIssueProcessingDays GI Proc.Time
GoodsIssueUnit GoodsIssueUnit Unit of Issue
GoodsReceiptBlockedStockQty GoodsReceiptBlockedStockQty Val. GR Blocked Stck
GoodsReceiptDuration GoodsReceiptDuration GR proc. time
HasConsignmentCtrl HasConsignmentCtrl Consign.Control
HasInvtryBlockStockPrevPeriod HasInvtryBlockStockPrevPeriod Blocked stock
HasPostToInspectionStock HasPostToInspectionStock Post to insp. stk
InventoryBlockStockInd InventoryBlockStockInd Blocked stock
InventoryCorrectionFactor InventoryCorrectionFactor Inven.cor.fact.
InventoryStockPrevPeriod InventoryStockPrevPeriod Warehouse stock
InvtryCurrentYearStockInd InvtryCurrentYearStockInd Warehouse stock
InvtryQualInspCurrentYrStkInd InvtryQualInspCurrentYrStkInd QualInspStock
InvtryRestStockPrevPeriodInd InvtryRestStockPrevPeriodInd Restricted use
InvtryRestrictedUseStockInd InvtryRestrictedUseStockInd Restricted-use
InvtryStockQltyInspPrevPeriod InvtryStockQltyInspPrevPeriod QualInspStock
IsBatchManagementRequired IsBatchManagementRequired Batch Mgmt Rqt(Plnt)
IsCoProduct IsCoProduct Co-product?
IsInternalBatchManaged IsInternalBatchManaged Batches
IsNegativeStockAllowed IsNegativeStockAllowed Neg. stocks
IsPurgAcrossPurgGroup IsPurgAcrossPurgGroup Across Purch.Group
MRPResponsible MRPResponsible MRP Controller
MRPType MRPType MRP Type
MaintenanceStatus MaintenanceStatus Maint. status
MaintenanceStatusName MaintenanceStatusName Maint. status
MaterialBaseUnit MaterialBaseUnit Valuation Unit
MaterialGrossWeight MaterialGrossWeight
MaterialGroup MaterialGroup Product Group
MaterialManufacturerNumber MaterialManufacturerNumber
MaterialManufacturerPartNumber MaterialManufacturerPartNumber
MaterialNetWeight MaterialNetWeight
MaterialType MaterialType Material Type
MaterialWeightUnit MaterialWeightUnit
MaximumLotSizeQuantity MaximumLotSizeQuantity Max. Lot Size
MinimumLotSizeQuantity MinimumLotSizeQuantity Min. Lot Size
OverDelivToleranceLimit OverDelivToleranceLimit Overdely tol.
PeriodType PeriodType PeriodIndicator
PhysicalInventoryBlockInd PhysicalInventoryBlockInd Phys. Inv. Blk
ProcurementType ProcurementType Procurement
Product Product Product Sold
ProductCFOPCategory ProductCFOPCategory Prod. category
ProductIsConfigurable ProductIsConfigurable Configurable
ProductUnitGroup ProductUnitGroup UoM Group
ProductionInvtryManagedLoc ProductionInvtryManagedLoc Storage Location
ProductionSchedulingProfile ProductionSchedulingProfile Production Scheduling Profile
ProductionSupervisor ProductionSupervisor Prodn Supervisor
ProfileCode ProfileCode Product Status
ProfileValidityStartDate ProfileValidityStartDate Valid from
ProfitCenter ProfitCenter Profit Center
PurchasingGroup PurchasingGroup Purchasing Group
RegionOfOrigin RegionOfOrigin Reg. of Origin
SafetyStockQuantity SafetyStockQuantity Safety stock
SerialNumberProfile SerialNumberProfile SerialNoProfile
SourceOfSupplyCategory SourceOfSupplyCategory Supply source
SpecialProcurementType SpecialProcurementType SpecProcurement
StockDeterminationGroup StockDeterminationGroup Stock Determ. Group
StockInTransferQuantity StockInTransferQuantity Stock in tfr
StockInTransitQuantity StockInTransitQuantity Stk in Transit
UnderDelivToleranceLimit UnderDelivToleranceLimit Underdely tol.
WarehouseStorageBin WarehouseStorageBin Storage Bin
AuthorizationGroup AuthorizationGroup AuthorizGroup
_Text _Text
_BaseUnit _BaseUnit
_WeightUnit _WeightUnit
_MaterialGroup _MaterialGroup
_MaterialType _MaterialType
_StorageLocation _StorageLocation
_Plant _Plant

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_MaterialInclStorLocation.
-- 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: IMATSTLOC

CREATE VIEW I_MaterialInclStorLocation AS
SELECT
  Material,
  Plant,
  StorageLocation,
  ABCIndicator,
  AvailabilityCheckType,
  Commodity,
  ConsignmentControl,
  ConsumptionQtyMultiplier,
  ConsumptionRefUsageEndDate,
  ConsumptionReferencePlant,
  ConsumptionReferenceProduct,
  ConsumptionTaxCtrlCode,
  CountryOfOrigin,
  CreationDate,
  DateOfLastPostedCntUnRstrcdStk,
  DistrCntrDistributionProfile,
  FiscalMonthCurrentPeriod,
  FiscalYearCurrentInvtryPeriod,
  FiscalYearCurrentPeriod,
  FiscalYearVariant,
  FixedLotSizeQuantity,
  GoodIssueProcessingDays,
  GoodsIssueUnit,
  GoodsReceiptBlockedStockQty,
  GoodsReceiptDuration,
  HasConsignmentCtrl,
  HasInvtryBlockStockPrevPeriod,
  HasPostToInspectionStock,
  InventoryBlockStockInd,
  InventoryCorrectionFactor,
  InventoryStockPrevPeriod,
  InvtryCurrentYearStockInd,
  InvtryQualInspCurrentYrStkInd,
  InvtryRestStockPrevPeriodInd,
  InvtryRestrictedUseStockInd,
  InvtryStockQltyInspPrevPeriod,
  IsBatchManagementRequired,
  IsCoProduct,
  IsInternalBatchManaged,
  IsNegativeStockAllowed,
  IsPurgAcrossPurgGroup,
  MRPResponsible,
  MRPType,
  MaintenanceStatus,
  MaintenanceStatusName,
  MaterialBaseUnit,
  MaterialGrossWeight,
  MaterialGroup,
  MaterialManufacturerNumber,
  MaterialManufacturerPartNumber,
  MaterialNetWeight,
  MaterialType,
  MaterialWeightUnit,
  MaximumLotSizeQuantity,
  MinimumLotSizeQuantity,
  OverDelivToleranceLimit,
  PeriodType,
  PhysicalInventoryBlockInd,
  ProcurementType,
  Product,
  ProductCFOPCategory,
  ProductIsConfigurable,
  ProductUnitGroup,
  ProductionInvtryManagedLoc,
  ProductionSchedulingProfile,
  ProductionSupervisor,
  ProfileCode,
  ProfileValidityStartDate,
  ProfitCenter,
  PurchasingGroup,
  RegionOfOrigin,
  SafetyStockQuantity,
  SerialNumberProfile,
  SourceOfSupplyCategory,
  SpecialProcurementType,
  StockDeterminationGroup,
  StockInTransferQuantity,
  StockInTransitQuantity,
  UnderDelivToleranceLimit,
  WarehouseStorageBin,
  AuthorizationGroup
FROM P_MaterialPlantStorageLocation
LEFT OUTER JOIN I_MaterialText AS _Text ON Material = _Text.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialType AS _MaterialType ON MaterialType = _MaterialType.MaterialType  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON MaterialBaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON MaterialWeightUnit = _WeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;

Learn More