P_ServiceOrderItmBpfSuccssr

DDL: P_SERVICEORDERITMBPFSUCCSSR Type: view_entity COMPOSITE
23 Fields 4 Data Sources

BPF for Succssr Item Srvc Transactions

P_ServiceOrderItmBpfSuccssr is a Composite CDS View that provides data about "BPF for Succssr Item Srvc Transactions" in SAP S/4HANA. It reads from 4 data sources (C_SrvcDocItemDocumentFlow, C_SrvcDocItemDocumentFlow, I_ServiceDocumentItemPrdcssr_3, I_ServiceDocumentItemPrdcssr_3) and exposes 23 fields with key fields ServiceDocument, ServiceDocumentItem, ServiceDocumentItmRelationUUID, ServiceDocumentItemSuccessor, ServiceDocumentItem.

Data Sources (4)

SourceAliasJoin Type
C_SrvcDocItemDocumentFlow _ServiceOrderItem from
C_SrvcDocItemDocumentFlow _ServiceOrderItem union
I_ServiceDocumentItemPrdcssr_3 _SuccessorPredeccessor inner
I_ServiceDocumentItemPrdcssr_3 _SuccessorPredeccessor inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label BPF for Succssr Item Srvc Transactions view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument C_SrvcDocItemDocumentFlow ServiceDocument Transaction ID
KEY ServiceDocumentItem C_SrvcDocItemDocumentFlow ServiceDocumentItem Service Document
KEY ServiceDocumentItmRelationUUID C_SrvcDocItemDocumentFlow ServiceDocumentItmRelationUUID GUID link
KEY ServiceDocumentItemSuccessor C_SrvcDocItemDocumentFlow ServiceDocumentItemSuccessor
CustMgmtPrdcssrTransactionKey C_SrvcDocItemDocumentFlow CustMgmtPrdcssrTransactionKey
ReltdSrvcDocItemIsPredecessor C_SrvcDocItemDocumentFlow ReltdSrvcDocItemIsPredecessor
PrecedingDocument
PrecedingDocumentCategory
PrecedingDocumentItem
SubsequentDocument C_SrvcDocItemDocumentFlow CustMgmtPrdcssrTransactionKey
SubsequentDocumentCategory C_SrvcDocItemDocumentFlow PrdcssrSuccssrDocObjectType
ServiceDocument Transaction ID
KEY ServiceDocumentItem C_SrvcDocItemDocumentFlow ServiceDocumentItem Service Document
KEY ServiceDocumentItmRelationUUID C_SrvcDocItemDocumentFlow ServiceDocumentItmRelationUUID GUID link
KEY ServiceDocumentItemSuccessor C_SrvcDocItemDocumentFlow ServiceDocumentItemSuccessor
CustMgmtPrdcssrTransactionKey C_SrvcDocItemDocumentFlow CustMgmtPrdcssrTransactionKey
ReltdSrvcDocItemIsPredecessor C_SrvcDocItemDocumentFlow ReltdSrvcDocItemIsPredecessor
PrecedingDocument
PrecedingDocumentCategory
PrecedingDocumentItem
SubsequentDocument C_SrvcDocItemDocumentFlow CustMgmtPrdcssrTransactionKey
SubsequentDocumentCategory C_SrvcDocItemDocumentFlow PrdcssrSuccssrDocObjectType
SubsequentDocumentItem C_SrvcDocItemDocumentFlow SrvcPrdcssrSuccssrDocumentItem

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_ServiceOrderItmBpfSuccssr.
-- 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_ServiceOrderItmBpfSuccssr AS
SELECT
  _ServiceOrderItem.ServiceDocument AS ServiceDocument,
  _ServiceOrderItem.ServiceDocumentItem AS ServiceDocumentItem,
  _ServiceOrderItem.ServiceDocumentItmRelationUUID AS ServiceDocumentItmRelationUUID,
  _ServiceOrderItem.ServiceDocumentItemSuccessor AS ServiceDocumentItemSuccessor,
  _ServiceOrderItem.CustMgmtPrdcssrTransactionKey AS CustMgmtPrdcssrTransactionKey,
  _ServiceOrderItem.ReltdSrvcDocItemIsPredecessor AS ReltdSrvcDocItemIsPredecessor,
  _SuccessorPredeccessor._ServiceDocItm.ServiceDocument AS PrecedingDocument,
  _SuccessorPredeccessor._ServiceDocItm.ServiceObjectType AS PrecedingDocumentCategory,
  _SuccessorPredeccessor._ServiceDocItm.ServiceDocumentItem AS PrecedingDocumentItem,
  _ServiceOrderItem.CustMgmtPrdcssrTransactionKey AS SubsequentDocument,
  _ServiceOrderItem.PrdcssrSuccssrDocObjectType AS SubsequentDocumentCategory,
  _ServiceOrderItem.SrvcPrdcssrSuccssrDocumentItem AS SubsequentDocumentItem
FROM C_SrvcDocItemDocumentFlow AS _ServiceOrderItem
INNER JOIN I_ServiceDocumentItemPrdcssr_3 AS _SuccessorPredeccessor ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): C_SrvcDocItemDocumentFlow
;

Learn More