I_PlanningScopeHeaderTP

DDL: I_PLANNINGSCOPEHEADERTP SQL: IPLNSCPHDRTP Type: view TRANSACTIONAL
47 Fields 1 Data Sources 2 Associations

Document and BOM Links

I_PlanningScopeHeaderTP is a Transactional CDS View that provides data about "Document and BOM Links" in SAP S/4HANA. It reads from 1 data source (I_PlanningScopeHeader) and exposes 47 fields with key fields DocumentId, PlanningScopeAlternative, SourceMaterial. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PlanningScopeHeader PlanningScopeHeader from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_PlanningScopeMBOMTP _PlanningScopeMBOM $projection.DocumentId = _PlanningScopeMBOM.DocumentId and $projection.PlanningScopeAlternative = _PlanningScopeMBOM.PlanningScopeAlternative and $projection.SourceMaterial = _PlanningScopeMBOM.SourceMaterial
[1..*] I_PlanningScopeExplodedBOMTP _PlanningScopeExplodedBOM $projection.DocumentId = _PlanningScopeExplodedBOM.DocumentId and $projection.PlanningScopeAlternative = _PlanningScopeExplodedBOM.PlanningScopeAlternative and $projection.SourceMaterial = _PlanningScopeExplodedBOM.SourceMaterial

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName IPLNSCPHDRTP view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Document and BOM Links view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.compositionRoot true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.writeDraftPersistence VMP_HDR_DRAFT view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.entityChangeStateId LastChangeDateTime view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY DocumentId I_PlanningScopeHeader DocumentId Routing slip doc. ID
KEY PlanningScopeAlternative I_PlanningScopeHeader PlanningScopeAlternative
KEY SourceMaterial I_PlanningScopeHeader SourceMaterial
PlanningScopeDescription I_PlanningScopeHeader PlanningScopeDescription
Plant I_PlanningScopeHeader Plant Valuation Area
LastChangeDateTime I_PlanningScopeHeader LastChangeDateTime Timestamp
ChangeNumber I_PlanningScopeHeader ChangeNumber Change Number
DocumentInfoRecordDocType I_PlanningScopeHeader DocumentInfoRecordDocType Document Type
DocumentInfoRecordDocNumber I_PlanningScopeHeader DocumentInfoRecordDocNumber Document
DocumentInfoRecordDocPart I_PlanningScopeHeader DocumentInfoRecordDocPart Document Part
DocumentInfoRecordDocVersion I_PlanningScopeHeader DocumentInfoRecordDocVersion Doc. Version
MBOMUsage I_PlanningScopeHeader MBOMUsage
Material I_PlanningScopeHeader Material Vehicle Model
MfgBillOfMaterialCategory I_PlanningScopeHeader MfgBillOfMaterialCategory
SourcePlant I_PlanningScopeHeader SourcePlant
EBOMValidity I_PlanningScopeHeader EBOMValidity
SourceBOMAlternative I_PlanningScopeHeader SourceBOMAlternative
SourceBOMUsage I_PlanningScopeHeader SourceBOMUsage
SourceBOMType I_PlanningScopeHeader SourceBOMType
CreatedByUser I_PlanningScopeHeader CreatedByUser User Name
LastChangedByUser I_PlanningScopeHeader LastChangedByUser User Name
PlanningSourceType I_PlanningScopeHeader PlanningSourceType
RecordCreationDate I_PlanningScopeHeader RecordCreationDate Created On
BOMIsActive I_PlanningScopeHeader BOMIsActive
SourceMaterialForEdit I_PlanningScopeHeader SourceMaterialForEdit
ConfigurationSimulationDate I_PlanningScopeHeader ConfigurationSimulationDate Date
ProductStructureNodeUUID I_PlanningScopeHeader ProductStructureNodeUUID
ProductStructureUsage I_PlanningScopeHeader ProductStructureUsage
ProductStructureNodeName I_PlanningScopeHeader ProductStructureNodeName
ProductStructureNodeType I_PlanningScopeHeader ProductStructureNodeType
ClassType I_PlanningScopeHeader ClassType X Flag
Class I_PlanningScopeHeader Class User Group
ValidityStartDate I_PlanningScopeHeader ValidityStartDate Validity Start Date
ValidityEndDate I_PlanningScopeHeader ValidityEndDate ValidTo
HeaderValidityEndDate I_PlanningScopeHeader HeaderValidityEndDate to
SourceChangeNumber I_PlanningScopeHeader SourceChangeNumber
AlignmentStatusValue I_PlanningScopeHeader AlignmentStatusValue
AlignmentStatusCriticality I_PlanningScopeHeader AlignmentStatusCriticality
BOPFonrootlevel_PlanningScopeMBOM
BOPFonrootlevel_PlanningScopeExplodedBOM
_TargetPlant I_PlanningScopeHeader _TargetPlant
_SourcePlant I_PlanningScopeHeader _SourcePlant
_SourceMaterial I_PlanningScopeHeader _SourceMaterial
_SourceBOMUsage I_PlanningScopeHeader _SourceBOMUsage
_MBOMUsage I_PlanningScopeHeader _MBOMUsage
_CreatedByUser I_PlanningScopeHeader _CreatedByUser
_LastChangedByUser I_PlanningScopeHeader _LastChangedByUser

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_PlanningScopeHeaderTP.
-- 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: IPLNSCPHDRTP

