I_SRVCDOCITEMRELATION

CDS View
7 Fields 8 CDS Views

Relationship between Service Trans Items

I_SRVCDOCITEMRELATION is a CDS View in S/4HANA. Relationship between Service Trans Items. It contains 7 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_InhReprLogisticsProcessFlow view_entity inner CONSUMPTION Process Flow for Log Process of ServObj
I_InhRepairItemTransacRelation view_entity from COMPOSITE Relationship between Srvc Transac Items
I_InhRepairItmCustRetRelation view from COMPOSITE Relshp btwn Srvc Transac and Rtrns Ordr
R_InhRepairItmFUPCustReturnTP view_entity inner TRANSACTIONAL FollowUp Returns Ord Itm for IHR Itm - TP
R_SrvcConfItmTransHistory view_entity from COMPOSITE Transaction History in SRVC Item
R_SrvcConfItmTransHistory view_entity union_all COMPOSITE Transaction History in SRVC Item
R_SrvcOrdItmTransHistory view_entity from COMPOSITE Transaction History in SRVO Item
R_SrvcOrdItmTransHistory view_entity union_all COMPOSITE Transaction History in SRVO Item

Fields (7)

KeyField CDS FieldsUsed in Views
KEY ServiceDocItmRltnSqncNumber ServiceDocItmRltnSqncNumber 1
KEY ServiceDocItmSuccssrBusObjType BusinessObjectType,ServiceDocItmSuccssrBusObjType 2
KEY ServiceDocumentItmRelationUUID ServiceDocumentItmRelationUUID 1
ServiceDocItmPrdcssrBusObjType ServiceDocItmPrdcssrBusObjType 1
ServiceDocumentItemPredecessor ServiceDocumentItemPredecessor 1
ServiceDocumentItemSuccessor ServiceDocumentItemSuccessor 1
ServiceDocumentItmRelationType ServiceDocumentItmRelationType 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Relationship between Service Trans Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SRVCDOCITEMRELATION (
    SERVICEDOCITMRLTNSQNCNUMBER,
    SERVICEDOCITMSUCCSSRBUSOBJTYPE,
    SERVICEDOCUMENTITMRELATIONUUID,
    SERVICEDOCITMPRDCSSRBUSOBJTYPE,
    SERVICEDOCUMENTITEMPREDECESSOR,
    SERVICEDOCUMENTITEMSUCCESSOR,
    SERVICEDOCUMENTITMRELATIONTYPE,
    PRIMARY KEY (SERVICEDOCITMRLTNSQNCNUMBER, SERVICEDOCITMSUCCSSRBUSOBJTYPE, SERVICEDOCUMENTITMRELATIONUUID)
);

Learn More