P_SrvcDocRevenueFor2Years

Service Document Revenue for Last year and Current year | view: PSRVCDOCREVYRS | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_SERV_I, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, TKA01, CRMS4C_ORGMAN, FINSC_LEDGER, PROJ, T000, HRRP_FSV_DIR, USR21, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, USR05, FAAC_KFC_SPEC, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Ledger Ledger in General Ledger Accounting
SourceLedger Source Ledger
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
GLAccountHierarchy Financial Statement Version
SemanticTag Semantic Tag of a Hierarchy Node
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
ServiceContract Service Contract ID
ServiceContractItem Service Contract Item ID
ServiceDocument Service Document ID
ServiceDocumentItem Service Document Item ID
Column Name Description
💲 Currency Key (DisplayCurrency):
RevenueAmountInDisplayCrcy null
ServiceDocumentItemNetAmount null
CostAmountInDisplayCurrency null
YTDSrvcContrRevnAmtInDC null
YTDSrvcContrCostInDC null
YTDSrvcContrPrftMarginAmtInDC null
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
CreationDate Creation Date
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
Column Name Description Domain name
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ServiceContractType Service Contract Type CRM_PROCESS_TYPE
Product Product Sold MATNR
ProductGroup Product Sold Group MATKL
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
FiscalYearVariant Fiscal Year Variant PERIV
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • P_SRVCDOCREVENUEFOR2YEARS.MANDT == TVTW.MANDT
  • P_SRVCDOCREVENUEFOR2YEARS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SRVCDOCREVENUEFOR2YEARS.MANDT == TSPA.MANDT
  • P_SRVCDOCREVENUEFOR2YEARS.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • P_SRVCDOCREVENUEFOR2YEARS.MANDT == BUT000.CLIENT
  • P_SRVCDOCREVENUEFOR2YEARS.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Business Trans. Cat. P_SRVCDOCREVENUEFOR2YEARS.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY