C_ServiceOrderQry2401

Service Orders Actuals | view: CFISERVORDQ2401 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: SCAL_TT_DATE, ACDOCA, BKPF, MARA, T003, T003T, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, T001W, MARA, T023T, T023, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, T016T, PRPS, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE

🔑 Keys
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (1)
☰ Categorical
Other (23)
🔗 Relations (28)

Column Name	Description

Column Name	Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency	Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency	Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency	Amount in Global Currency

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
Quantity	Quantity

Column Name	Description
PostingDate	Posting Date

Column Name	Description

Column Name	Description	Domain name
GLAccountName	G/L Account Short Text	TEXT20
CalendarMonth	Calendar Month	NUM2
CalendarQuarter	Calendar Quarter	NUM1
CalendarWeek	Calendar Week	NUM2
CalendarYear	Calendar Year	NUM4
CompanyCodeName	Name of Company Code or Company	TEXT25
FiscalPeriod	Fiscal Period	POPER
FiscalQuarter	Fiscal Quarter	FINS_FSCALQUARTER
FiscalWeek	Fiscal Week	FINS_FISCALWEEK
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV
FiscalYearQuarter	Fiscal Year + Fiscal Quarter	FINS_FYEARQUARTER
FiscalYearWeek	Fiscal Year + Fiscal Week	FINS_FYEARWEEK
FunctionalAreaName	Name of the Functional Area	TEXT25
AccountingDocument	Journal Entry	BELNR
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
TimeSheetOvertimeCategory	Overtime Category	CATS_OVERTIME_CATEGORY
PersonnelNumber	Personnel Number	PERNR
EmployeeFullName	Full Name	TEXT80
ProfitCenterName	Description of Profit Center	TEXT20
CalendarYearMonth	Year Month	NUM6
CalendarYearQuarter	Year Quarter	NUM5
CalendarYearWeek	Year Week	NUM6

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`C_SERVICEORDERQRY2401.BASEUNIT == T006.MSEHI` `C_SERVICEORDERQRY2401.MANDT == T006.MANDT`
Billable Control Billable Control Client	`C_SERVICEORDERQRY2401.BILLABLECONTROL == TBMOT.BEMOT` `C_SERVICEORDERQRY2401.MANDT == TBMOT.MANDT`
Business Transaction Type Business Transaction Type Client	`C_SERVICEORDERQRY2401.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `C_SERVICEORDERQRY2401.MANDT == FINSC_CUSTBTTYPE.MANDT`
Company Code Company Code Client	`C_SERVICEORDERQRY2401.COMPANYCODE == T001.BUKRS` `C_SERVICEORDERQRY2401.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_SERVICEORDERQRY2401.COMPANYCODECURRENCY == TCURC.WAERS` `C_SERVICEORDERQRY2401.MANDT == TCURC.MANDT`
Customer Number Customer Number Client	`C_SERVICEORDERQRY2401.CUSTOMER == KNA1.KUNNR` `C_SERVICEORDERQRY2401.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`C_SERVICEORDERQRY2401.CUSTOMERGROUP == T151.KDGRP` `C_SERVICEORDERQRY2401.MANDT == T151.MANDT`
Distribution Channel Distribution Channel Client	`C_SERVICEORDERQRY2401.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `C_SERVICEORDERQRY2401.MANDT == TVTW.MANDT`
Equipment Number Equipment Number Client	`C_SERVICEORDERQRY2401.EQUIPMENT == EQUI.EQUNR` `C_SERVICEORDERQRY2401.MANDT == EQUI.MANDT`
Functional Area Functional Area Client	`C_SERVICEORDERQRY2401.FUNCTIONALAREA == TFKB.FKBER` `C_SERVICEORDERQRY2401.MANDT == TFKB.MANDT`
G/L Account G/L Account Company Code Client	`C_SERVICEORDERQRY2401.GLACCOUNT == SKB1.SAKNR` `C_SERVICEORDERQRY2401.COMPANYCODE == SKB1.BUKRS` `C_SERVICEORDERQRY2401.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`C_SERVICEORDERQRY2401.GLOBALCURRENCY == TCURC.WAERS` `C_SERVICEORDERQRY2401.MANDT == TCURC.MANDT`
Division Division Client	`C_SERVICEORDERQRY2401.ORGANIZATIONDIVISION == TSPA.SPART` `C_SERVICEORDERQRY2401.MANDT == TSPA.MANDT`
Partner Cost Center ? ? Client Partner Cost Center	`C_SERVICEORDERQRY2401.[column in domain "DATBI"] == CSKS.DATBI` `C_SERVICEORDERQRY2401.[column in domain "KOKRS"] == CSKS.KOKRS` `C_SERVICEORDERQRY2401.MANDT == CSKS.MANDT` `C_SERVICEORDERQRY2401.PARTNERCOSTCENTER == CSKS.KOSTL`
Partner Cost Center Activity Type ? ? Partner Cost Center Activity Type Client	`C_SERVICEORDERQRY2401.[column in domain "DATBI"] == CSLA.DATBI` `C_SERVICEORDERQRY2401.[column in domain "KOKRS"] == CSLA.KOKRS` `C_SERVICEORDERQRY2401.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_SERVICEORDERQRY2401.MANDT == CSLA.MANDT`
Partner Profit Center ? ? Partner Profit Center Client	`C_SERVICEORDERQRY2401.[column in domain "DATBI"] == CEPC.DATBI` `C_SERVICEORDERQRY2401.[column in domain "KOKRS"] == CEPC.KOKRS` `C_SERVICEORDERQRY2401.PARTNERPROFITCENTER == CEPC.PRCTR` `C_SERVICEORDERQRY2401.MANDT == CEPC.MANDT`
Product Number Product Number Client	`C_SERVICEORDERQRY2401.PRODUCT == MARA.MATNR` `C_SERVICEORDERQRY2401.MANDT == MARA.MANDT`
Profit Center ? ? Profit Center Client	`C_SERVICEORDERQRY2401.[column in domain "DATBI"] == CEPC.DATBI` `C_SERVICEORDERQRY2401.[column in domain "KOKRS"] == CEPC.KOKRS` `C_SERVICEORDERQRY2401.PROFITCENTER == CEPC.PRCTR` `C_SERVICEORDERQRY2401.MANDT == CEPC.MANDT`
Sales Organization Sales Organization Client	`C_SERVICEORDERQRY2401.SALESORGANIZATION == TVKO.VKORG` `C_SERVICEORDERQRY2401.MANDT == TVKO.MANDT`
Service Contract ID Service Contract Item ID Service Contract Type Service Contract ID Client	`C_SERVICEORDERQRY2401.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `C_SERVICEORDERQRY2401.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `C_SERVICEORDERQRY2401.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID` `C_SERVICEORDERQRY2401.MANDT == FCO_SRVDOC.MANDT`
Service Contract Item ID Service Contract Item ID Service Contract Type Service Contract ID Client	`C_SERVICEORDERQRY2401.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `C_SERVICEORDERQRY2401.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `C_SERVICEORDERQRY2401.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID` `C_SERVICEORDERQRY2401.MANDT == FCO_SRVDOC.MANDT`
Service Contract Type Service Contract Type Client	`C_SERVICEORDERQRY2401.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE` `C_SERVICEORDERQRY2401.MANDT == CRMC_PROC_TYPE.CLIENT`
Service Document ID Service Document ID Service Document Type Client Service Document Item ID	`C_SERVICEORDERQRY2401.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `C_SERVICEORDERQRY2401.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `C_SERVICEORDERQRY2401.MANDT == FCO_SRVDOC.MANDT` `C_SERVICEORDERQRY2401.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID`
Service Document Item ID Service Document ID Service Document Type Client Service Document Item ID	`C_SERVICEORDERQRY2401.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `C_SERVICEORDERQRY2401.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `C_SERVICEORDERQRY2401.MANDT == FCO_SRVDOC.MANDT` `C_SERVICEORDERQRY2401.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID`
Service Document Type Service Document Type Client	`C_SERVICEORDERQRY2401.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE` `C_SERVICEORDERQRY2401.MANDT == CRMC_PROC_TYPE.CLIENT`
Product Sold Product Sold Client	`C_SERVICEORDERQRY2401.SOLDPRODUCT == MARA.MATNR` `C_SERVICEORDERQRY2401.MANDT == MARA.MANDT`
Sold Product Group Sold Product Group Client	`C_SERVICEORDERQRY2401.SOLDPRODUCTGROUP == T023.MATKL` `C_SERVICEORDERQRY2401.MANDT == T023.MANDT`
Transaction Currency Transaction Currency Client	`C_SERVICEORDERQRY2401.TRANSACTIONCURRENCY == TCURC.WAERS` `C_SERVICEORDERQRY2401.MANDT == TCURC.MANDT`