I_SrvcOrdItmFUPPurchaseOrder

DDL: I_SRVCORDITMFUPPURCHASEORDER Type: view BASIC Package: CRMS4_REPORT
8 Fields 1 Data Sources

Srvc Ord Itm Follow-up Purchase Order

I_SrvcOrdItmFUPPurchaseOrder is a Basic CDS View that provides data about "Srvc Ord Itm Follow-up Purchase Order" in SAP S/4HANA. It reads from 1 data source (crmd_brelvonai) and exposes 8 fields with key fields ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. Part of development package CRMS4_REPORT.

Data Sources (1)

SourceAliasJoin Type
crmd_brelvonai crmd_brelvonai from

Annotations (10)

NameValueLevelField
EndUserText.label Srvc Ord Itm Follow-up Purchase Order view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISVOITMFUPPO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentItmRelationUUID relationid GUID link
KEY ServiceDocItmRltnSqncNumber posno Sequential no.
ServiceDocumentItemCharUUID Object ID
ServiceDocItmSuccssrCharUUID Object ID
ServiceDocumentItmRelationType breltyp Rel. Type
ServiceDocumentItemObjectType objtype_a Object Type
ServiceDocumentItmRelationKind vona_kind Type VONA
ServiceDocItmSuccssrBusObjType objtype_b Object Type

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 I_SrvcOrdItmFUPPurchaseOrder.
-- 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 I_SrvcOrdItmFUPPurchaseOrder AS
SELECT
  relationid AS ServiceDocumentItmRelationUUID,
  posno AS ServiceDocItmRltnSqncNumber,
  cast(objkey_a as crms4_object_charguid32 preserving type ) AS ServiceDocumentItemCharUUID,
  cast(objkey_b as crms4_object_charguid32 preserving type ) AS ServiceDocItmSuccssrCharUUID,
  breltyp AS ServiceDocumentItmRelationType,
  objtype_a AS ServiceDocumentItemObjectType,
  vona_kind AS ServiceDocumentItmRelationKind,
  objtype_b AS ServiceDocItmSuccssrBusObjType
FROM crmd_brelvonai
;

Learn More