C_MaintenanceChecklistTP

DDL: C_MAINTENANCECHECKLISTTP Type: view_entity CONSUMPTION
100 Fields 1 Data Sources

Manage Inspection Checklist TP

C_MaintenanceChecklistTP is a Consumption CDS View that provides data about "Manage Inspection Checklist TP" in SAP S/4HANA. It reads from 1 data source (R_MaintenanceChecklistTP) and exposes 100 fields with key fields InspectionLot, MaintenanceOrder, MaintenanceOrderOperation.

Data Sources (1)

SourceAliasJoin Type
R_MaintenanceChecklistTP R_MaintenanceChecklistTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Manage Inspection Checklist TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (100)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY MaintenanceOrder MaintenanceOrder Order
KEY MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
MaintenanceBusinessSubobject MaintenanceBusinessSubobject
Plant Plant Valuation Area
MaintOperationalChecklistType MaintOperationalChecklistType Checklist Type
MaintenanceChecklistTypeText _CheckListType MaintenanceChecklistTypeText
InspectionLotType InspectionLotType Inspection Type
InspectionLotTypeText
InspectionLotText InspectionLotText
MainChecklistIsDeactivated MainChecklistIsDeactivated
ActivationStatusName ActivationStatusName
IsLocked IsLocked
TechnicalObject _OrderTechnicalObject TechnicalObject Technical Object
TechnicalObjectDescription
TechObjIsEquipOrFuncnlLoc _OrderTechnicalObject TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechnicalObjectLabel
FunctionalLocationLabelName
AuthorizationGroup AuthorizationGroup AuthorizGroup
TechObjAuthorizationGroupDesc _AuthorizationGroup TechObjAuthorizationGroupDesc
InspectionLotTechnicalObject InspectionLotTechnicalObject
InspLotTechnicalObjectDesc _InspectionLotTechnicalObject TechnicalObjectDescription Tech. Obj. Desc
OpTechObjEquipOrFuncnlLoc OpTechObjEquipOrFuncnlLoc
InspLotTechnicalObjectLabel
MaintObjectFreeDefinedAttrib
InspCharacteristicCount _InspectionLotAggregate InspCharacteristicCount
InspCharAcceptedCount _InspectionLotAggregate InspCharAcceptedCount
InspCharRejectedCount _InspectionLotAggregate InspCharRejectedCount
InspCharOpenCount _InspectionLotAggregate InspCharOpenCount
InspLotUsageDecisionValuation InspLotUsageDecisionValuation
InspLotUsgeDcsnValuationText
InspectionLotUsageDecisionCode InspectionLotUsageDecisionCode
UsageDecisionCodeText
UsageDecisionCodeCriticality UsageDecisionCodeCriticality
InspectionLotQualityScore InspectionLotQualityScore Inspection Lot Score
ScheduledBasicStartDate ScheduledBasicStartDate Sched. start
ScheduledBasicStartTime ScheduledBasicStartTime
MaintOrdSchedBscStartDateTime MaintOrdSchedBscStartDateTime
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
ScheduledBasicEndTime ScheduledBasicEndTime
MaintOrdSchedldBscEndDateTime MaintOrdSchedldBscEndDateTime Time Stamp
MaintenanceOrderDesc MaintenanceOrderDesc Description
OperationDescription OperationDescription Op. Short Text
PlantName _Plant PlantName Plant Name
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlanningPlantName
MaintenanceOrderType MaintenanceOrderType Order Type
OrderTypeName
MaintenancePlan MaintenancePlan MaintenancePlan
MaintenancePlanDesc
MaintenanceItem MaintenanceItem MaintItem
MaintenanceItemDescription
MaintenanceActivityType MaintenanceActivityType MaintActivType
MaintenanceActivityTypeName
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlannerGroupName
MainWorkCenter MainWorkCenter Work Center
WorkCenterText
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
WorkCenterPlantName
OperationWorkCenter _OperationWorkCenter WorkCenter Work Center
OperationWorkCenterText
OperationWorkCenterPlant _OperationWorkCenter Plant Valuation Area
OperationWorkCenterPlantName
OperationControlKey OperationControlKey Control Key
OperationControlProfileName
OperationStandardTextCode OperationStandardTextCode Std Text Key
OperationStandardTextCodeName
InspectionLotCreatedOn InspectionLotCreatedOn
InspectionLotCreatedOnTime InspectionLotCreatedOnTime
InspectionLotCreateDateTime InspectionLotCreateDateTime
InspectionLotCreatedBy InspectionLotCreatedBy
CreatedByUserName _CreatedByUser UserDescription Full Name
InspectionLotChangeDate InspectionLotChangeDate
InspectionLotChangeTime InspectionLotChangeTime
InspectionLotChangeDateTime InspectionLotChangeDateTime
InspectionLotChangedBy InspectionLotChangedBy
LastChangedByUserName _LastChangedByUser UserDescription Full Name
InspectionLotPlant InspectionLotPlant Valuation Area
InspectionLotPlantName
Material Material Vehicle Model
MaterialName
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsUsage BillOfOperationsUsage
BillOfOperationsUsageDesc
BillOfOperationsChangeStateID BillOfOperationsChangeStateID
InspectionPlanDescription _BillOfOperationsChangeState BillOfOperationsDesc
InspLotCompltnStatus InspLotCompltnStatus
InspLotCompltnStatusText _InspLotCompltnStatusText InspLotCompltnStatusText
BillOfMaterialItemNumber _OrderComponent BillOfMaterialItemNumber Item
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
SortField SortField Sort Field
InspectionLotQuantity _InspectionLot InspectionLotQuantity
InspectionLotQuantityUnit _InspectionLot InspectionLotQuantityUnit
NumberOfSerialNumbers _InspectionLot NumberOfSerialNumbers No.serial no.

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 C_MaintenanceChecklistTP.
-- 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.

