I_SERVICEDOCUMENTITEM

CDS View
44 Fields 52 CDS Views

Service Transaction Item

I_SERVICEDOCUMENTITEM is a CDS View in S/4HANA. Service Transaction Item. It contains 44 fields. 52 CDS views read from this table.

CDS Views using this table (52)

ViewTypeJoinVDMDescription
A_BusSolnOrdItmUserStatus view inner COMPOSITE Item User Status
A_ServiceConfItemUserStatus view inner COMPOSITE Service Confirmation Item User Status
A_ServiceOrdItemUserStatus view inner COMPOSITE Service Order Item User Status
A_SrvcOrdTmplItemPartner view inner COMPOSITE Service Order Template Item Partner
A_SrvcOrdTmplItemUserStatus view inner COMPOSITE Service Order Template Item User Status
A_SrvcOrdTmplItmPartnerAddress view_entity inner COMPOSITE Partner Address of Service Order Template Item
C_BillableMaintenanceOrder view_entity from CONSUMPTION Billable Maintenance Order Details
C_BuSoPrtfloSubscrpnContrItmVH view from CONSUMPTION Value Help: Subscrip. Contract Item
C_BusSolnPrtfloSrvcContrItmVH view from CONSUMPTION Value Help: Service Contract Item
C_BusSolnPrtfloSrvcOrderItmVH view from CONSUMPTION Value Help: Service Order Item
C_DspDocFlwServiceContractItem view_entity from CONSUMPTION Service Contract Item Attributes
C_DspDocFlwSrvcContractItemVH view_entity from CONSUMPTION Service Contract Item
C_InhRepairOpenRepairOrderItem view_entity from CONSUMPTION Open Repair Order Items
I_ServiceDocumentItemEnhcd view from COMPOSITE Service Transaction Item Enhanced
I_SrvcConItmGTSStsBlkdPndgSitn view_entity from COMPOSITE GTS Item Status for SrvDocItem Situation
I_SrvcDocItemByDocumentType view from BASIC Srvc Transaction Item by Transac Type
I_SrvcDocItmGTSStatusAnchor view_entity from COMPOSITE Anchor for GTS Item Status Situation
I_SrvcDocItmGTSStsBlkdPndgSitn view_entity from COMPOSITE GTS Item Status for SrvDocItem Situation
I_SrvcOrdBillgDelayedSituation view from COMPOSITE Service Order not invoiced situation
I_SrvcOrdItemProductDets view from COMPOSITE Retrieves Items of Serv. Order for Serv. Conf. creation
I_SrvcOrdItmExectgEmplSitn view from COMPOSITE Situation Anchor Missing Exec Employee
I_SrvcOrdPlndEndDateSituation view from COMPOSITE Planned End Date Is After Due Date
I_SrvcSettlmtHierarchyDocument view_entity inner COMPOSITE Settlement docs in Servc Hier
I_SubscrpnOrdItemDuration view_entity inner COMPOSITE Item Duration
I_SubscrpnOrdItemUserStatus view_entity inner COMPOSITE Item User Status
P_BSQPMSbscrContrToPrvdrContr view_entity from COMPOSITE
P_BSQPMSolnQtanItmProcFlw view_entity from COMPOSITE
P_SrvcConfProduct view from CONSUMPTION Prod Srvc Order for Srvc Confirmation
P_SrvcTransWthSituation view from COMPOSITE
R_BusSolnOrdItemLongTextTP view_entity inner TRANSACTIONAL Business Solution Order Item Long Text - TP
R_BusSolnOrdItmUserStatusTP view_entity inner TRANSACTIONAL Business Solution Order User Status - TP
R_SrvcConfItemLongTextTP view_entity inner TRANSACTIONAL Long Text for Service Conf Item
R_SrvcConfItemUserStatusTP view_entity inner TRANSACTIONAL Service Confirmation Item User Status - TP
R_SrvcConfItmTransHistory view_entity inner COMPOSITE Transaction History in SRVC Item
R_SrvcContrItemAppointmentTP view_entity inner TRANSACTIONAL Service Contract Item Appointment - TP
R_SrvcContrItemDurationTP view_entity inner TRANSACTIONAL Service Contract Item Duration - TP
R_SrvcContrItemLongTextTP view_entity inner TRANSACTIONAL Service Contract Item Long Text - TP
R_SrvcContrItemPartnerTP view_entity inner TRANSACTIONAL Service Contract Item Partner - TP
R_SrvcContrItemUserStatusTP view_entity inner TRANSACTIONAL Service Contract Item User Status - TP
R_SrvcContrTmplItemDurationTP view_entity inner TRANSACTIONAL Duration of SrvcContr Template Item - TP
R_SrvcContrTmplItemLongTextTP view_entity inner TRANSACTIONAL Service Contract Template Item Text - TP
R_SrvcOrdItemLongTextTP view_entity inner TRANSACTIONAL Notes Item view for Service Order
R_SrvcOrdItemUserStatusTP view_entity inner TRANSACTIONAL Service Order Item User Status - TP
R_SrvcOrdItmTransHistory view_entity inner COMPOSITE Transaction History in SRVO Item
R_SrvcOrdTmplItemLongTextTP view_entity inner TRANSACTIONAL Long text for Template Item - TP
R_SrvcOrdTmplItemUserStatusTP view_entity inner TRANSACTIONAL Service Order Temp Item User Status - TP
R_SrvcQtanItemAppointmentTP view_entity inner TRANSACTIONAL Service Quotation Item Appointment - TP
R_SrvcQtanItemDurationTP view_entity inner TRANSACTIONAL Service Quotation Item Duration - TP
R_SrvcQtanItemLongTextTP view_entity inner TRANSACTIONAL Long Text for Service Quotation Item
R_SrvcQtanItemPartnerTP view_entity inner TRANSACTIONAL Partner of Service Quotation Item - TP
R_SrvcQtanItemUserStatusTP view_entity inner TRANSACTIONAL Service Quotation Item User Status - TP
R_SubscrpnContrItemLongTextTP view_entity inner TRANSACTIONAL Subscription Contr. Item Long Text - TP

Fields (44)

KeyField CDS FieldsUsed in Views
KEY CustMgmtPrdcssrTransacObjType BusinessObjectType 1
KEY CustMgmtSuccssrTransacObjType BusinessObjectType 1
KEY InhRepairItemObjectType BusinessObjectType 1
KEY ServiceDocument BusinessSolutionOrder,PrecedingDocument,ServiceConfirmation,ServiceContract,ServiceContractTemplate,ServiceDocument,ServiceOrder,ServiceOrderTemplate,ServiceQuotation,SubscriptionContract,SubscriptionOrder 33
KEY ServiceDocumentItem BusinessSolutionOrderItem,PrecedingDocumentItem,ServiceConfirmationItem,ServiceContractItem,ServiceContractTemplateItem,ServiceDocumentItem,ServiceOrderItem,ServiceOrderTemplateItem,ServiceQuotationItem,SubscriptionContractItem,SubscriptionOrderItem 34
KEY ServiceDocumentItemObjectType BusinessObjectType 2
KEY ServiceDocumentItemUUID ServiceDocumentItemUUID 3
KEY ServiceDocumentUUID ServiceDocumentUUID 1
KEY ServiceObjectType ServiceObjectType 7
_DistributionChannel _DistributionChannel 1
_Division _Division 1
_SalesGroup _SalesGroup 1
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2 1
_SalesOffice _SalesOffice 1
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2 1
_SalesOrganization _SalesOrganization 1
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2 1
_ServiceDocItemCategory _ServiceDocItemCategory 1
_ServiceDocument _ServiceDocument 2
_ServiceDocumentType _ServiceDocumentType 2
_ServiceObjType _ServiceObjType 2
DistributionChannel DistributionChannel 7
Division Division 6
OriginallyRequestedProduct Material 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 2
ReferenceInHouseRepair ReferenceInHouseRepair 1
ReferenceInHouseRepairItem ReferenceInHouseRepairItem 1
ResponsibleEmployee ResponsibleEmployee 1
SalesGroup SalesGroup 6
SalesGroupOrgUnitID SalesGroupOrgUnitID 3
SalesOffice SalesOffice 6
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 3
SalesOrganization SalesOrganization 8
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 3
ServiceDocItemCategory ServiceDocItemCategory 1
ServiceDocItemGrossAmount ServiceDocItemGrossAmount 1
ServiceDocumentDescription ServiceDocumentDescription 2
ServiceDocumentItemDescription MaterialName 1
ServiceDocumentItemStatus ServiceDocumentItemStatus 1
ServiceDocumentType ServiceDocumentType 6
ServiceEmployee ServiceEmployee 1
ServiceOrganization ServiceOrganization 3
SoldToParty SoldToParty 4
TransactionCurrency TransactionCurrency 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.

-- Service Transaction Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEDOCUMENTITEM (
    CUSTMGMTPRDCSSRTRANSACOBJTYPE,
    CUSTMGMTSUCCSSRTRANSACOBJTYPE,
    INHREPAIRITEMOBJECTTYPE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTITEMOBJECTTYPE,
    SERVICEDOCUMENTITEMUUID,
    SERVICEDOCUMENTUUID,
    SERVICEOBJECTTYPE,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _SALESGROUP,
    _SALESGROUPORGUNIT_2,
    _SALESOFFICE,
    _SALESOFFICEORGUNIT_2,
    _SALESORGANIZATION,
    _SALESORGANIZATIONORGUNIT_2,
    _SERVICEDOCITEMCATEGORY,
    _SERVICEDOCUMENT,
    _SERVICEDOCUMENTTYPE,
    _SERVICEOBJTYPE,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    ORIGINALLYREQUESTEDPRODUCT,
    PURCHASEORDERBYCUSTOMER,
    REFERENCEINHOUSEREPAIR,
    REFERENCEINHOUSEREPAIRITEM,
    RESPONSIBLEEMPLOYEE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERVICEDOCITEMCATEGORY,
    SERVICEDOCITEMGROSSAMOUNT,
    SERVICEDOCUMENTDESCRIPTION,
    SERVICEDOCUMENTITEMDESCRIPTION,
    SERVICEDOCUMENTITEMSTATUS,
    SERVICEDOCUMENTTYPE,
    SERVICEEMPLOYEE,
    SERVICEORGANIZATION,
    SOLDTOPARTY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CUSTMGMTPRDCSSRTRANSACOBJTYPE, CUSTMGMTSUCCSSRTRANSACOBJTYPE, INHREPAIRITEMOBJECTTYPE, SERVICEDOCUMENT, SERVICEDOCUMENTITEM, SERVICEDOCUMENTITEMOBJECTTYPE, SERVICEDOCUMENTITEMUUID, SERVICEDOCUMENTUUID, SERVICEOBJECTTYPE)
);

Learn More