P_ServiceDocumentRefObject

DDL: P_SERVICEDOCUMENTREFOBJECT Type: view CONSUMPTION
14 Fields 1 Data Sources

P_ServiceDocumentRefObject is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentRefObject) and exposes 14 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentRefObject I_ServiceDocumentRefObject from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSERVDOCREFOBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ServiceDocumentItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
ServiceReferenceObjectType ServiceReferenceObjectType Object Type
ServiceReferenceObjectUUID ServiceReferenceObjectUUID Object GUID
ProductID ProductID Product ID
SrvcRefObjIsMainObject SrvcRefObjIsMainObject Main Object
ProductUUID ProductUUID UUID
SerialNumber SerialNumber Serial Number
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
_Equipment _Equipment
_Product _Product
_FunctionalLocation _FunctionalLocation

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 P_ServiceDocumentRefObject.
-- 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.

CREATE VIEW P_ServiceDocumentRefObject AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceReferenceObjectType,
  ServiceReferenceObjectUUID,
  ProductID,
  SrvcRefObjIsMainObject,
  ProductUUID,
  SerialNumber,
  Equipment,
  FunctionalLocation
FROM I_ServiceDocumentRefObject
;

Learn More