I_PLANNINGSCOPEHEADERDETAIL
VEMP Planning Scope Header Details
I_PLANNINGSCOPEHEADERDETAIL is a CDS View in S/4HANA. VEMP Planning Scope Header Details. It contains 25 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_PlanningScopeExplodedBOM | view | inner | BASIC | VMP Planning scope expanded materials |
| P_PlanningScopeHeader | view | from | COMPOSITE | Document and BOM Links |
| P_PlanningScopeHeader | view | left_outer | COMPOSITE | Document and BOM Links |
| P_PlanningScopeMBOM | view | inner | BASIC | Document Mbom links |
Fields (25)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DocumentId | DocumentId | 1 |
| KEY | PlanningScopeAlternative | PlanningScopeAlternative | 1 |
| KEY | SourceMaterial | ProductStructureNodeName,SourceMaterial | 2 |
| BOMIsActive | BOMIsActive | 2 | |
| ChangeNumber | ChangeNumber | 2 | |
| ConfigurationSimulationDate | ConfigurationSimulationDate | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| DocumentInfoRecordDocNumber | DocumentInfoRecordDocNumber | 1 | |
| DocumentInfoRecordDocPart | DocumentInfoRecordDocPart | 1 | |
| DocumentInfoRecordDocType | DocumentInfoRecordDocType | 1 | |
| DocumentInfoRecordDocVersion | DocumentInfoRecordDocVersion | 1 | |
| EBOMValidity | EBOMValidity | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| Material | Material | 1 | |
| MBOMUsage | MBOMUsage | 1 | |
| MfgBillOfMaterialCategory | MfgBillOfMaterialCategory | 1 | |
| PlanningScopeDescription | PlanningScopeDescription | 1 | |
| PlanningSourceType | PlanningSourceType | 1 | |
| Plant | Plant | 2 | |
| RecordCreationDate | RecordCreationDate | 1 | |
| SourceBOMAlternative | SourceBOMAlternative | 1 | |
| SourceBOMType | SourceBOMType | 1 | |
| SourceBOMUsage | SourceBOMUsage | 1 | |
| SourcePlant | SourcePlant | 1 |
@AbapCatalog.sqlViewName: 'IPLNSCPHDRDET'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #MASTER}
@VDM.viewType: #BASIC
@EndUserText.label: 'VEMP Planning Scope Header Details'
define view I_PlanningScopeHeaderDetail
as select from vmp_plnscp_hdr as PlanningScopeHeader
{
//PlanningScopeHeader
key PlanningScopeHeader.documentid as DocumentId,
key PlanningScopeHeader.plan_scope_alt as PlanningScopeAlternative,
key PlanningScopeHeader.src_matnr as SourceMaterial,
PlanningScopeHeader.description as PlanningScopeDescription,
PlanningScopeHeader.plant as Plant,
PlanningScopeHeader.timestamp as LastChangeDateTime,
PlanningScopeHeader.change_number as ChangeNumber,
PlanningScopeHeader.dokar as DocumentInfoRecordDocType,
PlanningScopeHeader.doknr as DocumentInfoRecordDocNumber,
PlanningScopeHeader.doktl as DocumentInfoRecordDocPart,
PlanningScopeHeader.dokvr as DocumentInfoRecordDocVersion,
PlanningScopeHeader.mbom_usage as MBOMUsage,
PlanningScopeHeader.last_synced_by as LastChangedByUser,
PlanningScopeHeader.target_matnr as Material,
cast('M' as vmp_mbom_type preserving type ) as MfgBillOfMaterialCategory,
PlanningScopeHeader.created_on as RecordCreationDate,
PlanningScopeHeader.created_by as CreatedByUser,
// PlanningScopeHeader.source_plant as EBOMPlant,
PlanningScopeHeader.source_plant as SourcePlant,
PlanningScopeHeader.source_bom_alt as SourceBOMAlternative,
PlanningScopeHeader.source_bom_usage as SourceBOMUsage,
PlanningScopeHeader.source_validity as EBOMValidity,
PlanningScopeHeader.source_bom_type as SourceBOMType,
PlanningScopeHeader.stlst as BOMIsActive,
PlanningScopeHeader.psm_explosion_date as ConfigurationSimulationDate,
PlanningScopeHeader.psm_node_guid as ProductStructureNodeUUID,
// PlanningScopeHeader.psm_simulation as Simulation,
// PlanningScopeHeader.psm_plant as ProductStructurePlant,
PlanningScopeHeader.psm_usage as ProductStructureUsage,
case PlanningScopeHeader.doknr
when '' then case PlanningScopeHeader.psm_usage
when '' then cast ('EBOM' as abap.sstring(10) )
else cast('PSM' as abap.sstring(10) )
end
else cast('DBOM' as abap.sstring(10) )
end as PlanningSourceType,
PlanningScopeHeader.source_change_number as SourceChangeNumber
}