P_MaterialPlantStorageLocation

DDL: P_MATERIALPLANTSTORAGELOCATION SQL: PMATPLANTSLOC Type: view COMPOSITE
81 Fields 1 Data Sources 1 Associations

P_MaterialPlantStorageLocation is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_Materialplantmalfuncmanage) and exposes 81 fields with key fields Material, Plant, StorageLocation. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_Materialplantmalfuncmanage P_Materialplantmalfuncmanage from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProductStorageLocation _ProductStorageLocation $projection.Material = _ProductStorageLocation.Product and $projection.Plant = _ProductStorageLocation.Plant

Annotations (5)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PMATPLANTSLOC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (81)

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

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 P_MaterialPlantStorageLocation.
-- 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: PMATPLANTSLOC

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

Learn More