I_SERVICEDOCUMENTLONGTEXT

CDS View
26 Fields 24 CDS Views

Service Transaction Long Texts

I_SERVICEDOCUMENTLONGTEXT is a CDS View in S/4HANA. Service Transaction Long Texts. It contains 26 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
P_InhRepairItemNote view_entity union TRANSACTIONAL
P_InhRepairNote view_entity union TRANSACTIONAL
P_ServiceDocItemNote view union COMPOSITE Service Transaction Notes
P_ServiceDocNote view union COMPOSITE Service Transaction Notes
R_BusSolnOrdItemLongTextTP view_entity from TRANSACTIONAL Business Solution Order Item Long Text - TP
R_BusSolnOrdLongTextTP view_entity from TRANSACTIONAL Business Solution Order Long Text - TP
R_SrvcConfItemLongTextTP view_entity from TRANSACTIONAL Long Text for Service Conf Item
R_SrvcConfLongTextTP view_entity from TRANSACTIONAL Long Text for Service Confirmation
R_SrvcContrItemLongTextTP view_entity from TRANSACTIONAL Service Contract Item Long Text - TP
R_SrvcContrLongTextTP view_entity from TRANSACTIONAL Service Contract Long Text - TP
R_SrvcContrTmplItemLongTextTP view_entity from TRANSACTIONAL Service Contract Template Item Text - TP
R_SrvcContrTmplLongTextTP view_entity from TRANSACTIONAL Service Contract Template Text - TP
R_SrvcOrdItemLongTextTP view_entity from TRANSACTIONAL Notes Item view for Service Order
R_SrvcOrdLongTextTP view_entity from TRANSACTIONAL Long Text for Service Order
R_SrvcOrdTmplItemLongTextTP view_entity from TRANSACTIONAL Long text for Template Item - TP
R_SrvcOrdTmplLongTextTP view_entity from TRANSACTIONAL Service Order Template Long Text - TP
R_SrvcQtanItemLongTextTP view_entity from TRANSACTIONAL Long Text for Service Quotation Item
R_SrvcQtanLongTextTP view_entity from TRANSACTIONAL Long Text for Service Quotation
R_SrvcTransMstrAgrmtLongTextTP view_entity from TRANSACTIONAL Master Agreement Long Text
R_SubscrpnContrItemLongTextTP view_entity from TRANSACTIONAL Subscription Contr. Item Long Text - TP
R_SubscrpnContrLongTextTP view_entity from TRANSACTIONAL Subscription Contract Text - TP
R_SubscrpnOrdItemLongTextTP view_entity from TRANSACTIONAL Subscription Order Item Long Text
R_SubscrpnOrdLongTextTP view_entity from TRANSACTIONAL Subscription Order Long Text
R_SvTrMtAgrItmLongTextTP view_entity from TRANSACTIONAL Master Agreement Item Long Text

Fields (26)

KeyField CDS FieldsUsed in Views
KEY Language Language 24
KEY ServiceDocument BusinessSolutionOrder,InHouseRepair,ServiceConfirmation,ServiceContract,ServiceContractTemplate,ServiceOrder,ServiceOrderTemplate,ServiceQuotation,SrvcTransMstrAgrmtID,SubscriptionContract,SubscriptionOrder 13
KEY ServiceDocumentItem InHouseRepairItem,ServiceDocumentItem,SubscriptionContractItem 4
KEY SrvcDocLogTextIdentifier SrvcDocLogTextIdentifier 20
KEY TextObjectType TextObjectType 24
_Language _Language 10
_ReferenceTextObjectCategory _ReferenceTextObjectCategory 8
_ReferenceTextObjectType _ReferenceTextObjectType 8
_ServiceObjType _ServiceObjType 2
_TextObjectCategory _TextObjectCategory 8
_TextObjectType _TextObjectType 8
ReferenceLongTextKey ReferenceLongTextKey 20
ReferenceServiceDocument ReferenceServiceDocument 15
ReferenceServiceDocumentItem ReferenceServiceDocumentItem 15
ReferenceServiceObjectType ReferenceServiceObjectType 13
ReferenceTextObjectCategory ReferenceTextObjectCategory 20
ReferenceTextObjectType ReferenceTextObjectType 20
ServiceDocumentLongText BusinessSolutionOrderLongText,BusSolnOrdItmLongText,ServiceOrderItemLongText,ServiceOrderLongText,SrvcConfItemLongText,SrvcConfLongText,SrvcContrItemLongText,SrvcContrLongText,SrvcContrTmplItemLongText,SrvcContrTmplLongText,SrvcOrdTmplItemLongText,SrvcOrdTmplLongText,SrvcQtanItemLongText,SrvcQtanLongText,SrvcTransMstrAgrmtItmLongText,SrvcTransMstrAgrmtLongText,SubscriptionContractLongText,SubscrpnContrItemLongText,SubscrpnOrderLongText,SubscrpnOrdItemLongText 20
ServiceDocumentLongTextUUID ServiceDocumentLongTextUUID 18
ServiceObjectType ServiceObjectType 10
SrvcDocLongTextChangedByUser SrvcDocLongTextChangedByUser 20
SrvcDocLongTextChangedDateTime SrvcDocLongTextChangedDateTime 20
SrvcDocLongTextCreatedByUser SrvcDocLongTextCreatedByUser 20
SrvcDocLongTextMimeType SrvcDocLongTextMimeType 20
SrvcDocLongTxtCreationDateTime SrvcDocLongTxtCreationDateTime 20
TextObjectCategory TextObjectCategory 24

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.

-- Service Transaction Long Texts
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEDOCUMENTLONGTEXT (
    LANGUAGE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SRVCDOCLOGTEXTIDENTIFIER,
    TEXTOBJECTTYPE,
    _LANGUAGE,
    _REFERENCETEXTOBJECTCATEGORY,
    _REFERENCETEXTOBJECTTYPE,
    _SERVICEOBJTYPE,
    _TEXTOBJECTCATEGORY,
    _TEXTOBJECTTYPE,
    REFERENCELONGTEXTKEY,
    REFERENCESERVICEDOCUMENT,
    REFERENCESERVICEDOCUMENTITEM,
    REFERENCESERVICEOBJECTTYPE,
    REFERENCETEXTOBJECTCATEGORY,
    REFERENCETEXTOBJECTTYPE,
    SERVICEDOCUMENTLONGTEXT,
    SERVICEDOCUMENTLONGTEXTUUID,
    SERVICEOBJECTTYPE,
    SRVCDOCLONGTEXTCHANGEDBYUSER,
    SRVCDOCLONGTEXTCHANGEDDATETIME,
    SRVCDOCLONGTEXTCREATEDBYUSER,
    SRVCDOCLONGTEXTMIMETYPE,
    SRVCDOCLONGTXTCREATIONDATETIME,
    TEXTOBJECTCATEGORY,
    PRIMARY KEY (LANGUAGE, SERVICEDOCUMENT, SERVICEDOCUMENTITEM, SRVCDOCLOGTEXTIDENTIFIER, TEXTOBJECTTYPE)
);

Learn More