SAP table FCO_SRVDOC (Financials View of Service Document)

SAP table FCO_SRVDOC has 4 primary key fields being MANDT,SERVICE_DOC_TYPE,SERVICE_DOC_ID,SERVICE_DOC_ITEM_ID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
SERVICE_DOC_TYPE Service Document Type CHAR 4 0 FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document ID CHAR 10 0 FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item ID NUMC 6 0 FCO_SRVDOC_ITEM_ID
COMPANY_CODE Company Code CHAR 4 0 T001 BUKRS
CONTROLLING_AREA Controlling Area CHAR 4 0 TKA01 KOKRS
PROFIT_CENTER Profit Center CHAR 10 0 CEPC PRCTR
FUNCTIONAL_AREA Functional Area CHAR 16 0 TFKB FKBER
REV_REC_KEY Results Analysis Key CHAR 6 0 TKKAA ABGR_SCHL
OBJECT_CURRENCY Currency Key CUKY 5 0 TCURC OWAER
OBJNR Object number CHAR 22 0 J_OBJNR
OBJNR_SC Object number CHAR 22 0 J_OBJNR
MAIN_ITEM_ID Main Service Document Item ID NUMC 6 0 FCO_MAIN_SRVDOC_ITEM_ID
SOLUTION_ORDER_ID Solution Order ID CHAR 10 0 FCO_SOLUTION_ORDER_ID
SOLUTION_ORDER_ITEM_ID Solution Order Item ID NUMC 6 0 FCO_SOLUTION_ORDER_ITEM_ID
SALES_ORGANIZATION Sales Organization CHAR 4 0 TVKO VKORG
DISTRIBUTION_CHANNEL Distribution Channel CHAR 2 0 TVTW VTWEG
DIVISION Division CHAR 2 0 TSPA SPART
SERVICE_PRODUCT Material Number CHAR 40 0 MARA MATNR
CUSTOMER Customer Number CHAR 10 0 KNA1 KUNNR
BILL_TO_PARTY Bill-to Party CHAR 10 0 KNA1 KUNRE
SHIP_TO_PARTY Ship-to Party CHAR 10 0 KNA1 KUNWE
EQUIPMENT Equipment Number CHAR 18 0 EQUI EQUNR

FCO_SRVDOC foreign key relationships

Table Field Check Table Check Field
0 FCO_SRVDOC BILL_TO_PARTY KNA1 General Data in Customer Master MANDT
0 FCO_SRVDOC BILL_TO_PARTY KNA1 General Data in Customer Master KUNNR
1 FCO_SRVDOC COMPANY_CODE T001 Company Codes BUKRS
0 FCO_SRVDOC CONTROLLING_AREA TKA01 Controlling Areas MANDT
1 FCO_SRVDOC CUSTOMER KNA1 General Data in Customer Master MANDT
1 FCO_SRVDOC CUSTOMER KNA1 General Data in Customer Master KUNNR
0 FCO_SRVDOC DISTRIBUTION_CHANNEL TVTW Organizational Unit: Distribution Channels MANDT
0 FCO_SRVDOC DISTRIBUTION_CHANNEL TVTW Organizational Unit: Distribution Channels VTWEG
1 FCO_SRVDOC DIVISION TSPA Organizational Unit: Sales Divisions MANDT
1 FCO_SRVDOC DIVISION TSPA Organizational Unit: Sales Divisions SPART
0 FCO_SRVDOC EQUIPMENT EQUI Equipment master data MANDT
1 FCO_SRVDOC FUNCTIONAL_AREA TFKB Functional areas FKBER
0 FCO_SRVDOC OBJECT_CURRENCY TCURC Currency Codes MANDT
0 FCO_SRVDOC OBJECT_CURRENCY TCURC Currency Codes WAERS
1 FCO_SRVDOC PROFIT_CENTER CEPC Profit Center Master Data Table PRCTR
1 FCO_SRVDOC PROFIT_CENTER CEPC Profit Center Master Data Table DATBI
1 FCO_SRVDOC PROFIT_CENTER CEPC Profit Center Master Data Table KOKRS
0 FCO_SRVDOC REV_REC_KEY TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
0 FCO_SRVDOC REV_REC_KEY TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
1 FCO_SRVDOC SALES_ORGANIZATION TVKO Organizational Unit: Sales Organizations MANDT
1 FCO_SRVDOC SALES_ORGANIZATION TVKO Organizational Unit: Sales Organizations VKORG
0 FCO_SRVDOC SERVICE_PRODUCT MARA General Material Data MANDT
0 FCO_SRVDOC SERVICE_PRODUCT MARA General Material Data MATNR
1 FCO_SRVDOC SHIP_TO_PARTY KNA1 General Data in Customer Master MANDT
1 FCO_SRVDOC SHIP_TO_PARTY KNA1 General Data in Customer Master KUNNR