Which tables does C_MaintOrdConfForCreateTP use?

C_MaintOrdConfForCreateTP reads from 1 data source(s): I_MaintenanceOrderConfTP.

How many fields does C_MaintOrdConfForCreateTP have?

C_MaintOrdConfForCreateTP has 47 fields. Key fields: MaintOrderConf, MaintOrderConfCntrValue.

C_MaintOrdConfForCreateTP

DDL: C_MAINTORDCONFFORCREATETP SQL: CMAINORDR Type: view CONSUMPTION Package: ODATA_EAM_ORD_MASS_CONF_MAN

Consumption View for Maintenance Order Confirmation Create

C_MaintOrdConfForCreateTP is a Consumption CDS View that provides data about "Consumption View for Maintenance Order Confirmation Create" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderConfTP) and exposes 47 fields with key fields MaintOrderConf, MaintOrderConfCntrValue. It has 4 associations to related views. Part of development package ODATA_EAM_ORD_MASS_CONF_MAN.

Data Sources (1)

Source	Alias	Join Type
I_MaintenanceOrderConfTP	I_MaintenanceOrderConfTP	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	C_MaintOrderOperationTP	_MaintOrderOperationTP	`_MaintOrderOperationTP.MaintenanceOrder = $projection.MaintenanceOrder and _MaintOrderOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation`
[0..1]	I_PMTimeUnitVH	_ActualWorkUnit	`_ActualWorkUnit.UnitOfMeasure = $projection.ActualWorkQuantityUnit`
[1..*]	C_MaintOrdConfMessageTP	_MaintOrdConfMessageTP	`_MaintOrdConfMessageTP.MaintOrderConf = $projection.MaintOrderConf and _MaintOrdConfMessageTP.MaintOrderConfCntrValue = $projection.MaintOrderConfCntrValue`
[0..1]	I_PersonWorkAgreement_1	_PersonnelName	`$projection.PersonnelNumber = _PersonnelName.PersonWorkAgreement`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	CMAINORDR	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Consumption View for Maintenance Order Confirmation Create	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.compositionRoot	true	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.draftEnabled	true	view
ObjectModel.updateEnabled	true	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
UI.headerInfo.typeName	Confirmation	view
UI.headerInfo.typeNamePlural	Confirmations	view

Fields (47)

Key	Field	Source Table	Source Field	Description
KEY	MaintOrderConf	I_MaintenanceOrderConfTP	MaintOrderConf	Confirmation
KEY	MaintOrderConfCntrValue	I_MaintenanceOrderConfTP	MaintOrderConfCntrValue
	MaintenanceOrder	I_MaintenanceOrderConfTP	MaintenanceOrder	Order
	MaintenanceOrderDesc	_MaintenanceOrder	MaintenanceOrderDesc
	MaintenanceOrderOperation	I_MaintenanceOrderConfTP	MaintenanceOrderOperation	Operation
	OperationDescription	I_MaintenanceOrderConfTP	OperationDescription
	MaintOrderOperationCounter	I_MaintenanceOrderConfTP	MaintOrderOperationCounter
	MaintenanceOrderSubOperation	I_MaintenanceOrderConfTP	MaintenanceOrderSubOperation	Suboperation
	ActivityType	I_MaintenanceOrderConfTP	ActivityType	Activity Type
	MaintOrderConfForEdit	I_MaintenanceOrderConfTP	MaintOrderConfForEdit
	MaintOrderConfCntrValueForEdit	I_MaintenanceOrderConfTP	MaintOrderConfCntrValueForEdit
	ActualWorkQuantity	I_MaintenanceOrderConfTP	ActualWorkQuantity	Actual Work
	ActualWorkQuantityUnit	I_MaintenanceOrderConfTP	ActualWorkQuantityUnit
	PostingDate	I_MaintenanceOrderConfTP	PostingDate	Posting Date
	IsFinalConfirmation	I_MaintenanceOrderConfTP	IsFinalConfirmation	Final Confirmation
	RemainingWorkQuantity	I_MaintenanceOrderConfTP	RemainingWorkQuantity
	RemainingWorkQuantityUnit	I_MaintenanceOrderConfTP	RemainingWorkQuantityUnit	Unit of Measure for Remaining Work
	Plant	I_MaintenanceOrderConfTP	Plant
	AddressTimeZone	I_MaintenanceOrderConfTP	AddressTimeZone	Plant Time Zone
	ActyConfFcstdEndDate	I_MaintenanceOrderConfTP	ActyConfFcstdEndDate	Forecast End Date
	ActyConfFcstdEndTime	I_MaintenanceOrderConfTP	ActyConfFcstdEndTime	Forecast End Time
	MaintOrdOpFcstdEndDateTime		MaintOrdOpFcstdEndDateTime	Forecast End
	OperationConfirmedStartDate	I_MaintenanceOrderConfTP	OperationConfirmedStartDate	Start Date
	OperationConfirmedStartTime	I_MaintenanceOrderConfTP	OperationConfirmedStartTime	Start Time
	MaintOrdOpWrkExecStartDateTime		MaintOrdOpWrkExecStartDateTime	Start Date and Time
	OperationConfirmedEndDate	I_MaintenanceOrderConfTP	OperationConfirmedEndDate	End Date
	OperationConfirmedEndTime	I_MaintenanceOrderConfTP	OperationConfirmedEndTime	End Time
	MaintOrdOpWrkExecEndDateTime		MaintOrdOpWrkExecEndDateTime	End Date and Time
	NoFurtherWorkQuantityIsExpd	I_MaintenanceOrderConfTP	NoFurtherWorkQuantityIsExpd	No Remaining Work Expected
	OpenReservationsIsCleared	I_MaintenanceOrderConfTP	OpenReservationsIsCleared	Clear Open Reservations
	ConfirmationText	I_MaintenanceOrderConfTP	ConfirmationText
	VarianceReasonCode	I_MaintenanceOrderConfTP	VarianceReasonCode	Reason for Variance
	PersonFullName	_PersonnelName	PersonFullName
	PersonnelNumber	I_MaintenanceOrderConfTP	PersonnelNumber	Employee
	WorkCenter	I_MaintenanceOrderConfTP	WorkCenter	Work Center
	MaintOrdConfSourceApplication		MaintOrdConfSourceApplication
	MaintOrdConfUploadUUID		MaintOrdConfUploadUUID
	MaintOrderConfUploadMsgType		MaintOrderConfUploadMsgType
	MaintOrdConfUploadMsgCritlty		MaintOrdConfUploadMsgCritlty
	SystemMessageText
	MaintOrderConfUploadRowNumber		MaintOrderConfUploadRowNumber
	NumberOfRecords
	_MaintOrderOperationTP		_MaintOrderOperationTP
	_ActualWorkUnit		_ActualWorkUnit
	_MaintenanceOrder		_MaintenanceOrder
	_PersonnelName		_PersonnelName
	_MaintOrdConfMessageTP		_MaintOrdConfMessageTP

@AbapCatalog.sqlViewName: 'CMAINORDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption View for Maintenance Order Confirmation Create'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@ObjectModel: {
compositionRoot: true,
transactionalProcessingDelegated: true,
draftEnabled: true,
updateEnabled: true}

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@UI.headerInfo:{
  typeName:       'Confirmation',
  typeNamePlural: 'Confirmations'
}

define view C_MaintOrdConfForCreateTP
  as select from I_MaintenanceOrderConfTP
  association [0..1] to C_MaintOrderOperationTP as _MaintOrderOperationTP on  _MaintOrderOperationTP.MaintenanceOrder          = $projection.MaintenanceOrder
                                                                          and _MaintOrderOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
  association [0..1] to I_PMTimeUnitVH          as _ActualWorkUnit        on  _ActualWorkUnit.UnitOfMeasure = $projection.ActualWorkQuantityUnit
  association [1..*] to C_MaintOrdConfMessageTP as _MaintOrdConfMessageTP on
                                                                              //  _MaintOrdConfMessageTP.MaintenanceOrder          = $projection.MaintenanceOrder

                                                                              //                                                                             and _MaintOrdConfMessageTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation

                                                                              _MaintOrdConfMessageTP.MaintOrderConf          = $projection.MaintOrderConf
                                                                          and _MaintOrdConfMessageTP.MaintOrderConfCntrValue = $projection.MaintOrderConfCntrValue

