P_ServiceDocLinItmFinData

Service Document Finance Data Line Item Level | view: PSRVCDOCFINITM | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, 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 FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
GLAccountHierarchy FK Financial Statement Version
SemanticTag FK Semantic Tag of a Hierarchy Node
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
ServiceContract FK Service Contract ID
ServiceContractItem FK Service Contract Item ID
ServiceDocument FK Service Document ID
ServiceDocumentItem FK Service Document Item ID
BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem Solution Order Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
RevenueAmountInCompanyCodeCrcy Revenue Amount in Company Code Currency
CostAmountInCompanyCodeCrcy Cost Amount in Company Code Currency
RecognizedMarginAmtInCCCrcy Recognized Margin
YTDSrvcContrRevnAmtInDC Revenue Amount in Company Code Currency
YTDSrvcContrCostInDC Cost Amount in Company Code Currency
YTDSrvcContrPrftMarginAmtInDC Recognized Margin
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
CreationDate Creation Date
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
IsCloudSystem null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_SERVICEDOCLINITMFINDATA.COMPANYCODE == T001.BUKRS
  • P_SERVICEDOCLINITMFINDATA.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_SERVICEDOCLINITMFINDATA.MANDT == TCURC.MANDT
  • P_SERVICEDOCLINITMFINDATA.COMPANYCODECURRENCY == TCURC.WAERS
Distribution Channel
  • Distribution Channel
  • Client
  • P_SERVICEDOCLINITMFINDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_SERVICEDOCLINITMFINDATA.MANDT == TVTW.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_SERVICEDOCLINITMFINDATA.FISCALYEARVARIANT == T009.PERIV
  • P_SERVICEDOCLINITMFINDATA.MANDT == T009.MANDT
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Division
  • Division
  • Client
  • P_SERVICEDOCLINITMFINDATA.ORGANIZATIONDIVISION == TSPA.SPART
  • P_SERVICEDOCLINITMFINDATA.MANDT == TSPA.MANDT
Product Sold
  • Product Sold
  • Client
  • P_SERVICEDOCLINITMFINDATA.PRODUCT == MARA.MATNR
  • P_SERVICEDOCLINITMFINDATA.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • P_SERVICEDOCLINITMFINDATA.PRODUCTGROUP == T023.MATKL
  • P_SERVICEDOCLINITMFINDATA.MANDT == T023.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_SERVICEDOCLINITMFINDATA.SALESORGANIZATION == TVKO.VKORG
  • P_SERVICEDOCLINITMFINDATA.MANDT == TVKO.MANDT
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
Service Contract ID
  • Service Contract ID
  • Client
  • Service Contract Item ID
  • Service Contract Type
  • P_SERVICEDOCLINITMFINDATA.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • P_SERVICEDOCLINITMFINDATA.MANDT == FCO_SRVDOC.MANDT
  • P_SERVICEDOCLINITMFINDATA.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_SERVICEDOCLINITMFINDATA.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Contract Item ID
  • Service Contract ID
  • Client
  • Service Contract Item ID
  • Service Contract Type
  • P_SERVICEDOCLINITMFINDATA.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • P_SERVICEDOCLINITMFINDATA.MANDT == FCO_SRVDOC.MANDT
  • P_SERVICEDOCLINITMFINDATA.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_SERVICEDOCLINITMFINDATA.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Contract Type
  • Client
  • Service Contract Type
Service Document ID
  • Service Document Type
  • Service Document ID
  • Service Document Item ID
  • Client
  • P_SERVICEDOCLINITMFINDATA.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • P_SERVICEDOCLINITMFINDATA.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • P_SERVICEDOCLINITMFINDATA.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_SERVICEDOCLINITMFINDATA.MANDT == FCO_SRVDOC.MANDT
Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Service Document Item ID
  • Client
  • P_SERVICEDOCLINITMFINDATA.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • P_SERVICEDOCLINITMFINDATA.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • P_SERVICEDOCLINITMFINDATA.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_SERVICEDOCLINITMFINDATA.MANDT == FCO_SRVDOC.MANDT
Service Document Type
  • Service Document Type
  • Client
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting