A_ServiceConfirmation

DDL: A_SERVICECONFIRMATION Type: view COMPOSITE

Service Confirmation

A_ServiceConfirmation is a Composite CDS View that provides data about "Service Confirmation" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentEnhcd) and exposes 44 fields with key field ServiceConfirmation. It has 13 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentEnhcd ServiceConfirmation from

Associations (13)

CardinalityTargetAliasCondition
[0..*] A_ServiceConfirmationItem _Item $projection.ServiceConfirmation = _Item.ServiceConfirmation
[0..*] A_ServiceConfPersonResp _PersonResponsible $projection.ServiceConfirmation = _PersonResponsible.ServiceConfirmation
[0..*] A_ServiceConfRefObject _ReferenceObject $projection.ServiceConfirmation = _ReferenceObject.ServiceConfirmation
[0..*] A_ServiceConfirmationText _Text $projection.ServiceConfirmation = _Text.ServiceConfirmation
[0..1] I_StatusObjectUUIDStatus _StatusCancelled $projection.ServiceConfirmationUUID = _StatusCancelled.StatusObjectUUID and _StatusCancelled.StatusCode = 'I1096'
[0..*] I_ServiceDocumentPredecessor _RefServiceOrder $projection.ServiceConfirmationUUID = _RefServiceOrder.ServiceDocumentUUID and _RefServiceOrder.ServiceDocPrdcssrBusObjType = 'BUS2000116'
[0..*] A_ServiceConfPriceElement _PricingElement $projection.ServiceConfirmation = _PricingElement.ServiceConfirmation
[0..1] I_RespyMgmtTeamHeaderDetail _ServiceTeamHeader $projection.RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID
[0..1] E_ServiceDocument _Extension _Extension.ServiceCategory = 'BUS2000117' and $projection.ServiceConfirmation = _Extension.ServiceOrder
[0..*] A_ServiceConfUserStatus _ServiceConfUserStatus $projection.ServiceConfirmation = _ServiceConfUserStatus.ServiceConfirmation
[0..*] A_SrvcConfPartner _Partner $projection.ServiceConfirmation = _Partner.ServiceConfirmation
[0..*] A_SrvcConfDuration _Duration $projection.ServiceConfirmation = _Duration.ServiceConfirmation
[0..*] A_SrvcConfAppointment _Appointment $projection.ServiceConfirmation = _Appointment.ServiceConfirmation

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Service Confirmation view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ASRVCON view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ServiceConfirmation view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.ignorePropagatedAnnotations true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY ServiceConfirmation ServiceDocument
ServiceConfirmationType ServiceDocumentType
ServiceConfirmationUUID ServiceDocumentUUID
ServiceConfirmationDescription ServiceDocumentDescription
ServiceObjectType ServiceObjectType
Language Language
ServiceDocumentPriority ServiceDocumentPriority
RequestedServiceStartDateTime RequestedServiceStartDateTime
RequestedServiceEndDateTime RequestedServiceEndDateTime
ErlstRequestedDeliveryDateTime ErlstRequestedDeliveryDateTime
PurchaseOrderByCustomer PurchaseOrderByCustomer
CustomerPurchaseOrderDate CustomerPurchaseOrderDate
ServiceConfirmationIsCanceled _StatusCancelled StatusIsActive
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Division Division
SalesOffice SalesOffice
SalesGroup SalesGroup
SoldToParty SoldToParty
ShipToParty ShipToParty
BillToParty BillToParty
PayerParty PayerParty
ContactPerson ContactPerson
ReferenceServiceOrder
ServiceConfirmationIsFinal ServiceConfirmationIsFinal
TransactionCurrency TransactionCurrency
ShippingCondition ShippingCondition
RespyMgmtServiceTeam RespyMgmtServiceTeam
RespyMgmtServiceTeamName _ServiceTeamHeader TeamName
RespyMgmtGlobalTeamID _ServiceTeamHeader RespyMgmtGlobalTeamID
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
ServiceOrganization ServiceOrganization
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
EnterpriseServiceOrganization EnterpriseServiceOrganization
_Item _Item
_PersonResponsible _PersonResponsible
_ReferenceObject _ReferenceObject
_Text _Text
_PricingElement _PricingElement
_ServiceConfUserStatus _ServiceConfUserStatus
_Partner _Partner
_Duration _Duration
_Appointment _Appointment
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Service Confirmation'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ASRVCON',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
  //,

  // _StatusCancelled association is changed to PRIVILEGED_ONLY

  //privilegedAssociations: ['_StatusCancelled']

}
@ObjectModel: {
   representativeKey: 'ServiceConfirmation',
   createEnabled: true,
   updateEnabled: true,
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #C,
     sizeCategory:   #XXL
   }
}
@Metadata.ignorePropagatedAnnotations: true


