P_SrvcDocEnhcdWithCloudCheck

Srvc. Documents with Cloud Flag Check | view: PSRVDOCENHCD | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: CRMS4D_SERV_H, CRMS4C_ORGMAN
Column Name Description
ServiceDocument Transaction ID
ServiceDocumentType FK Business Transaction Type
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocNetAmount Total Net Value of Document in Document Currency
Column Name Description
Column Name Description
ServiceContractStartDate Created On
ServiceContractEndDate Changed On
ServiceDocumentCreationDate Created On
PostingDate Posting Date for a Business Transaction
CustomerPurchaseOrderDate Reference Document Date
Column Name Description
ServiceDocumentTemplateType Template Type of CRM Transaction Show values
ServiceDocumentStatus Life Cycle Status Show values
ServiceDocumentHasError Error Status Show values
ServiceDocBillingStatus Billing Status Show values
ServiceDocIsReleasedForBilling Release Status for Cumulated Billing Show values
ServiceDocumentIsOpen Status "Open" Show values
ServiceDocumentIsQuotation Quotation Status Show values
ServiceDocumentIsReleased Release Status Show values
ServiceDocumentIsRejected Cancellation Status Show values
ServiceConfirmationIsFinal Final service confirmation for the related service order Show values
ServiceContractCanclnSts Contract Cancellation Status Show values
ServiceEscalationLevel Escalation Show values
RefInHouseRepairIsExisting Reference to In-House Repair Exists Show values
Column Name Description Domain name
IsCloudSystem null
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ServiceDocumentUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentCharUUID 32 Character CRM Object GUID (Converted)
ReferenceInHouseRepair Reference In-House Repair CRM_OBJECT_ID
ReferenceInHouseRepairItem Reference In-House Repair Item CRMS4_NUMBER_INT
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
ServiceDocumentCreatedByUser User that Created the Transaction UNAME
ServiceDocumentChangedByUser Transaction Last Changed By UNAME
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
RespyMgmtServiceTeam Service Team (Responsibility Management) HROBJID
Master Data Relations Join Conditions
Business Partner: Billing Block Reason
  • Business Partner: Billing Block Reason
  • Client
  • P_SRVCDOCENHCDWITHCLOUDCHECK.BILLINGBLOCKREASON == TVFS.FAKSP
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == TVFS.MANDT
Bill-To Party
  • Bill-To Party
  • Client
  • P_SRVCDOCENHCDWITHCLOUDCHECK.BILLTOPARTY == BUT000.PARTNER
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == BUT000.CLIENT
Activity Category (Communication Type)
  • Activity Category (Communication Type)
  • Client
Customer Contact Person
  • Client
  • Customer Contact Person
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == BUT000.CLIENT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.CONTACTPERSON == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == TVTW.MANDT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • P_SRVCDOCENHCDWITHCLOUDCHECK.DIVISION == TSPA.SPART
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == TSPA.MANDT
Payer
  • Client
  • Payer
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == BUT000.CLIENT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.PAYERPARTY == BUT000.PARTNER
Terms of Payment
  • ?
  • Client
  • Terms of Payment
  • P_SRVCDOCENHCDWITHCLOUDCHECK.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == T052.MANDT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.PAYMENTTERMS == T052.ZTERM
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_SRVCDOCENHCDWITHCLOUDCHECK.[column in domain "KVEWE"] == T683.KVEWE
  • P_SRVCDOCENHCDWITHCLOUDCHECK.[column in domain "KAPPL"] == T683.KAPPL
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == T683.MANDT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.PRICINGPROCEDURE == T683.KALSM
Recommended Priority
  • Recommended Priority
  • Client
  • P_SRVCDOCENHCDWITHCLOUDCHECK.RECOMMENDEDSERVICEPRIORITY == SCPRIO.PRIORITY
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == SCPRIO.CLIENT
Region (State, Province, County)
  • ?
  • Client
  • Region (State, Province, County)
  • P_SRVCDOCENHCDWITHCLOUDCHECK.[column in domain "LAND1"] == T005S.LAND1
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == T005S.MANDT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.REGION == T005S.BLAND
Employee Responsible
  • Client
  • Employee Responsible
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == BUT000.CLIENT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Cancelling Party
  • Client
  • Cancelling Party
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == CRMC_PARTY.CLIENT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SERVICEDOCUMENTCANCLNPARTY == CRMC_PARTY.CANC_PARTY
CRM Service : Reason for Cancellation
  • CRM Service : Reason for Cancellation
  • Client
Impact
  • Client
  • Impact
Activity Priority
  • Activity Priority
  • Client
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == SCPRIO.CLIENT
Problem Category
  • Client
  • Problem Category
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == TVAG.MANDT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SERVICEDOCUMENTREJECTIONREASON == TVAG.ABGRU
Business Transaction Type
  • Client
  • Business Transaction Type
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == CRMC_PROC_TYPE.CLIENT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Urgency
  • Urgency
  • Client
Executing Service Employee
  • Client
  • Executing Service Employee
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == BUT000.CLIENT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SERVICEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat. P_SRVCDOCENHCDWITHCLOUDCHECK.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Risk
  • Client
  • Risk
Service Team
  • Client
  • Service Team
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == BUT000.CLIENT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SERVICETEAM == BUT000.PARTNER
Ship-To Party
  • Ship-To Party
  • Client
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SHIPTOPARTY == BUT000.PARTNER
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == BUT000.CLIENT
Sold-To Party
  • Client
  • Sold-To Party
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == BUT000.CLIENT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == T005.MANDT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SOLDTOPARTYREGION == T005S.BLAND
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == T005S.MANDT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.SOLDTOPARTYCOUNTRY == T005S.LAND1
Currency
  • Client
  • Currency
  • P_SRVCDOCENHCDWITHCLOUDCHECK.MANDT == TCURC.MANDT
  • P_SRVCDOCENHCDWITHCLOUDCHECK.TRANSACTIONCURRENCY == TCURC.WAERS