I_SrvcDocItemByDocumentType

Srvc Transaction Item by Transac Type | view: ISRVCDOCITMSRCH | ATTR | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_SERV_I
Column Name Description
ServiceDocumentType FK Business Transaction Type
ServiceDocument Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount Net Value
ServiceDocItemGrossAmount Gross Order Value in PO Currency
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit):
ServiceDocumentItemQuantity CRM: Order Quantity
📏 Unit for Duration of Work (ServiceDurationUnit):
ServiceDuration Duration
📏 Time Unit for Confirmed Duration (ActualServiceDurationUnit):
ActualServiceDuration Confirmed Duration
📏 UOM for Auto Renewal Period (SrvcContrItemRnwlDurationUnit):
SrvcContrItemRnwlDuration Unit for Auto Renewal Period
📏 UOM for Contract Extension (SrvcContrItemExtnDurationUnit):
SrvcContrItemExtensionDuration Unit for Contract Extension
Column Name Description
PostingDate Posting Date for a Business Transaction
ServiceDocItemCreationDate Created On
ServiceDocItemChangedDate Changed On
Column Name Description
ServiceDocumentItemStatus Life Cycle Status Show values
ServiceDocumentItemHasError Error Status Show values
SrvcDocItmIsReleasedForBilling Billing Release Status Show values
ServiceDocItemBillingStatus Billing Status Show values
ServiceDocumentItemIsOpen Status "Open" Show values
ServiceDocumentItemIsReleased Release Status Show values
ServiceDocumentItemIsRejected Cancellation Status Show values
Column Name Description Domain name
ServiceDocumentUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
ServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ParentServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentItemDescription Product Description CRM_PRSHTEXT40_DB
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
RefBusinessSolutionOrderItem Item Number in Referenced Solution Order CRMS4_NUMBER_INT
BillingDateTime Billing Date for Billing Index and Printout TZNTSTMPS
BillingDocCreationDateTime Billing Document Creation Date TZNTSTMPS
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
ResponsibleServiceOrganization Organizational Unit (Service) HROBJEC_14
ServiceDocItemCreationDateTime Created At TZNTSTMPS
ServiceDocItemChangedDateTime Changed At TZNTSTMPS
ServiceDocItemCreatedByUser User that Created the Transaction UNAME
ServiceDocItemChangedByUser Transaction Last Changed By UNAME
OriginallyRequestedProduct Product Name Entered CRM_ORDERED_PROD
RequestedServiceStartDateTime Service Request Start Date TZNTSTMPS
RequestedServiceEndDateTime Service Request Due Date TZNTSTMPS
ServiceContrItemStartDateTime Contract Start date DEC15
ServiceContrItemEndDateTime Contract End Date DEC15
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ResponseProfile Response Profile CRM_SRV_ESCAL
ServiceProfile Service Profile CRM_SRV_SERWI
Language Short Text Language for an Item SYLANGU
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
Master Data Relations | to Other Relations ↓ Join Conditions
Accounting Indicator
  • Accounting Indicator
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.BILLABLECONTROL == TBMOT.BEMOT
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == TBMOT.MANDT
Business Partner: Billing Block Reason
  • Business Partner: Billing Block Reason
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.BILLINGBLOCKREASON == TVFS.FAKSP
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == TVFS.MANDT
Bill-To Party
  • Bill-To Party
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.BILLTOPARTY == BUT000.PARTNER
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Customer Contact Person
  • Customer Contact Person
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.CONTACTPERSON == BUT000.PARTNER
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Distribution Channel
  • Client
  • Distribution Channel
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == TVTW.MANDT
  • I_SRVCDOCITEMBYDOCUMENTTYPE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.DIVISION == TSPA.SPART
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == TSPA.MANDT
Industry Sector
  • Industry Sector
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.INDUSTRY == T016.BRSCH
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == T016.MANDT
Payer
  • Client
  • Payer
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
  • I_SRVCDOCITEMBYDOCUMENTTYPE.PAYERPARTY == BUT000.PARTNER
Terms of Payment
  • Terms of Payment
  • ?
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.PAYMENTTERMS == T052.ZTERM
  • I_SRVCDOCITEMBYDOCUMENTTYPE.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == T052.MANDT
Employee Responsible
  • Employee Responsible
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Item Category
  • Item Category
  • Client
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == T006.MANDT
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == TVAG.MANDT
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SERVICEDOCITEMREJECTIONREASON == TVAG.ABGRU
CRM Item Object Type I_SRVCDOCITEMBYDOCUMENTTYPE.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Activity Priority
  • Activity Priority
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SERVICEDOCUMENTITEMPRIORITY == SCPRIO.PRIORITY
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == SCPRIO.CLIENT
Business Transaction Type
  • Client
  • Business Transaction Type
Executing Service Employee
  • Executing Service Employee
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SERVICEEMPLOYEE == BUT000.PARTNER
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Business Trans. Cat. I_SRVCDOCITEMBYDOCUMENTTYPE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Service Team
  • Service Team
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SERVICETEAM == BUT000.PARTNER
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Ship-To Party
  • Ship-To Party
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SHIPTOPARTY == BUT000.PARTNER
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Sold-To Party
  • Sold-To Party
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SOLDTOPARTY == BUT000.PARTNER
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Country/Region
  • Client
  • Country/Region
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == T005.MANDT
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SOLDTOPARTYREGION == T005S.BLAND
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == T005S.MANDT
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SOLDTOPARTYCOUNTRY == T005S.LAND1
Base Unit of Measure of Product
  • Base Unit of Measure of Product
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SRVCDOCITEMBASEQUANTITYUNIT == T006.MSEHI
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == T006.MANDT
Currency
  • Currency
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Rule for Determining the Next Billing Date
  • Rule for Determining the Next Billing Date
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.BILLINGPLANBILLINGDATERULEUUID == TIMERULEH.RULE_ID
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == TIMERULEH.CLIENT
Rule for Determining the Period Date
  • Rule for Determining the Period Date
  • Client
  • I_SRVCDOCITEMBYDOCUMENTTYPE.SETTLEMENTPERIODRULEUUID == TIMERULEH.RULE_ID
  • I_SRVCDOCITEMBYDOCUMENTTYPE.MANDT == TIMERULEH.CLIENT