define view A_ServiceConfirmation
  as select from I_ServiceDocumentEnhcd as ServiceConfirmation

  association [0..*] to A_ServiceConfirmationItem    as _Item                  on  $projection.ServiceConfirmation = _Item.ServiceConfirmation

  association [0..*] to A_ServiceConfPersonResp      as _PersonResponsible     on  $projection.ServiceConfirmation = _PersonResponsible.ServiceConfirmation

  association [0..*] to A_ServiceConfRefObject       as _ReferenceObject       on  $projection.ServiceConfirmation = _ReferenceObject.ServiceConfirmation

  association [0..*] to A_ServiceConfirmationText    as _Text                  on  $projection.ServiceConfirmation = _Text.ServiceConfirmation

  association [0..1] to I_StatusObjectUUIDStatus     as _StatusCancelled       on  $projection.ServiceConfirmationUUID = _StatusCancelled.StatusObjectUUID
                                                                               and _StatusCancelled.StatusCode         = 'I1096'

  association [0..*] to I_ServiceDocumentPredecessor as _RefServiceOrder       on  $projection.ServiceConfirmationUUID          = _RefServiceOrder.ServiceDocumentUUID
                                                                               and _RefServiceOrder.ServiceDocPrdcssrBusObjType = 'BUS2000116'

  association [0..*] to A_ServiceConfPriceElement    as _PricingElement        on  $projection.ServiceConfirmation = _PricingElement.ServiceConfirmation

  association [0..1] to I_RespyMgmtTeamHeaderDetail  as _ServiceTeamHeader     on  $projection.RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID

  //Extensibility

  association [0..1] to E_ServiceDocument            as _Extension             on  _Extension.ServiceCategory      = 'BUS2000117'
                                                                               and $projection.ServiceConfirmation = _Extension.ServiceOrder

  association [0..*] to A_ServiceConfUserStatus      as _ServiceConfUserStatus on  $projection.ServiceConfirmation = _ServiceConfUserStatus.ServiceConfirmation

  association [0..*] to A_SrvcConfPartner            as _Partner               on  $projection.ServiceConfirmation = _Partner.ServiceConfirmation

  association [0..*] to A_SrvcConfDuration           as _Duration              on  $projection.ServiceConfirmation = _Duration.ServiceConfirmation

  association [0..*] to A_SrvcConfAppointment        as _Appointment           on  $projection.ServiceConfirmation = _Appointment.ServiceConfirmation

