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 are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
FCO_SRVDOC columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||
| KeySERVICE_DOC_TYPE | Service Document Type | CHAR | 4 | 0 | FCO_SRVDOC_TYPE | ||
| KeySERVICE_DOC_ID | Service Document ID | CHAR | 10 | 0 | FCO_SRVDOC_ID | ||
| KeySERVICE_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 |
/ Relationships
FCO_SRVDOC foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| FCO_SRVDOC | BILL_TO_PARTY | KNA1 | General Data in Customer Master | MANDT |
| FCO_SRVDOC | BILL_TO_PARTY | KNA1 | General Data in Customer Master | KUNNR |
| FCO_SRVDOC | COMPANY_CODE | T001 | Company Codes | BUKRS |
| FCO_SRVDOC | CONTROLLING_AREA | TKA01 | Controlling Areas | MANDT |
| FCO_SRVDOC | CUSTOMER | KNA1 | General Data in Customer Master | MANDT |
| FCO_SRVDOC | CUSTOMER | KNA1 | General Data in Customer Master | KUNNR |
| FCO_SRVDOC | DISTRIBUTION_CHANNEL | TVTW | Organizational Unit: Distribution Channels | MANDT |
| FCO_SRVDOC | DISTRIBUTION_CHANNEL | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| FCO_SRVDOC | DIVISION | TSPA | Organizational Unit: Sales Divisions | MANDT |
| FCO_SRVDOC | DIVISION | TSPA | Organizational Unit: Sales Divisions | SPART |
| FCO_SRVDOC | EQUIPMENT | EQUI | Equipment master data | MANDT |
| FCO_SRVDOC | FUNCTIONAL_AREA | TFKB | Functional areas | FKBER |
| FCO_SRVDOC | OBJECT_CURRENCY | TCURC | Currency Codes | MANDT |
| FCO_SRVDOC | OBJECT_CURRENCY | TCURC | Currency Codes | WAERS |
| FCO_SRVDOC | PROFIT_CENTER | CEPC | Profit Center Master Data Table | PRCTR |
| FCO_SRVDOC | PROFIT_CENTER | CEPC | Profit Center Master Data Table | DATBI |
| FCO_SRVDOC | PROFIT_CENTER | CEPC | Profit Center Master Data Table | KOKRS |
| FCO_SRVDOC | REV_REC_KEY | TKKAA | Check Table for Results Analysis Key of RA for Orders | MANDT |
| FCO_SRVDOC | REV_REC_KEY | TKKAA | Check Table for Results Analysis Key of RA for Orders | ABGSL |
| FCO_SRVDOC | SALES_ORGANIZATION | TVKO | Organizational Unit: Sales Organizations | MANDT |
| FCO_SRVDOC | SALES_ORGANIZATION | TVKO | Organizational Unit: Sales Organizations | VKORG |
| FCO_SRVDOC | SERVICE_PRODUCT | MARA | General Material Data | MANDT |
| FCO_SRVDOC | SERVICE_PRODUCT | MARA | General Material Data | MATNR |
| FCO_SRVDOC | SHIP_TO_PARTY | KNA1 | General Data in Customer Master | MANDT |
| FCO_SRVDOC | SHIP_TO_PARTY | KNA1 | General Data in Customer Master | KUNNR |