P_ARProcessFlowServiceContract

DDL: P_ARPROCESSFLOWSERVICECONTRACT Type: view_entity COMPOSITE

Service Contract Attributes

P_ARProcessFlowServiceContract is a Composite CDS View that provides data about "Service Contract Attributes" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocument) and exposes 40 fields with key field ServiceDocument. It has 4 associations to related views.

1 data source(s) 40 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ServiceDocument _ServiceDocument $projection.ServiceDocument = _ServiceDocument.ServiceDocument and $projection.ServiceObjectType = _ServiceDocument.ServiceObjectType
[0..*] I_ServiceDocumentItem _Item $projection.ServiceDocument = _Item.ServiceDocument and $projection.ServiceObjectType = _Item.ServiceObjectType
[1..1] I_UserContactCard _UserContactCard $projection.ServiceDocumentCreatedByUser = _UserContactCard.ContactCardID
[0..1] I_SDDocumentCategory _SDDocumentCategory _SDDocumentCategory.SDDocumentCategory = 'CSCT'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Service Contract Attributes view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument I_ServiceDocument ServiceDocument
ServiceObjectType I_ServiceDocument ServiceObjectType
ServiceDocumentStatus I_ServiceDocument ServiceDocumentStatus
ServiceDocNetAmount I_ServiceDocument ServiceDocNetAmount
ServiceDocGrossAmount I_ServiceDocument ServiceDocGrossAmount
TransactionCurrency I_ServiceDocument TransactionCurrency
ServiceDocumentCreationDate
SoldToParty I_ServiceDocument SoldToParty
PurchaseOrderByCustomer I_ServiceDocument PurchaseOrderByCustomer
FullName _UserContactCard FullName
SalesOrganization I_ServiceDocument SalesOrganization
DistributionChannel I_ServiceDocument DistributionChannel
DistributionChannelName
Division I_ServiceDocument Division
ServiceDocumentStatusName
CustomerName
CustomerFullName
SalesOrganizationName
DivisionName
PaymentTermsName
Divisionastxt_vtrberasSalesArea
DivisionName1astxt_vtrberasSalesAreaDesc
ServiceDocumentCreatedByUser I_ServiceDocument ServiceDocumentCreatedByUser
ServiceDocCreationDateTime I_ServiceDocument ServiceDocCreationDateTime
ServiceContractStartDate
ServiceContractEndDate
PaymentTerms I_ServiceDocument PaymentTerms
SDDocumentCategory _SDDocumentCategory SDDocumentCategory
SDDocumentCategoryName
_ServiceDocument _ServiceDocument
_SoldToParty _SoldToParty
_SoldToPartyToCustomer _SoldToPartyToCustomer
_TransactionCurrency _TransactionCurrency
_PaymentTerms _PaymentTerms
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus
_ServiceObjType _ServiceObjType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_Item _Item 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #XXL,
  dataClass: #MIXED }

@VDM: {
  viewType: #COMPOSITE,
  private:true
}
@EndUserText.label: 'Service Contract Attributes'
define view entity P_ARProcessFlowServiceContract
  as select from I_ServiceDocument

  association [1..1] to I_ServiceDocument     as _ServiceDocument    on  $projection.ServiceDocument   = _ServiceDocument.ServiceDocument
                                                                     and $projection.ServiceObjectType = _ServiceDocument.ServiceObjectType

  association [0..*] to I_ServiceDocumentItem as _Item               on  $projection.ServiceDocument   = _Item.ServiceDocument
                                                                     and $projection.ServiceObjectType = _Item.ServiceObjectType

  association [1..1] to I_UserContactCard     as _UserContactCard    on  $projection.ServiceDocumentCreatedByUser = _UserContactCard.ContactCardID

  association [0..1] to I_SDDocumentCategory  as _SDDocumentCategory on  _SDDocumentCategory.SDDocumentCategory = 'CSCT'

