I_CHGIMPACTPLNGROUTINGOP
Planning Routing Operation
I_CHGIMPACTPLNGROUTINGOP is a CDS View in S/4HANA. Planning Routing Operation. It contains 24 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ChgImpactPlngRoutingOp | view | from | CONSUMPTION | Planning Routing Operation |
Fields (24)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfOperationsGroup | BillOfOperationsGroup | 1 |
| KEY | BillOfOperationsType | BillOfOperationsType | 1 |
| KEY | BillOfOperationsVariant | BillOfOperationsVariant | 1 |
| KEY | BOOOperationInternalID | BOOOperationInternalID | 1 |
| KEY | BOOOpInternalVersionCounter | BOOOpInternalVersionCounter | 1 |
| BillOfOperationsRefGroup | BillOfOperationsRefGroup | 1 | |
| BillOfOperationsRefVariant | BillOfOperationsRefVariant | 1 | |
| BillOfOperationsSequence | BillOfOperationsSequence | 1 | |
| BillOfOperationsVersion | BillOfOperationsVersion | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| IsDeleted | IsDeleted | 1 | |
| IsImplicitlyDeleted | IsImplicitlyDeleted | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LongTextLanguageCode | LongTextLanguageCode | 1 | |
| Operation | Operation | 1 | |
| OperationControlProfile | OperationControlProfile | 1 | |
| OperationExternalID | OperationExternalID | 1 | |
| OperationStandardTextCode | OperationStandardTextCode | 1 | |
| Plant | Plant | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 1 | |
| WorkCenterTypeCode | WorkCenterTypeCode | 1 |
@AbapCatalog.sqlViewName: 'ICHGIMPLNGROUOP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'Planning Routing Operation'
define view I_ChgImpactPlngRoutingOp
as select from I_BillOfOperationsOpBasic as RoutingOperation
inner join plas as OperationSelection on OperationSelection.plnty = RoutingOperation.BillOfOperationsType
and OperationSelection.plnnr = RoutingOperation.BillOfOperationsGroup
and OperationSelection.plnkn = RoutingOperation.BOOOperationInternalID
{
key RoutingOperation.BillOfOperationsType,
key RoutingOperation.BillOfOperationsGroup,
key RoutingOperation.BOOOperationInternalID,
key OperationSelection.plnal as BillOfOperationsVariant,
key RoutingOperation.BOOOpInternalVersionCounter,
OperationSelection.plnfl as BillOfOperationsSequence,
RoutingOperation.BillOfOperationsVersion,
RoutingOperation.WorkCenterInternalID,
RoutingOperation.WorkCenterTypeCode,
OperationSelection.loekz as IsDeleted,
OperationSelection.loekz_inherited as IsImplicitlyDeleted,
// ************************** Operation Header ***************************
RoutingOperation.OperationExternalID,
RoutingOperation.Operation_2 as Operation,
// ************************** Operation General **************************
-- Operation
RoutingOperation.OperationText,
RoutingOperation.LongTextLanguageCode,
RoutingOperation.Plant,
RoutingOperation.OperationControlProfile,
RoutingOperation.OperationStandardTextCode,
-- Origin
RoutingOperation.BillOfOperationsRefType,
RoutingOperation.BillOfOperationsRefGroup,
RoutingOperation.BillOfOperationsRefVariant,
// *************************** Administration ****************************
-- Administrative Data
RoutingOperation.CreationDate,
RoutingOperation.CreatedByUser,
RoutingOperation.LastChangeDate,
RoutingOperation.LastChangedByUser,
-- Validity
OperationSelection.aennr as ChangeNumber,
OperationSelection.datuv as ValidityStartDate,
OperationSelection.valid_to as ValidityEndDate
}
where
RoutingOperation.BillOfOperationsType = 'P'
and OperationSelection.loekz <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONSOPBASIC",
"PLAS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/