I_MatlDocStockIdfgWBSVH

DDL: I_MATLDOCSTOCKIDFGWBSVH SQL: IMTLDCSTKIDWBSVH Type: view BASIC
15 Fields

Invtry mngmt postings on stk ident WBS

I_MatlDocStockIdfgWBSVH is a Basic CDS View (Dimension) that provides data about "Invtry mngmt postings on stk ident WBS" in SAP S/4HANA.

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IMTLDCSTKIDWBSVH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Invtry mngmt postings on stk ident WBS view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Search.searchable true view
Consumption.ranked true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey SpecialStockIdfgWBSElement view
VDM.private false view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.allowExtensions true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SpecialStockIdfgWBSElement SpecialStockIdfgWBSElement WBS Internal ID
WBSElement
WBSElementExternalID _SpclStkIdfgWBSElmntBasicData WBSElementExternalID WBS Element External ID
WBSDescription _SpclStkIdfgWBSElmntBasicData WBSDescription WBS Element Name
WBSElementObject _SpclStkIdfgWBSElmntBasicData WBSElementObject Object number
ApplicantName _SpecialStockIdfgWBSElement ApplicantName
Plant _SpclStkIdfgWBSElmntBasicData Plant Valuation Area
Location _SpclStkIdfgWBSElmntBasicData Location Text
ProjectInternalID
ProjectType _SpclStkIdfgWBSElmntBasicData ProjectType Project Type
ControllingArea _SpclStkIdfgWBSElmntBasicData ControllingArea Controlling Area
ResponsibleCostCenter _SpclStkIdfgWBSElmntBasicData ResponsibleCostCenter Responsible Cost Center
RespCostCenterControllingArea _SpecialStockIdfgWBSElement RespCostCenterControllingArea
ProfitCenter _SpclStkIdfgWBSElmntBasicData ProfitCenter Profit Center
ResponsiblePersonName _SpecialStockIdfgWBSElement ResponsiblePersonName User

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_MatlDocStockIdfgWBSVH.
-- 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: IMTLDCSTKIDWBSVH

CREATE VIEW I_MatlDocStockIdfgWBSVH AS
SELECT
  SpecialStockIdfgWBSElement,
  cast ( _SpclStkIdfgWBSElmntBasicData.WBSElement as ps_posid) AS WBSElement,
  _SpclStkIdfgWBSElmntBasicData.WBSElementExternalID AS WBSElementExternalID,
  _SpclStkIdfgWBSElmntBasicData.WBSDescription AS WBSDescription,
  _SpclStkIdfgWBSElmntBasicData.WBSElementObject AS WBSElementObject,
  _SpecialStockIdfgWBSElement.ApplicantName AS ApplicantName,
  _SpclStkIdfgWBSElmntBasicData.Plant AS Plant,
  _SpclStkIdfgWBSElmntBasicData.Location AS Location,
  cast(_SpclStkIdfgWBSElmntBasicData.ProjectInternalID as mmim_project preserving type ) AS ProjectInternalID,
  _SpclStkIdfgWBSElmntBasicData.ProjectType AS ProjectType,
  _SpclStkIdfgWBSElmntBasicData.ControllingArea AS ControllingArea,
  _SpclStkIdfgWBSElmntBasicData.ResponsibleCostCenter AS ResponsibleCostCenter,
  _SpecialStockIdfgWBSElement.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  _SpclStkIdfgWBSElmntBasicData.ProfitCenter AS ProfitCenter,
  _SpecialStockIdfgWBSElement.ResponsiblePersonName AS ResponsiblePersonName
;

Learn More