- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- SAP S/4HANA Service (CRM-S4)
- S4CRM: Analytics (CRM-S4-ANA)
- S4CRM: Basic Functions (CRM-S4-BF)
- S4CRM: Business Transaction Framework (CRM-S4-BTX)
- S4CRM: Case Management (CRM-S4-CM)
- S4CRM: Complaints (CRM-S4-COM)
- S4CRM: In-House Repair (CRM-S4-IHR)
- S4CRM: Master Data (CRM-S4-MD)
- S4CRM: Pre-Sales & Sales (CRM-S4-SLS)
- S4CRM: Public Services Industry (CRM-S4-IPS)
- S4CRM: Reporting (CRM-S4-REP)
- S4CRM: Service Management (CRM-S4-SRV)
- S4CRM: Solution (CRM-S4-SOL)
- S4CRM: Subscription Order Management (CRM-S4-SOM)
- S4CRM: Utilities Industry (CRM-S4-IU)
- SAP S/4HANA Service (CRM-S4)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_SrvcContrFinQuery_2
Finance Data in Service Contract – Query
| view: CSRVCCONTRFINQY2
| Extraction:
Not supported
| Component: S4CRM: Analytics
Tables used:
SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_SERV_I, IAOM_EXT_OBJ_INF, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, TKA01, CRMS4C_ORGMAN, FINSC_LEDGER, PROJ, T005S, T005U, 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
- 🔑 Keys (8)
- 💰 Amounts (10)
- ∑ Quantities
- 📅 Dates (1)
- ☰ Categorical
- Other (16)
- 🔗 Relations (12)
| Column Name | Description | |
|---|---|---|
| ServiceObjectType FK | Business Trans. Cat. | |
| ServiceContract | Transaction ID | |
| ServiceContractItem | Shortened Item Number in Document | |
| SemanticTag | Semantic Tag of a Hierarchy Node | |
| AccountingDocument | Journal Entry | |
| LedgerGLLineItem | Ledger Journal Entry Item | |
| CompanyCode | Company Code | |
| FiscalYear | Fiscal Year |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (Currency): | ||
| ServiceDocNetAmount | Total Net Value of Service Contract in Display Currency | |
| TotalSrvcContrValueInDC | Total Net Value of Service Contract in Display Currency | |
| AnnualSrvcContrValueInDC | Annual Net Value of Service Contract in Display Currency | |
| TotalAmountInDisplayCrcy | Annual Net Value of Service Contract in Display Currency | |
| TotalSrvcContrRevnAmtInCc | Revenue in Display Currency | |
| TotalSrvcContrCostAmtInCc | Cost 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 | |
| SrvcContrProfitabilityInDC | Profit Margin in Display Currency | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| CreationDate | Creation Date |
| Column Name | Description |
|---|
| Column Name | Description | Domain name | |
|---|---|---|---|
| CalendarYear | Calendar Year | NUM4 | |
| CalendarWeek | Calendar Week | NUM2 | |
| ServiceDocumentIsOpen | Status "Open" | ||
| RegionName | Description | ||
| SalesOrganization | Sales Organization | ||
| SalesOffice | Sales office | ||
| SalesGroup | Sales group | ||
| SalesOrganizationOrgUnitID | Sales Organization ID | ||
| SalesOfficeOrgUnitID | Sales Office | ||
| SalesGroupOrgUnitID | Sales Group | ||
| SoldToPartyFullName | Sold-To Party Name | ||
| RefBusinessSolutionOrder | Reference Solution Order ID | ||
| CalendarQuarter | Calendar Quarter | NUM1 | |
| CalendarQuarterName | Short Text for Fixed Values | ||
| CalendarMonth | Calendar Month | NUM2 | |
| CalendarMonthName | Short Text for Fixed Values |
| Master Data Relations | Join Conditions |
|---|---|
Customer Contact Person
| |
Distribution Channel
| |
Division
| |
Employee Responsible
| |
Business Transaction Type
|
|
Cancelling Party
|
|
CRM Service : Reason for Cancellation
|
|
| Business Trans. Cat. | C_SRVCCONTRFINQUERY_2.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY |
Ship-To Party
| |
Sold-To Party
| |
Country/Region
| |
Region (State, Province, County)
|