//  association [0..1] to I_WorkforcePerson       as _PersonnelName         on  $projection.PersonnelNumber = _PersonnelName.PersonExternalID

association [0..1] to I_PersonWorkAgreement_1       as _PersonnelName         on  $projection.PersonnelNumber = _PersonnelName.PersonWorkAgreement

  //  association [0..1] to I_MaintenanceOrderOperation as _MaintenanceOrderOperation on  _MaintenanceOrderOperation.MaintenanceOrder           = $projection.MaintenanceOrder

  //                                                                                  and _MaintenanceOrderOperation.MaintOrderOperationCounter = $projection.MaintOrderOperationCounter


{
           @UI.lineItem: [{position: 10 }]
           @EndUserText.label: 'Confirmation'
  key      I_MaintenanceOrderConfTP.MaintOrderConf,
           @UI.hidden: true
  key      I_MaintenanceOrderConfTP.MaintOrderConfCntrValue,

           @UI.lineItem: [{position: 20 }]
           @EndUserText.label: 'Order'
           @ObjectModel.text.element: [ 'MaintenanceOrderDesc' ]
           @Consumption.semanticObject: 'MaintenanceOrder'
           I_MaintenanceOrderConfTP.MaintenanceOrder,

           @ObjectModel.readOnly: true
           @UI.hidden: true
           _MaintenanceOrder.MaintenanceOrderDesc,

           @UI.lineItem: [{position: 30 }]
           @EndUserText.label: 'Operation'
           //@ObjectModel.text.element: ['OperationDescription']

           I_MaintenanceOrderConfTP.MaintenanceOrderOperation,

           //           @Semantics.text: true

           @ObjectModel.readOnly: true
           I_MaintenanceOrderConfTP.OperationDescription,

           @UI.hidden: true
           I_MaintenanceOrderConfTP.MaintOrderOperationCounter,

           @UI.lineItem: [{position: 40 }]
           @EndUserText.label: 'Suboperation'
           I_MaintenanceOrderConfTP.MaintenanceOrderSubOperation,

           @UI.lineItem: [{position: 50 }]
           @EndUserText.label: 'Activity Type'
           I_MaintenanceOrderConfTP.ActivityType,

           @UI.hidden: true
           I_MaintenanceOrderConfTP.MaintOrderConfForEdit,

           @UI.hidden: true
           I_MaintenanceOrderConfTP.MaintOrderConfCntrValueForEdit,

           @Semantics.quantity.unitOfMeasure: 'ActualWorkQuantityUnit'
           @UI.lineItem: [{position: 90 }]
           @EndUserText.label: 'Actual Work'
           I_MaintenanceOrderConfTP.ActualWorkQuantity,

           @Semantics.unitOfMeasure: true
           @ObjectModel.foreignKey.association: '_ActualWorkUnit'
           I_MaintenanceOrderConfTP.ActualWorkQuantityUnit,

           @UI.lineItem: [{position: 70 }]
           @EndUserText.label: 'Posting Date'
           I_MaintenanceOrderConfTP.PostingDate,

           @UI.lineItem: [{position: 80 }]
           @EndUserText.label: 'Final Confirmation'
           @EndUserText.quickInfo: 'Final Confirmation'
           I_MaintenanceOrderConfTP.IsFinalConfirmation,

           I_MaintenanceOrderConfTP.RemainingWorkQuantity,

           @EndUserText.label: 'Unit of Measure for Remaining Work'
           I_MaintenanceOrderConfTP.RemainingWorkQuantityUnit,

           I_MaintenanceOrderConfTP.Plant,

           @EndUserText.label: 'Plant Time Zone'
           @Consumption.filter.hidden: true
           @ObjectModel.readOnly: true
           I_MaintenanceOrderConfTP.AddressTimeZone,

           @EndUserText.label: 'Forecast End Date'
           @Consumption.hidden: true
           I_MaintenanceOrderConfTP.ActyConfFcstdEndDate,

           @EndUserText.label: 'Forecast End Time'
           @Consumption.hidden: true
           I_MaintenanceOrderConfTP.ActyConfFcstdEndTime,

           @EndUserText.label: 'Forecast End'
           @Semantics.dateTime: true
           @Consumption.filter.selectionType: #INTERVAL
           @Semantics.timeZoneReference: 'AddressTimeZone'
           //@ObjectModel.readOnly: true

           MaintOrdOpFcstdEndDateTime,


           @EndUserText.label: 'Start Date'
           @Consumption.hidden: true
           I_MaintenanceOrderConfTP.OperationConfirmedStartDate,

           @EndUserText.label: 'Start Time'
           @Consumption.hidden: true
           I_MaintenanceOrderConfTP.OperationConfirmedStartTime,

           @EndUserText.label: 'Start Date and Time'
           @EndUserText.quickInfo:'Execution Start Date and Time'
           @Semantics.dateTime: true
           @Consumption.filter.selectionType: #INTERVAL
           @Semantics.timeZoneReference: 'AddressTimeZone'
           //@ObjectModel.readOnly: true

           MaintOrdOpWrkExecStartDateTime,


           @EndUserText.label: 'End Date'
           @Consumption.hidden: true
           I_MaintenanceOrderConfTP.OperationConfirmedEndDate,

           @EndUserText.label: 'End Time'
           @Consumption.hidden: true
           I_MaintenanceOrderConfTP.OperationConfirmedEndTime,

           @EndUserText.label: 'End Date and Time'
           @EndUserText.quickInfo:'Execution End Date and Time'
           @Semantics.dateTime: true
           @Consumption.filter.selectionType: #INTERVAL
           @Semantics.timeZoneReference: 'AddressTimeZone'
           //@ObjectModel.readOnly: true

           MaintOrdOpWrkExecEndDateTime,


           @EndUserText.label: 'No Remaining Work Expected'
           I_MaintenanceOrderConfTP.NoFurtherWorkQuantityIsExpd,

           @EndUserText.label: 'Clear Open Reservations'
           I_MaintenanceOrderConfTP.OpenReservationsIsCleared,

           I_MaintenanceOrderConfTP.ConfirmationText,

           @EndUserText.label: 'Reason for Variance'
           I_MaintenanceOrderConfTP.VarianceReasonCode,

           @UI.hidden: true
           @ObjectModel.readOnly: true
           _PersonnelName.PersonFullName,

           @UI.lineItem: [{position: 60 }]
           @EndUserText.label: 'Employee'
           @ObjectModel.text.element: ['PersonFullName']
           I_MaintenanceOrderConfTP.PersonnelNumber,

           @EndUserText.label: 'Work Center'
           @ObjectModel.readOnly: true
           I_MaintenanceOrderConfTP.WorkCenter,


           @UI.hidden: true
           MaintOrdConfSourceApplication,

           @UI.hidden: true
           MaintOrdConfUploadUUID,

           @UI.hidden: true
           MaintOrderConfUploadMsgType,

           @UI.hidden: true
           @ObjectModel.readOnly: true
           @ObjectModel.virtualElement : true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EAM_ORDCONF_MSG_EXIT'
           MaintOrdConfUploadMsgCritlty,

           @ObjectModel.virtualElement : true
           @ObjectModel.readOnly: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EAM_ORDCONF_MSG_EXIT'
           @UI.hidden: true
           //                      @UI.lineItem: [{position: 10,

           //                      criticality: 'StatusCriticality',

           //                      criticalityRepresentation: #WITH_ICON }]

           //                      @EndUserText.label: 'Validation Status'

           cast('' as abap.char( 300 )) as SystemMessageText,

           @ObjectModel.readOnly: true
           @UI.hidden: true
           MaintOrderConfUploadRowNumber,

           @UI.hidden: true
           @ObjectModel.virtualElement : true
           @ObjectModel.readOnly: true
           @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EAM_ORDCONF_MSG_EXIT'
           cast( 0 as abap.int1)        as NumberOfRecords,

           //Associations

           _MaintOrderOperationTP,
           //   _MaintenanceOrderOperation,

           _ActualWorkUnit,
           _MaintenanceOrder,
           _PersonnelName,
           @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
           _MaintOrdConfMessageTP
}
where
  // I_MaintenanceOrderConfTP.MaintOrdConfSourceApplication = 'F3925'

  EnteredByUser = $session.user

Depth:

C_MaintOrdConfForCreateTP view

I_MaintenanceOrderConfTP view