CREATE VIEW I_PlanningScopeHeaderTP AS
SELECT
  PlanningScopeHeader.DocumentId AS DocumentId,
  PlanningScopeHeader.PlanningScopeAlternative AS PlanningScopeAlternative,
  PlanningScopeHeader.SourceMaterial AS SourceMaterial,
  PlanningScopeHeader.PlanningScopeDescription AS PlanningScopeDescription,
  PlanningScopeHeader.Plant AS Plant,
  PlanningScopeHeader.LastChangeDateTime AS LastChangeDateTime,
  PlanningScopeHeader.ChangeNumber AS ChangeNumber,
  PlanningScopeHeader.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  PlanningScopeHeader.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  PlanningScopeHeader.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  PlanningScopeHeader.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  PlanningScopeHeader.MBOMUsage AS MBOMUsage,
  PlanningScopeHeader.Material AS Material,
  PlanningScopeHeader.MfgBillOfMaterialCategory AS MfgBillOfMaterialCategory,
  PlanningScopeHeader.SourcePlant AS SourcePlant,
  PlanningScopeHeader.EBOMValidity AS EBOMValidity,
  PlanningScopeHeader.SourceBOMAlternative AS SourceBOMAlternative,
  PlanningScopeHeader.SourceBOMUsage AS SourceBOMUsage,
  PlanningScopeHeader.SourceBOMType AS SourceBOMType,
  PlanningScopeHeader.CreatedByUser AS CreatedByUser,
  PlanningScopeHeader.LastChangedByUser AS LastChangedByUser,
  PlanningScopeHeader.PlanningSourceType AS PlanningSourceType,
  PlanningScopeHeader.RecordCreationDate AS RecordCreationDate,
  PlanningScopeHeader.BOMIsActive AS BOMIsActive,
  PlanningScopeHeader.SourceMaterialForEdit AS SourceMaterialForEdit,
  PlanningScopeHeader.ConfigurationSimulationDate AS ConfigurationSimulationDate,
  PlanningScopeHeader.ProductStructureNodeUUID AS ProductStructureNodeUUID,
  PlanningScopeHeader.ProductStructureUsage AS ProductStructureUsage,
  PlanningScopeHeader.ProductStructureNodeName AS ProductStructureNodeName,
  PlanningScopeHeader.ProductStructureNodeType AS ProductStructureNodeType,
  PlanningScopeHeader.ClassType AS ClassType,
  PlanningScopeHeader.Class AS Class,
  PlanningScopeHeader.ValidityStartDate AS ValidityStartDate,
  PlanningScopeHeader.ValidityEndDate AS ValidityEndDate,
  PlanningScopeHeader.HeaderValidityEndDate AS HeaderValidityEndDate,
  PlanningScopeHeader.SourceChangeNumber AS SourceChangeNumber,
  PlanningScopeHeader.AlignmentStatusValue AS AlignmentStatusValue,
  PlanningScopeHeader.AlignmentStatusCriticality AS AlignmentStatusCriticality,
  PlanningScopeHeader._TargetPlant AS _TargetPlant,
  PlanningScopeHeader._SourcePlant AS _SourcePlant,
  PlanningScopeHeader._SourceMaterial AS _SourceMaterial,
  PlanningScopeHeader._SourceBOMUsage AS _SourceBOMUsage,
  PlanningScopeHeader._MBOMUsage AS _MBOMUsage,
  PlanningScopeHeader._CreatedByUser AS _CreatedByUser,
  PlanningScopeHeader._LastChangedByUser AS _LastChangedByUser
FROM I_PlanningScopeHeader AS PlanningScopeHeader
LEFT OUTER JOIN I_PlanningScopeMBOMTP AS _PlanningScopeMBOM ON DocumentId = _PlanningScopeMBOM.DocumentId AND PlanningScopeAlternative = _PlanningScopeMBOM.PlanningScopeAlternative AND SourceMaterial = _PlanningScopeMBOM.SourceMaterial  -- association [1..*]
LEFT OUTER JOIN I_PlanningScopeExplodedBOMTP AS _PlanningScopeExplodedBOM ON DocumentId = _PlanningScopeExplodedBOM.DocumentId AND PlanningScopeAlternative = _PlanningScopeExplodedBOM.PlanningScopeAlternative AND SourceMaterial = _PlanningScopeExplodedBOM.SourceMaterial  -- association [1..*]
;

Learn More