{
  key I_ServiceDocument.ServiceDocument,
      I_ServiceDocument.ServiceObjectType,
      I_ServiceDocument.ServiceDocumentStatus,
      I_ServiceDocument.ServiceDocNetAmount,
      I_ServiceDocument.ServiceDocGrossAmount,
      I_ServiceDocument.TransactionCurrency,
      tstmp_to_dats(I_ServiceDocument.ServiceDocCreationDateTime , $session.user_timezone, $session.client, 'NULL')                               as ServiceDocumentCreationDate,
      I_ServiceDocument.SoldToParty,
      I_ServiceDocument.PurchaseOrderByCustomer,
      _UserContactCard.FullName,
      I_ServiceDocument.SalesOrganization,

      I_ServiceDocument.DistributionChannel,
      I_ServiceDocument._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName,
      I_ServiceDocument.Division,
      I_ServiceDocument._ServiceDocumentStatus._ServiceDocumentStatusText[1:Language = $session.system_language].ServiceDocumentStatusName        as ServiceDocumentStatusName,
      I_ServiceDocument._SoldToParty.BusinessPartnerName                                                                                          as CustomerName,
      I_ServiceDocument._SoldToParty.BusinessPartnerFullName                                                                                      as CustomerFullName,
      I_ServiceDocument._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName,
      I_ServiceDocument._Division._Text[1:Language = $session.system_language].DivisionName,
      I_ServiceDocument._PaymentTerms._Text[1:Language = $session.system_language].PaymentTermsName,

      cast(
        concat(
            concat(
                concat(
                    concat(
                        I_ServiceDocument.SalesOrganization,
                            '/'),
                                I_ServiceDocument.DistributionChannel),
                                    '/'),
                                        I_ServiceDocument.Division) as txt_vtrber )                                                               as SalesArea,

      cast(
        concat_with_space(
            concat(
                concat_with_space(
                    concat(
                        I_ServiceDocument._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName,
                            ','),
                                cast(I_ServiceDocument._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName as vtxtk), 1),
                                    ','),
                                        I_ServiceDocument._Division._Text[1:Language = $session.system_language].DivisionName, 1) as txt_vtrber ) as SalesAreaDesc,

      I_ServiceDocument.ServiceDocumentCreatedByUser,
      I_ServiceDocument.ServiceDocCreationDateTime,
      tstmp_to_dats(I_ServiceDocument.ServiceContractStartDateTime, $session.user_timezone, $session.client, 'NULL')                              as ServiceContractStartDate,
      tstmp_to_dats(I_ServiceDocument.ServiceContractEndDateTime, $session.user_timezone, $session.client, 'NULL')                                as ServiceContractEndDate,
      I_ServiceDocument.PaymentTerms,

      _SDDocumentCategory.SDDocumentCategory,
      _SDDocumentCategory._Text[1:Language = $session.system_language].SDDocumentCategoryName,

      _ServiceDocument,
      _SoldToParty,
      _SoldToPartyToCustomer,
      _TransactionCurrency,
      _PaymentTerms,
      _SrvcDocLifecycleStatus,
      _ServiceObjType,
      _SalesOrganization,
      _DistributionChannel,
      _Division,
      _Item
}
where
      ServiceObjectType           = 'BUS2000112'
  and ServiceDocumentTemplateType = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_DISTRIBUTIONCHANNEL",
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISION",
"I_DIVISIONTEXT",
"I_PAYMENTTERMS",
"I_PAYMENTTERMSTEXT",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONTEXT",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTCATEGORYTEXT",
"I_SERVICEDOCUMENT",
"I_SERVICEDOCUMENTSTATUS",
"I_SERVICEDOCUMENTSTATUSTEXT",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERCUSTOMER",
"I_CURRENCY",
"I_CUSTMGMTBUSOBJTYPE",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_PAYMENTTERMS",
"I_SALESORGANIZATION",
"I_SERVICEDOCUMENT",
"I_SERVICEDOCUMENTITEM",
"I_SRVCDOCLIFECYCLESTATUS"
],
"BASE":
[
"I_SERVICEDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More