I_SERVICEDOCUMENTLONGTEXT

CDS View
25 Fields 33 CDS Views

Service Transaction Long Texts

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

CDS Views using this table (33)

ViewTypeJoinVDMDescription
A_BusinessSolutionOrderText view from COMPOSITE Header Text
A_BusSolnQtanItemText view from COMPOSITE Item Text
A_BusSolutionOrderItemText view from COMPOSITE Item Text
A_BusSolutionQuotationText view from COMPOSITE Solution Quotation Header Text
A_ServiceConfirmationItemText view_entity from COMPOSITE Text of Service Confirmation Item
A_ServiceConfirmationText view_entity from COMPOSITE Service Confirmation Text
A_ServiceContractItemText view from COMPOSITE Item Text
A_ServiceContractText view from CONSUMPTION Header Text
A_ServiceOrderItemText view from COMPOSITE Text of Service Order Item
A_ServiceOrderText view from COMPOSITE Service Order Text
A_ServiceOrderTmplItemText view_entity from COMPOSITE Item Text
A_ServiceOrderTmplText view_entity from COMPOSITE Service Order Template Text
A_ServiceQuotationItemText view_entity from COMPOSITE Text of Service Quotation Item
A_ServiceQuotationText view_entity from COMPOSITE Service Quotation Text
A_ServiceRequestText view from COMPOSITE Service Request Text
P_InhRepairItemNote view_entity union TRANSACTIONAL Notes for In-House Repair Item
P_InhRepairNote view_entity union TRANSACTIONAL Notes for In-House Repair
P_ServiceDocItemNote view_entity union COMPOSITE Service Transaction Notes
P_ServiceDocNote view_entity 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

Fields (25)

KeyField CDS FieldsUsed in Views
KEY Language Language 24
KEY ServiceDocument BusinessSolutionOrder,InHouseRepair,ServiceConfirmation,ServiceContract,ServiceContractTemplate,ServiceOrder,ServiceOrderTemplate,ServiceQuotation,ServiceRequest 22
KEY ServiceDocumentItem BusinessSolutionOrderItem,InHouseRepairItem,ServiceConfirmationItem,ServiceContractItem,ServiceOrderItem,ServiceOrderTemplateItem,ServiceQuotationItem 7
KEY SrvcDocLogTextIdentifier SrvcDocLogTextIdentifier 14
KEY TextObjectType LongTextID,TextObjectType 22
_Language _Language 6
_ReferenceTextObjectCategory _ReferenceTextObjectCategory 6
_ReferenceTextObjectType _ReferenceTextObjectType 6
_TextObjectCategory _TextObjectCategory 6
_TextObjectType _TextObjectType 6
ReferenceLongTextKey ReferenceLongTextKey 14
ReferenceServiceDocument ReferenceServiceDocument 9
ReferenceServiceDocumentItem ReferenceServiceDocumentItem 9
ReferenceServiceObjectType ReferenceServiceObjectType 9
ReferenceTextObjectCategory ReferenceTextObjectCategory 14
ReferenceTextObjectType ReferenceTextObjectType 14
ServiceDocumentLongText BusinessSolutionOrderLongText,BusSolnOrdItmLongText,LongText,ServiceOrderItemLongText,ServiceOrderLongText,SrvcConfItemLongText,SrvcConfLongText,SrvcContrItemLongText,SrvcContrLongText,SrvcContrTmplItemLongText,SrvcContrTmplLongText,SrvcOrdTmplItemLongText,SrvcOrdTmplLongText,SrvcQtanItemLongText,SrvcQtanLongText 18
ServiceDocumentLongTextUUID ServiceDocumentLongTextUUID 4
ServiceObjectType ServiceObjectType 8
SrvcDocLongTextChangedByUser SrvcDocLongTextChangedByUser 14
SrvcDocLongTextChangedDateTime SrvcDocLongTextChangedDateTime 14
SrvcDocLongTextCreatedByUser SrvcDocLongTextCreatedByUser 14
SrvcDocLongTextMimeType SrvcDocLongTextMimeType 14
SrvcDocLongTxtCreationDateTime SrvcDocLongTxtCreationDateTime 14
TextObjectCategory TextObjectCategory 18

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,
    _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