C_PT_SAFTProductSerialNumber

DDL: C_PT_SAFTPRODUCTSERIALNUMBER Type: view_entity CONSUMPTION Package: GLO_FIN_IS_SAFT_PT

Product Serial Number - Cube

C_PT_SAFTProductSerialNumber is a Consumption CDS View (Cube) that provides data about "Product Serial Number - Cube" in SAP S/4HANA. It reads from 6 data sources and exposes 7 fields with key fields CompanyCode, PT_SAFTDocumentNumber, PT_SAFTLineNumber, CompanyCode, PT_SAFTDocumentNumber. Part of development package GLO_FIN_IS_SAFT_PT.

6 data source(s) 7 fields

Data Sources (6)

SourceAliasJoin Type
I_PT_SAFTBillgSlsInvcItem Item from
I_PT_SAFTBillgSlsInvcItem Item union
I_MaintenanceItemObject MaintObj inner
I_MaintenanceItemObject MaintObj inner
I_SerialNmbrDelivery Serial inner
I_SerialNmbrSalesOrder Serial inner

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
EndUserText.label Product Serial Number - Cube view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_PT_SAFTBillgSlsInvcItem CompanyCode
KEY PT_SAFTDocumentNumber I_PT_SAFTBillgSlsInvcItem PT_SAFTDocumentNumber
KEY PT_SAFTLineNumber I_PT_SAFTBillgSlsInvcItem PT_SAFTLineNumber
KEY CompanyCode
KEY PT_SAFTDocumentNumber I_PT_SAFTBillgSlsInvcItem PT_SAFTDocumentNumber
KEY PT_SAFTLineNumber I_PT_SAFTBillgSlsInvcItem PT_SAFTLineNumber
KEY SerialNumber I_MaintenanceItemObject SerialNumber 
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #CONSUMPTION
@Analytics.internalName:#LOCAL
@Metadata.allowExtensions:true
@Analytics: { dataCategory: #CUBE }
@EndUserText.label: 'Product Serial Number - Cube'
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity C_PT_SAFTProductSerialNumber
  as select from I_PT_SAFTBillgSlsInvcItem as Item
    inner join   I_SerialNmbrDelivery      as Serial   on  Item.ReferenceSDDocument         = Serial.DeliveryDocument
                                                       and Item.ReferenceSDDocumentItem     = Serial.DeliveryDocumentItem
                                                       and Item.ReferenceSDDocumentCategory = Serial.SDDocumentCategory
    inner join   I_MaintenanceItemObject   as MaintObj on Serial.MaintenanceItemObjectList = MaintObj.MaintenanceItemObjectList

{
  key Item.CompanyCode,
  key Item.PT_SAFTDocumentNumber,
  key Item.PT_SAFTLineNumber, //Filter query ZSLSERIALNUMBER

  key MaintObj.SerialNumber as SerialNumber //0000000227 - SerialNumber

}
where
  MaintObj.SerialNumber <> ''

union

select from  I_PT_SAFTBillgSlsInvcItem as Item
  inner join I_SerialNmbrSalesOrder    as Serial   on  Item.SalesDocument     = Serial.SalesOrder
                                                   and Item.SalesDocumentItem = Serial.SalesOrderItem
  inner join I_MaintenanceItemObject   as MaintObj on Serial.MaintenanceItemObjectList = MaintObj.MaintenanceItemObjectList

{
  key Item.CompanyCode,
  key Item.PT_SAFTDocumentNumber,
  key Item.PT_SAFTLineNumber,
  key MaintObj.SerialNumber as SerialNumber
}
where
  MaintObj.SerialNumber <> ''

Learn More