CREATE VIEW C_MaintenanceChecklistTP AS
SELECT
  InspectionLot,
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceBusinessSubobject,
  Plant,
  MaintOperationalChecklistType,
  _CheckListType.MaintenanceChecklistTypeText AS MaintenanceChecklistTypeText,
  InspectionLotType,
  _InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  InspectionLotText,
  MainChecklistIsDeactivated,
  ActivationStatusName,
  IsLocked,
  _OrderTechnicalObject.TechnicalObject AS TechnicalObject,
  _OrderTechnicalObject._TechnicalObject.TechnicalObjectDescription AS TechnicalObjectDescription,
  _OrderTechnicalObject.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  cast (_OrderTechnicalObject._TechnicalObject.TechnicalObjectLabel as eams_tech_obj_alpha_conv preserving type ) AS TechnicalObjectLabel,
  _OrderTechnicalObject._FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  AuthorizationGroup,
  _AuthorizationGroup.TechObjAuthorizationGroupDesc AS TechObjAuthorizationGroupDesc,
  InspectionLotTechnicalObject,
  _InspectionLotTechnicalObject.TechnicalObjectDescription AS InspLotTechnicalObjectDesc,
  OpTechObjEquipOrFuncnlLoc,
  cast (_InspectionLotTechnicalObject.TechnicalObjectLabel as eams_tech_obj_alpha_conv preserving type ) AS InspLotTechnicalObjectLabel,
  _InspectionLotTechnicalObject._LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  _InspectionLotAggregate.InspCharacteristicCount AS InspCharacteristicCount,
  _InspectionLotAggregate.InspCharAcceptedCount AS InspCharAcceptedCount,
  _InspectionLotAggregate.InspCharRejectedCount AS InspCharRejectedCount,
  _InspectionLotAggregate.InspCharOpenCount AS InspCharOpenCount,
  InspLotUsageDecisionValuation,
  _InspLotUsageDecision._UsageDecisionValuation._Text[1:Language=$session.system_language].InspLotUsgeDcsnValuationText AS InspLotUsgeDcsnValuationText,
  InspectionLotUsageDecisionCode,
  _InspLotUsageDecision._UsageDecisionCode._Text[1:Language=$session.system_language].UsageDecisionCodeText AS UsageDecisionCodeText,
  UsageDecisionCodeCriticality,
  InspectionLotQualityScore,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  MaintOrdSchedBscStartDateTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  MaintOrdSchedldBscEndDateTime,
  MaintenanceOrderDesc,
  OperationDescription,
  _Plant.PlantName AS PlantName,
  MaintenancePlanningPlant,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
  MaintenanceOrderType,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenanceOrderType._Text[1: Language=$session.system_language].OrderTypeName AS OrderTypeName,
  MaintenancePlan,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  MaintenanceItem,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  MaintenanceActivityType,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenanceActivityType._Text[1: Language=$session.system_language].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  MaintenancePlannerGroup,
  _MaintenanceOrderOp._MaintenanceOrder._MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  MainWorkCenter,
  _MaintenanceOrderOp._MaintenanceOrder._MainWorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterText,
  MainWorkCenterPlant,
  _MaintenanceOrderOp._MaintenanceOrder._MainWorkCenter._Plant.PlantName AS WorkCenterPlantName,
  _OperationWorkCenter.WorkCenter AS OperationWorkCenter,
  _OperationWorkCenter._WorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS OperationWorkCenterText,
  _OperationWorkCenter.Plant AS OperationWorkCenterPlant,
  _OperationWorkCenter._WorkCenter._Plant.PlantName AS OperationWorkCenterPlantName,
  OperationControlKey,
  _MaintenanceOrderOp._OperationControlKey._Text[1:Language=$session.system_language].OperationControlProfileName AS OperationControlProfileName,
  OperationStandardTextCode,
  _OperationStandardText._Text[1:Language = $session.system_language].OperationStandardTextCodeName AS OperationStandardTextCodeName,
  InspectionLotCreatedOn,
  InspectionLotCreatedOnTime,
  InspectionLotCreateDateTime,
  InspectionLotCreatedBy,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  InspectionLotChangeDate,
  InspectionLotChangeTime,
  InspectionLotChangeDateTime,
  InspectionLotChangedBy,
  _LastChangedByUser.UserDescription AS LastChangedByUserName,
  InspectionLotPlant,
  _InspectionLot._Plant.PlantName AS InspectionLotPlantName,
  Material,
  _InspectionLot._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsType,
  BillOfOperationsUsage,
  _BillOfOperationsUsage._Text[1:Language=$session.system_language].BillOfOperationsUsageDesc AS BillOfOperationsUsageDesc,
  BillOfOperationsChangeStateID,
  _BillOfOperationsChangeState.BillOfOperationsDesc AS InspectionPlanDescription,
  InspLotCompltnStatus,
  _InspLotCompltnStatusText.InspLotCompltnStatusText AS InspLotCompltnStatusText,
  _OrderComponent.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  Reservation,
  ReservationItem,
  SortField,
  _InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
  _InspectionLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _InspectionLot.NumberOfSerialNumbers AS NumberOfSerialNumbers
FROM R_MaintenanceChecklistTP
;

Learn More