C_SerialNumberHistoryPartner

DDL: C_SERIALNUMBERHISTORYPARTNER Type: view_entity CONSUMPTION

Partner Detail for Serial Number History

C_SerialNumberHistoryPartner is a Consumption CDS View that provides data about "Partner Detail for Serial Number History" in SAP S/4HANA. It reads from 1 data source (I_PlantMaintenancePartner) and exposes 9 fields with key fields MaintObjectInternalID, PartnerFunction, MaintenancePartnerObjectNumber. It has 2 associations to related views. It is exposed through 1 OData service (UI_SERIALNUMBER_HISTORY_V4).

1 data source(s) Exposed by 1 service(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_PlantMaintenancePartner I_PlantMaintenancePartner from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer _Customer.Customer = $projection.MaintenancePartner
[1..1] I_PartnerFunctionText _PartnerFunctionText $projection.PartnerFunction = _PartnerFunctionText.PartnerFunction and _PartnerFunctionText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Partner Detail for Serial Number History view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SERIALNUMBER_HISTORY_V4 UI_SERIALNUMBER_HISTORY_V4 V4 C1 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintObjectInternalID MaintObjectInternalID
KEY PartnerFunction
KEY MaintenancePartnerObjectNumber MaintenancePartnerObjectNumber
MaintObjectCategory MaintObjectCategory
MaintenancePartner MaintenancePartner Business Partner
CustomerName _Customer CustomerName
CountryasCompleteAddress Address
PartnerFunctionName _PartnerFunctionText PartnerFunctionName
_Customer _Customer 
@AccessControl: { authorizationCheck: #NOT_REQUIRED,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #C,
        sizeCategory:   #XL }
@ObjectModel.supportedCapabilities: [
  #SQL_DATA_SOURCE,
  #CDS_MODELING_DATA_SOURCE,
  #CDS_MODELING_ASSOCIATION_TARGET
]
@EndUserText.label: 'Partner Detail for Serial Number History'

define view entity C_SerialNumberHistoryPartner
  as select from I_PlantMaintenancePartner
  association [0..1] to I_Customer            as _Customer            on  _Customer.Customer = $projection.MaintenancePartner
  association [1..1] to I_PartnerFunctionText as _PartnerFunctionText on  $projection.PartnerFunction   = _PartnerFunctionText.PartnerFunction
                                                                      and _PartnerFunctionText.Language = $session.system_language
{
      @UI.hidden: true
  key MaintObjectInternalID,
      @UI.hidden: true
  key cast(PartnerFunction as parvw_unv preserving type ) as PartnerFunction,
      @UI.hidden: true
  key MaintenancePartnerObjectNumber,
      @UI.hidden: true
      MaintObjectCategory,
      @UI.lineItem: [{ position: 20 }]
      @ObjectModel.text.element: ['CustomerName']
      @EndUserText.label: 'Business Partner'
      MaintenancePartner,
      @UI.hidden: true
      _Customer.CustomerName,
      @EndUserText.label: 'Address'
      @UI.lineItem: [{ position: 30 }]
      concat(_Customer.CustomerName,concat(',',
       concat(_Customer.StreetName,
       concat(',', concat(_Customer.CityName, concat(',', concat(_Customer.PostalCode,
       concat(',', _Customer.Country))))))))              as CompleteAddress,
      @UI.lineItem: [{ position: 10 }]
      _PartnerFunctionText.PartnerFunctionName,

      _Customer
}

Learn More