Fields (25)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ServiceDocument | SubscriptionContract | 5 |
| KEY | ServiceDocumentItem | SubscriptionContractItem | 5 |
| CAProviderContractItemUUID | CAProviderContractItemUUID | 1 | |
| contend | contend | 1 | |
| ContractMaterial | ContractMaterial | 1 | |
| description_i | description_i | 1 | |
| Division | Division | 1 | |
| installation | installation | 1 | |
| isu_contract | isu_contract | 1 | |
| order_date | order_date | 1 | |
| ordered_prod | ordered_prod | 1 | |
| partner_prod | partner_prod | 1 | |
| pod_int_ui | pod_int_ui | 1 | |
| premise | premise | 1 | |
| product | product | 1 | |
| product_id | product_id | 1 | |
| product_kind | product_kind | 1 | |
| stat_archivable | stat_archivable | 1 | |
| stat_archived | stat_archived | 1 | |
| stat_cancelled | stat_cancelled | 1 | |
| stat_error | stat_error | 1 | |
| stat_open | stat_open | 1 | |
| stat_quotation | stat_quotation | 1 | |
| stat_released | stat_released | 1 | |
| SubscriptionContract | SubscriptionContractExternalID | 3 |
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 _CONTRACTITEM (
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
CAPROVIDERCONTRACTITEMUUID,
CONTEND,
CONTRACTMATERIAL,
DESCRIPTION_I,
DIVISION,
INSTALLATION,
ISU_CONTRACT,
ORDER_DATE,
ORDERED_PROD,
PARTNER_PROD,
POD_INT_UI,
PREMISE,
PRODUCT,
PRODUCT_ID,
PRODUCT_KIND,
STAT_ARCHIVABLE,
STAT_ARCHIVED,
STAT_CANCELLED,
STAT_ERROR,
STAT_OPEN,
STAT_QUOTATION,
STAT_RELEASED,
SUBSCRIPTIONCONTRACT,
PRIMARY KEY (SERVICEDOCUMENT, SERVICEDOCUMENTITEM)
);
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