P_SrvcDocIntOrdFinData

Service Document Internal Order Finance Data | view: PSRVCINTORDDAT | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, IAOM_EXT_OBJ_INF, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, TKA01, CRMS4C_ORGMAN, FINSC_LEDGER, PROJ, T000, HRRP_FSV_DIR, AUFK, IAOM_ASSIGNMENTS, IAOM_CRMSRV_EXAT, 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
OrderID FK Order ID
OrderItem Order item number
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
AccountAssignment Account Assignment ACCAS
ServiceDocument Transaction CRM_OBJECT_ID_CO
ServiceDocumentType Business Transaction Type CRM_PROCESS_TYPE_CO
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
IsCloudSystem null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_SRVCDOCINTORDFINDATA.MANDT == T001.MANDT
  • P_SRVCDOCINTORDFINDATA.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • P_SRVCDOCINTORDFINDATA.COMPANYCODECURRENCY == TCURC.WAERS
  • P_SRVCDOCINTORDFINDATA.MANDT == TCURC.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • P_SRVCDOCINTORDFINDATA.MANDT == TVTW.MANDT
  • P_SRVCDOCINTORDFINDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_SRVCDOCINTORDFINDATA.FISCALYEARVARIANT == T009.PERIV
  • P_SRVCDOCINTORDFINDATA.MANDT == T009.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Order ID
  • Order ID
  • Client
  • P_SRVCDOCINTORDFINDATA.ORDERID == AUFK.AUFNR
  • P_SRVCDOCINTORDFINDATA.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • P_SRVCDOCINTORDFINDATA.MANDT == TSPA.MANDT
  • P_SRVCDOCINTORDFINDATA.ORGANIZATIONDIVISION == TSPA.SPART
Sales Organization
  • Sales Organization
  • Client
  • P_SRVCDOCINTORDFINDATA.SALESORGANIZATION == TVKO.VKORG
  • P_SRVCDOCINTORDFINDATA.MANDT == TVKO.MANDT
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger