Fields (49)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| bill_to_party | bill_to_party_i | 1 | |
| bill_to_party_list | bill_to_party_list_i | 1 | |
| contact_person | contact_person_i | 1 | |
| contact_person_list | contact_person_list_i | 1 | |
| description | REFOBJ_PRODUCT_NAME | 1 | |
| item_guid | item_guid | 1 | |
| itm_type | itm_type | 1 | |
| number_int | number_int | 1 | |
| ordered_prod | refobj_product_id | 1 | |
| payer | payer_i | 1 | |
| payer_list | payer_list_i | 1 | |
| person_resp | person_resp_i | 1 | |
| person_resp_list | person_resp_list_i | 1 | |
| resp_group | resp_group_i | 1 | |
| resp_group_list | resp_group_list_i | 1 | |
| service_employee | service_employee_i | 1 | |
| service_employee_list | service_employee_list_i | 1 | |
| service_team | service_team_i | 1 | |
| service_team_list | service_team_list_i | 1 | |
| ship_to_party | ship_to_party_i | 1 | |
| ship_to_party_list | ship_to_party_list_i | 1 | |
| sold_to_country | sold_to_country_i | 1 | |
| sold_to_party | sold_to_party_i | 1 | |
| sold_to_party_list | sold_to_party_list_i | 1 | |
| sold_to_region | sold_to_region_i | 1 | |
| stat_activation | stat_activation_i | 1 | |
| stat_activation_desc | stat_activation_desc_i | 1 | |
| stat_billing | stat_billing_i | 1 | |
| stat_billing_desc | stat_billing_desc_i | 1 | |
| stat_cancelled | stat_cancelled_i | 1 | |
| stat_cancelled_desc | stat_cancelled_desc_i | 1 | |
| stat_chklst_exec | stat_chklst_exec_i | 1 | |
| stat_chklst_exec_desc | stat_chklst_exec_desc_i | 1 | |
| stat_cont_ts | stat_cont_ts_i | 1 | |
| stat_cont_ts_desc | stat_cont_ts_desc_i | 1 | |
| stat_delivery | stat_delivery_i | 1 | |
| stat_delivery_desc | stat_delivery_desc_i | 1 | |
| stat_error | stat_error_i | 1 | |
| stat_error_desc | stat_error_desc_i | 1 | |
| stat_for_billing | stat_for_billing_i | 1 | |
| stat_for_billing_desc | stat_for_billing_desc_i | 1 | |
| stat_goods_issue | stat_goods_issue_i | 1 | |
| stat_goods_issue_desc | stat_goods_issue_desc_i | 1 | |
| stat_lifecycle | stat_lifecycle_i | 1 | |
| stat_lifecycle_desc | stat_lifecycle_desc_i | 1 | |
| stat_quotation | stat_quotation_i | 1 | |
| stat_quotation_desc | stat_quotation_desc_i | 1 | |
| stat_released | stat_released_i | 1 | |
| stat_released_desc | stat_released_desc_i | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SRVI (
BILL_TO_PARTY,
BILL_TO_PARTY_LIST,
CONTACT_PERSON,
CONTACT_PERSON_LIST,
DESCRIPTION,
ITEM_GUID,
ITM_TYPE,
NUMBER_INT,
ORDERED_PROD,
PAYER,
PAYER_LIST,
PERSON_RESP,
PERSON_RESP_LIST,
RESP_GROUP,
RESP_GROUP_LIST,
SERVICE_EMPLOYEE,
SERVICE_EMPLOYEE_LIST,
SERVICE_TEAM,
SERVICE_TEAM_LIST,
SHIP_TO_PARTY,
SHIP_TO_PARTY_LIST,
SOLD_TO_COUNTRY,
SOLD_TO_PARTY,
SOLD_TO_PARTY_LIST,
SOLD_TO_REGION,
STAT_ACTIVATION,
STAT_ACTIVATION_DESC,
STAT_BILLING,
STAT_BILLING_DESC,
STAT_CANCELLED,
STAT_CANCELLED_DESC,
STAT_CHKLST_EXEC,
STAT_CHKLST_EXEC_DESC,
STAT_CONT_TS,
STAT_CONT_TS_DESC,
STAT_DELIVERY,
STAT_DELIVERY_DESC,
STAT_ERROR,
STAT_ERROR_DESC,
STAT_FOR_BILLING,
STAT_FOR_BILLING_DESC,
STAT_GOODS_ISSUE,
STAT_GOODS_ISSUE_DESC,
STAT_LIFECYCLE,
STAT_LIFECYCLE_DESC,
STAT_QUOTATION,
STAT_QUOTATION_DESC,
STAT_RELEASED,
STAT_RELEASED_DESC
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA