P_SrvcContrItmWithCloudCheck

Srvc. Contr. Item Enhcd with Cloud Flag Check | view: PSRVCONTRITEMENH | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_H, CRMS4D_SERV_I, CRMS4C_ORGMAN
Column Name Description
ServiceObjectType FK Business Trans. Cat.
ServiceDocument Transaction ID
ServiceDocumentItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount Net Value
Column Name Description
Column Name Description
PostingDate Posting Date for a Business Transaction
ServiceDocItemCreationDate Created On
ExchangeRateDate Exchange Rate Date
Column Name Description
ServiceDocumentTemplateType Template Type of CRM Transaction Show values
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
SrvcDocItmDeliveryStatus Delivery Status Show values
SrvcDocItmGoodsIssueStatus Goods Issue Status Show values
ServiceDocumentItemIsReleased Release Status Show values
ServiceDocumentItemIsRejected Cancellation Status Show values
ServiceDocumentItemIsQuotation Quotation Status Show values
Column Name Description Domain name
IsCloudSystem null
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
SrvcDocItmPostingDateTime Posting Date TZNTSTMPS
SrvcDocItmValdtyStartDateTime Time Dependency: Validity Start Date TZNTSTMPS
SrvcDocItmValdtyEndDateTime Time Dependency: Validity End Date TZNTSTMPS
ServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentItemCharUUID 32 Character CRM Object GUID (Converted)
ServiceDocumentUUID GUID of a CRM Order Object SYSUUID
ParentServiceDocumentItemUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentItemDescription Product Description CRM_PRSHTEXT40_DB
Language Short Text Language for an Item SYLANGU
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
Product Product Number MATNR
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
RefBusinessSolutionOrderItem Item Number in Referenced Solution Order CRMS4_NUMBER_INT
AccountingExchangeRate Exchange Rate CRM_EXCHG_RATE
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ResponsibleSalesOrganization Organizational Unit (Sales) HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
ResponsibleServiceOrganization Organizational Unit (Service) HROBJEC_14
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
Accounting Indicator
  • Accounting Indicator
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.BILLABLECONTROL == TBMOT.BEMOT
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == TBMOT.MANDT
Bill-To Party
  • Bill-To Party
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.BILLTOPARTY == BUT000.PARTNER
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == BUT000.CLIENT
Customer Contact Person
  • Customer Contact Person
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.CONTACTPERSON == BUT000.PARTNER
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == BUT000.CLIENT
Distribution Channel
  • Distribution Channel
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == TSPA.MANDT
  • P_SRVCCONTRITMWITHCLOUDCHECK.DIVISION == TSPA.SPART
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.EXCHANGERATETYPE == TCURV.KURST
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == TCURV.MANDT
Payer
  • Payer
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.PAYERPARTY == BUT000.PARTNER
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == BUT000.CLIENT
Terms of Payment
  • ?
  • Terms of Payment
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • P_SRVCCONTRITMWITHCLOUDCHECK.PAYMENTTERMS == T052.ZTERM
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == T052.MANDT
Employee Responsible
  • Employee Responsible
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == BUT000.CLIENT
Item Category
  • Item Category
  • Client
Cancelling Party
  • Cancelling Party
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.SERVICEDOCUMENTITEMCANCLNPARTY == CRMC_PARTY.CANC_PARTY
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == CRMC_PARTY.CLIENT
CRM Item Object Type P_SRVCCONTRITMWITHCLOUDCHECK.SERVICEDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Activity Priority
  • Activity Priority
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.SERVICEDOCUMENTITEMPRIORITY == SCPRIO.PRIORITY
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == SCPRIO.CLIENT
CRM Service : Reason for Cancellation
  • CRM Service : Reason for Cancellation
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.SERVICEDOCUMENTITMCANCLNREASON == CRMC_CANCREASON.CANC_REASON
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == CRMC_CANCREASON.CLIENT
Business Transaction Type
  • Business Transaction Type
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == CRMC_PROC_TYPE.CLIENT
Executing Service Employee
  • Client
  • Executing Service Employee
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == BUT000.CLIENT
  • P_SRVCCONTRITMWITHCLOUDCHECK.SERVICEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat. P_SRVCCONTRITMWITHCLOUDCHECK.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Service Team
  • Client
  • Service Team
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == BUT000.CLIENT
  • P_SRVCCONTRITMWITHCLOUDCHECK.SERVICETEAM == BUT000.PARTNER
Ship-To Party
  • Ship-To Party
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.SHIPTOPARTY == BUT000.PARTNER
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == BUT000.CLIENT
Sold-To Party
  • Sold-To Party
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.SOLDTOPARTY == BUT000.PARTNER
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == BUT000.CLIENT
Country/Region
  • Client
  • Country/Region
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == T005.MANDT
  • P_SRVCCONTRITMWITHCLOUDCHECK.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region
  • P_SRVCCONTRITMWITHCLOUDCHECK.SOLDTOPARTYREGION == T005S.BLAND
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == T005S.MANDT
  • P_SRVCCONTRITMWITHCLOUDCHECK.SOLDTOPARTYCOUNTRY == T005S.LAND1
Cancellation Procedure
  • Cancellation Procedure
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.SRVCDOCITMCANCLNPROCEDURE == CRMC_CANCPROC.CANCPROC
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == CRMC_CANCPROC.CLIENT
Reference Currency
  • Reference Currency
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.STATISTICSCURRENCY == TCURC.WAERS
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == TCURC.MANDT
Currency
  • Currency
  • Client
  • P_SRVCCONTRITMWITHCLOUDCHECK.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SRVCCONTRITMWITHCLOUDCHECK.MANDT == TCURC.MANDT