P_ServiceDocLinItmFinConvData

Service Document Finance Data Conversion Line Item Level | view: PSRVCDOCCONVITM | 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, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, USR05, FAAC_KFC_SPEC, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Ledger FK 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
💲 Company Code Currency (CompanyCodeCurrency):
RecognizedMarginAmtInCCCrcy Recognized Margin
RevenueAmountInCompanyCodeCrcy Revenue Amount in Company Code Currency
CostAmountInCompanyCodeCrcy Cost Amount in Company Code Currency
💲 Currency Key (DisplayCurrency):
ServiceDocumentItemNetAmount null
RevenueAmountInDisplayCrcy null
CostAmountInDisplayCurrency null
SrvcContrProfitabilityInDC 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
FiscalYearVariant Fiscal Year Variant PERIV
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
Product Product Sold MATNR
ProductGroup Product Sold Group MATKL
CalendarQuarter Calendar Quarter NUM1
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
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_SERVICEDOCLINITMFINCONVDATA.MANDT == TVTW.MANDT
  • P_SERVICEDOCLINITMFINCONVDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • P_SERVICEDOCLINITMFINCONVDATA.DIVISION == TSPA.SPART
  • P_SERVICEDOCLINITMFINCONVDATA.MANDT == TSPA.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Employee Responsible
  • Employee Responsible
  • Client
  • P_SERVICEDOCLINITMFINCONVDATA.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • P_SERVICEDOCLINITMFINCONVDATA.MANDT == BUT000.CLIENT
Business Trans. Cat. P_SERVICEDOCLINITMFINCONVDATA.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY