C_SerialNumberHistoryPartner

DDL: C_SERIALNUMBERHISTORYPARTNER Type: view_entity CONSUMPTION Package: ODATA_LO_SN_HISTORY

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). Part of development package ODATA_LO_SN_HISTORY.

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 (9)

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
UI.headerInfo.typeName Business Partner view
UI.headerInfo.typeNamePlural Business Partners view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SERIALNUMBER_HISTORY_V4 UI_SERIALNUMBER_HISTORY_V4 V4 C1 NOT_TO_BE_RELEASED_STABLE

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintObjectInternalID MaintObjectInternalID
KEY PartnerFunction
KEY MaintenancePartnerObjectNumber MaintenancePartnerObjectNumber
MaintObjectCategory MaintObjectCategory
MaintenancePartner MaintenancePartner Business Partner
CustomerName _Customer BPCustomerFullName
CountryName1asCompleteAddress 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'
@UI:{
      headerInfo: {
                    typeName: 'Business Partner',
                    typeNamePlural: 'Business Partners' } }

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.BPCustomerFullName                                                                                  as CustomerName,
      @EndUserText.label: 'Address'
      @UI.lineItem: [{ position: 30 }]
      concat_with_space(
        concat_with_space(
          concat(
            concat_with_space(_Customer._AddressDefaultRepresentation.StreetName,_Customer._AddressDefaultRepresentation.HouseNumber,1),','),
          concat(
            concat_with_space(_Customer._AddressDefaultRepresentation.PostalCode,_Customer._AddressDefaultRepresentation.CityName,1),','),1),
        _Customer._AddressDefaultRepresentation._Country._Text[1:Language=$session.system_language].CountryName, 1) as CompleteAddress,

      @UI.lineItem: [{ position: 10 }]
      _PartnerFunctionText.PartnerFunctionName,

      _Customer
}

Learn More