{

  key  ServiceDocument                              as ServiceConfirmation,
       @ObjectModel.sapObjectNodeTypeReference: 'ServiceDocumentType'
       ServiceDocumentType                          as ServiceConfirmationType,
       ServiceDocumentUUID                          as ServiceConfirmationUUID,
       ServiceDocumentDescription                   as ServiceConfirmationDescription,
       ServiceObjectType,
       Language,
       @ObjectModel.sapObjectNodeTypeReference: 'ServiceDocumentPriority'
       ServiceDocumentPriority,
       RequestedServiceStartDateTime,
       RequestedServiceEndDateTime,
       ErlstRequestedDeliveryDateTime,

       PurchaseOrderByCustomer,
       CustomerPurchaseOrderDate,

       /* STATUS */
       //case ServiceDocumentStatus

       //when 'C' then 'X'

       //else ''

       //end                                          as ServiceConfirmationIsCompleted,


       case ServiceDocumentIsOpen
       when '' then
       case ServiceDocumentIsReleased
       when '' then 'X' else ''
       end
       else ''
       end                                          as ServiceConfirmationIsCompleted,

       _StatusCancelled.StatusIsActive              as ServiceConfirmationIsCanceled,

       //ServiceConfirmationIsFinal


       /* ORG */
       SalesOrganization,
       DistributionChannel,
       @ObjectModel.sapObjectNodeTypeReference: 'Division'
       Division,
       SalesOffice,
       SalesGroup,

       /* PARTNER */
       SoldToParty,
       ShipToParty,
       BillToParty,
       PayerParty,
       ContactPerson,

       _RefServiceOrder._ServiceDoc.ServiceDocument as ReferenceServiceOrder,

       ServiceConfirmationIsFinal,
       @ObjectModel.sapObjectNodeTypeReference: 'Currency'
       TransactionCurrency,

       /* Shipping */
       ShippingCondition,

       /********************************************************/
       /*********  Cloud Specific Fields **************************/
       //Service Team

       //@ObjectModel.editableFieldFor: 'RespyMgmtServiceTeamName'

       //@feature: 'BF:API_ESSENTIALSCOPE'

       RespyMgmtServiceTeam,

       //@feature: 'BF:API_ESSENTIALSCOPE'

       @ObjectModel.readOnly: true
       _ServiceTeamHeader.TeamName                  as RespyMgmtServiceTeamName,

       //@feature: 'BF:API_ESSENTIALSCOPE'

       _ServiceTeamHeader.RespyMgmtGlobalTeamID     as RespyMgmtGlobalTeamID,

       /********************************************************/

       /********************************************************/
       /*********  OP Specific Fields **************************/
       //@feature: 'BF:API_FULLSCOPE'

       SalesOrganizationOrgUnitID,

       //@feature: 'BF:API_FULLSCOPE'

       ServiceOrganization,

       //@feature: 'BF:API_FULLSCOPE'

       SalesOfficeOrgUnitID,

       //@feature: 'BF:API_FULLSCOPE'

       SalesGroupOrgUnitID,

       @Feature: 'BF:API_FULLSCOPE'
       @ObjectModel.sapObjectNodeTypeReference: 'EnterpriseServiceOrganization'
       EnterpriseServiceOrganization,
       /********************************************************/

       //Associations

       _Item,
       _PersonResponsible,
       _ReferenceObject,
       _Text,
       _PricingElement,
       _ServiceConfUserStatus,
       //@Feature: 'BF:API_FULLSCOPE'

       _Partner,
       _Duration,
       _Appointment
}
where
  ServiceObjectType = 'BUS2000117' // Service Confirmation

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESPYMGMTTEAMHEADERDETAIL",
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTPREDECESSOR",
"I_STATUSOBJECTUUIDSTATUS"
],
"ASSOCIATED":
[
"A_SERVICECONFIRMATIONITEM",
"A_SERVICECONFIRMATIONTEXT",
"A_SERVICECONFPERSONRESP",
"A_SERVICECONFPRICEELEMENT",
"A_SERVICECONFREFOBJECT",
"A_SERVICECONFUSERSTATUS",
"A_SRVCCONFAPPOINTMENT",
"A_SRVCCONFDURATION",
"A_SRVCCONFPARTNER",
"E_SERVICEDOCUMENT",
"I_RESPYMGMTTEAMHEADERDETAIL",
"I_SERVICEDOCUMENTPREDECESSOR",
"I_STATUSOBJECTUUIDSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/