P_MaintOrderConfirmationSearch

DDL: P_MAINTORDERCONFIRMATIONSEARCH SQL: PMAINTCONFSEARCH Type: view BASIC

P_MaintOrderConfirmationSearch is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderConfirmation) and exposes 65 fields with key fields MaintOrderConf, MaintOrderConfCntrValue. It has 1 association to related views.

1 data source(s) 65 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderConfirmation I_MaintenanceOrderConfirmation from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OrderConfLongText _LongText $projection.MaintOrderConf = _LongText.ConfirmationGroup and $projection.MaintOrderConfCntrValue = _LongText.OrderConfirmation

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMAINTCONFSEARCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.representativeKey MaintOrderConfCntrValue view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderConf MaintOrderConf
KEY MaintOrderConfCntrValue MaintOrderConfCntrValue
MaintOrderConfirmationEntryDte MaintOrderConfirmationEntryDte
MaintOrderOperationCounter MaintOrderOperationCounter
EnteredByUser EnteredByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
PostingDate PostingDate
WorkCenterInternalID WorkCenterInternalID
ConfirmationText ConfirmationText
Language Language
LongTextExists LongTextExists
ActualWorkQuantity ActualWorkQuantity
ActualWorkQuantityUnit ActualWorkQuantityUnit
ActivityType ActivityType
ActualDuration ActualDuration
ActualDurationUnit ActualDurationUnit
EmployeeWageType EmployeeWageType
ConfirmationYieldQuantity ConfirmationYieldQuantity
ConfirmationScrapQuantity ConfirmationScrapQuantity
ConfirmationUnit ConfirmationUnit
VarianceReasonCode VarianceReasonCode
PersonnelNumber PersonnelNumber
OperationConfirmedStartDate OperationConfirmedStartDate
OperationConfirmedStartTime OperationConfirmedStartTime
OperationConfirmedEndDate OperationConfirmedEndDate
OperationConfirmedEndTime OperationConfirmedEndTime
ActyConfFcstdEndDate ActyConfFcstdEndDate
ActyConfFcstdEndTime ActyConfFcstdEndTime
IsFinalConfirmation IsFinalConfirmation
OpenReservationsIsCleared OpenReservationsIsCleared
MaintenanceOrder MaintenanceOrder
MaintenanceOrderOperation MaintenanceOrderOperation
MaintenanceOrderSubOperation MaintenanceOrderSubOperation
RemainingWorkQuantity RemainingWorkQuantity
RemainingWorkQuantityUnit RemainingWorkQuantityUnit
NoFurtherWorkQuantityIsExpd NoFurtherWorkQuantityIsExpd
IsReversed IsReversed
IsReversal IsReversal
ConfirmationReworkQuantity ConfirmationReworkQuantity
MaintOrderConfirmationEntryTme MaintOrderConfirmationEntryTme
AccountingIndicatorCode AccountingIndicatorCode
EnteredByExternalUser EnteredByExternalUser
ConfirmationExternalEntryDate ConfirmationExternalEntryDate
ConfirmationExternalEntryTime ConfirmationExternalEntryTime
Plant Plant
FactoryCalendar FactoryCalendar
PlainLongText _LongText PlainLongText
_ActualWorkCenter _ActualWorkCenter
_ConfirmationGroup _ConfirmationGroup
_EnteredByUser _EnteredByUser
_IsFinalConfirmation _IsFinalConfirmation
_IsReversal _IsReversal
_IsReversed _IsReversed
_Language _Language
_LastChangeByUser _LastChangeByUser
_LongTextExists _LongTextExists
_MaintenanceOrder _MaintenanceOrder
_MaintenanceOrderOperation _MaintenanceOrderOperation
_MaintOrderConfGoodsMovement _MaintOrderConfGoodsMovement
_NoFurtherWorkQuantityIsExpd _NoFurtherWorkQuantityIsExpd
_OpenReservationsIsCleared _OpenReservationsIsCleared
_PersonnelName _PersonnelName
_Plant _Plant
_VarianceReason _VarianceReason 
//Anchor View for Maintenance Order Confirmation Search Model

@AbapCatalog.sqlViewName: 'PMAINTCONFSEARCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MaintOrderConfCntrValue'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_MaintOrderConfirmationSearch as select from I_MaintenanceOrderConfirmation 
association [0..*] to I_OrderConfLongText as _LongText                  on  $projection.MaintOrderConf          = _LongText.ConfirmationGroup
                                                                        and $projection.MaintOrderConfCntrValue = _LongText.OrderConfirmation
{   
    key MaintOrderConf, 
    key MaintOrderConfCntrValue, 
    MaintOrderConfirmationEntryDte, 
    MaintOrderOperationCounter, 
    EnteredByUser, 
    LastChangeDate, 
    LastChangedByUser, 
    PostingDate, 
    WorkCenterInternalID, 
    ConfirmationText, 
    Language, 
    LongTextExists, 
    ActualWorkQuantity, 
    ActualWorkQuantityUnit, 
    ActivityType, 
    ActualDuration, 
    ActualDurationUnit, 
    EmployeeWageType, 
    ConfirmationYieldQuantity, 
    ConfirmationScrapQuantity, 
    ConfirmationUnit, 
    VarianceReasonCode, 
    PersonnelNumber, 
    OperationConfirmedStartDate, 
    OperationConfirmedStartTime, 
    OperationConfirmedEndDate, 
    OperationConfirmedEndTime, 
    ActyConfFcstdEndDate, 
    ActyConfFcstdEndTime, 
    IsFinalConfirmation, 
    OpenReservationsIsCleared, 
    MaintenanceOrder, 
    MaintenanceOrderOperation, 
    MaintenanceOrderSubOperation, 
    RemainingWorkQuantity, 
    RemainingWorkQuantityUnit, 
    NoFurtherWorkQuantityIsExpd, 
    IsReversed, 
    IsReversal, 
    ConfirmationReworkQuantity, 
    MaintOrderConfirmationEntryTme, 
    AccountingIndicatorCode, 
    EnteredByExternalUser, 
    ConfirmationExternalEntryDate, 
    ConfirmationExternalEntryTime, 
    Plant, 
    FactoryCalendar, 
    _LongText.PlainLongText,
    /* Associations */ 
    //I_MaintenanceOrderConfirmation 

    _ActualWorkCenter, 
    _ConfirmationGroup, 
    _EnteredByUser, 
    _IsFinalConfirmation, 
    _IsReversal, 
    _IsReversed, 
    _Language, 
    _LastChangeByUser, 
    _LongTextExists, 
    _MaintenanceOrder, 
    _MaintenanceOrderOperation, 
    _MaintOrderConfGoodsMovement, 
    _NoFurtherWorkQuantityIsExpd, 
    _OpenReservationsIsCleared, 
    _PersonnelName, 
    _Plant, 
    _VarianceReason
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDERCONFIRMATION",
"I_ORDERCONFLONGTEXT"
],
"ASSOCIATED":
[
"I_CONFIRMATIONGROUP",
"I_INDICATOR",
"I_LANGUAGE",
"I_MAINTENANCEORDER",
"I_MAINTENANCEORDEROPERATION",
"I_MAINTORDERCONFGOODSMOVEMENT",
"I_ORDERCONFLONGTEXT",
"I_PLANT",
"I_USER",
"I_VARIANCEREASON",
"I_WORKCENTER",
"I_WORKFORCEPERSON"
],
"BASE":
[
"I_MAINTENANCEORDERCONFIRMATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More