P_SrvcContrLinItmFinConvData

Service Contract Finance Data Conversion Line Item Level | view: PSRVCONTCONVITM | Extraction: Not supported | Component: S4CRM: Analytics
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 Transaction ID
ServiceContractItem Shortened Item Number in Document
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):
TotalSrvcContrValueInDC Total Net Value of Service Contract in Display Currency
ServiceDocumentItemNetAmount Net Value of Service Transaction Item
RevenueAmountInDisplayCrcy Revenue in Display Currency
CostAmountInDisplayCurrency Cost in Display Currency
SrvcContrProfitabilityInDC Profit Margin in Display Currency
YTDSrvcContrRevnAmtInDC Year-to-Date Revenue in Display Currency
YTDSrvcContrCostInDC Year-to-Date Cost in Display Currency
YTDSrvcContrPrftMarginAmtInDC Year-to-Date Profit Margin in Display Currency
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid To Date
CreationDate Creation Date
PostingDate Posting Date
DocumentDate Journal Entry Date
ServiceContractStartDate Created On
ServiceContractEndDate Changed On
Column Name Description
ServiceContractItemStatus Life Cycle Status Show values
ServiceDocumentIsOpen Status "Open" Show values
Column Name Description Domain name
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
RefBusinessSolutionOrderItem Item Number in Referenced Solution Order CRMS4_NUMBER_INT
SoldToPartyFullName Sold-To Party Name TEXT80
FiscalYearVariant Fiscal Year Variant PERIV
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
CalendarQuarter Calendar Quarter NUM1
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
ServiceContractDescription 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
NumberOfDays null
Master Data Relations Join Conditions
Customer Contact Person
  • Client
  • Customer Contact Person
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == BUT000.CLIENT
  • P_SRVCCONTRLINITMFINCONVDATA.CONTACTPERSON == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == TVTW.MANDT
  • P_SRVCCONTRLINITMFINCONVDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == TSPA.MANDT
  • P_SRVCCONTRLINITMFINCONVDATA.DIVISION == TSPA.SPART
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == BUT000.CLIENT
  • P_SRVCCONTRLINITMFINCONVDATA.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • P_SRVCCONTRLINITMFINCONVDATA.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == BUT000.CLIENT
  • P_SRVCCONTRLINITMFINCONVDATA.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • P_SRVCCONTRLINITMFINCONVDATA.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Business Transaction Type
  • Business Transaction Type
  • Client
  • P_SRVCCONTRLINITMFINCONVDATA.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == CRMC_PROC_TYPE.CLIENT
Cancelling Party
  • Cancelling Party
  • Client
  • P_SRVCCONTRLINITMFINCONVDATA.SERVICEDOCUMENTITEMCANCLNPARTY == CRMC_PARTY.CANC_PARTY
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == CRMC_PARTY.CLIENT
CRM Service : Reason for Cancellation
  • Client
  • CRM Service : Reason for Cancellation
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == CRMC_CANCREASON.CLIENT
  • P_SRVCCONTRLINITMFINCONVDATA.SERVICEDOCUMENTITMCANCLNREASON == CRMC_CANCREASON.CANC_REASON
Business Trans. Cat. P_SRVCCONTRLINITMFINCONVDATA.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Ship-To Party
  • Client
  • Ship-To Party
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == BUT000.CLIENT
  • P_SRVCCONTRLINITMFINCONVDATA.SHIPTOPARTY == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == BUT000.CLIENT
  • P_SRVCCONTRLINITMFINCONVDATA.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Country/Region
  • Client
  • P_SRVCCONTRLINITMFINCONVDATA.SOLDTOPARTYCOUNTRY == T005.LAND1
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region
  • Region (State, Province, County)
  • Client
  • P_SRVCCONTRLINITMFINCONVDATA.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • P_SRVCCONTRLINITMFINCONVDATA.SOLDTOPARTYREGION == T005S.BLAND
  • P_SRVCCONTRLINITMFINCONVDATA.MANDT == T005S.MANDT