I_SERIALNMBRSALESORDER

CDS View

Serial Number Sales Order

I_SERIALNMBRSALESORDER is a CDS View in S/4HANA. Serial Number Sales Order. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_CustRetRefDocSrlNmbr view_entity from CONSUMPTION Returns Order Reference Document Serial Number
C_PT_SAFTBillingItemSerialNmbr view inner CONSUMPTION SAF-T PT Item Serial Numbers
P_SerialNmbrSalesOrder view from CONSUMPTION Serial Number Sales Order Consmptn View

Fields (1)

KeyField CDS FieldsUsed in Views
SDDocumentCategory SDDocumentCategory 1 
@AbapCatalog.sqlViewName: 'ISERNOSLSORD'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY // never expose this view directly, only via associations

//if needed, user only privileged access or discuss about correct authorization objects

@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Serial Number Sales Order'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #BASIC
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_MaintItmObjListSalesOrder'

define view I_SerialNmbrSalesOrder
  as select from ser02

  association [1..1] to I_SalesOrder     as _SalesOrder     on  $projection.SalesOrder = _SalesOrder.SalesOrder
  association [1..1] to I_SalesOrderItem as _SalesOrderItem on  $projection.SalesOrder     = _SalesOrderItem.SalesOrder
                                                            and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem
{
  key obknr   as MaintenanceItemObjectList,

      sdaufnr as SalesOrder,
      posnr   as SalesOrderItem,
      datum   as SalesOrderDate,
      vbtyp   as SDDocumentCategory,
      //      vorgang as Operation,


      _SalesOrder,
      _SalesOrderItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SER02"
],
"ASSOCIATED":
[
"I_SALESORDER",
"I_SALESORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More