A_SrvcConfItemSerialNumber

DDL: A_SRVCCONFITEMSERIALNUMBER SQL: ASRVCONFISN Type: view COMPOSITE
7 Fields 1 Data Sources 1 Associations

Serial Number in Service Confirmation Item

A_SrvcConfItemSerialNumber is a Composite CDS View that provides data about "Serial Number in Service Confirmation Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentRefObject) and exposes 7 fields with key fields ServiceConfirmation, ServiceConfirmationItem, ServiceRefObjectSequenceNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentRefObject I_ServiceDocumentRefObject from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_ServiceConfirmation _ServiceConfirmation $projection.ServiceConfirmation = _ServiceConfirmation.ServiceConfirmation

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ASRVCONFISN view
EndUserText.label Serial Number in Service Confirmation Item view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ServiceConfirmation ServiceDocument Transaction ID
KEY ServiceConfirmationItem ServiceDocumentItem Service Document
KEY ServiceRefObjectSequenceNumber ServiceRefObjectSequenceNumber Version
SerialNumber SerialNumber Serial Number
ServiceReferenceEquipment Equipment Equipment
ManufacturerSerialNumber Manufacturer\
_ServiceConfirmation _ServiceConfirmation

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_SrvcConfItemSerialNumber.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ASRVCONFISN

CREATE VIEW A_SrvcConfItemSerialNumber AS
SELECT
  ServiceDocument AS ServiceConfirmation,
  ServiceDocumentItem AS ServiceConfirmationItem,
  ServiceRefObjectSequenceNumber,
  SerialNumber,
  Equipment AS ServiceReferenceEquipment,
  s Serial Number' s Serial Number' _Equipment.ManufacturerSerialNumber AS ManufacturerSerialNumber
FROM I_ServiceDocumentRefObject
LEFT OUTER JOIN A_ServiceConfirmation AS _ServiceConfirmation ON ServiceConfirmation = _ServiceConfirmation.ServiceConfirmation  -- association [1..1]
;

Learn More