CRMS4D_IUCP_I
OneOrder - Utilities Contract - Period Item
CRMS4D_IUCP_I is an SAP database table in S/4HANA. OneOrder - Utilities Contract - Period Item. It contains 57 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CRMS4_IU_E_CTP | view | from | Utilities Contract Period Extension | |
| CRMS4_IU_I_CTP | view | from | Utilities Contract Period | |
| CRMS4_IU_I_S_CTP | view | from | Utilities Sales Contract Period | |
| E_UtilsSalesContractPeriod | view_entity | from | EXTENSION | Utilities Sales Contract Period - Extension |
| I_UtilsSalesContractPeriod | view_entity | from | BASIC | Utilities Sales Contract Period |
Fields (57)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | objtype_h | CRMT_SUBOBJECT_CATEGORY_DB | Trans. Cat. | |||
| KEY | object_id | CRMT_OBJECT_ID_DB | Transaction ID | |||
| KEY | number_int | CRMS4_NUMBER_INT | Item Number in Doc. | |||
| item_guid | CRMT_OBJECT_GUID | Object GUID | ||||
| created_at_i | CRMS4_CREATED_AT | Created On | ||||
| created_by_i | CRMT_CREATED_BY | Created By | ||||
| changed_at_i | CRMS4_CHANGED_AT | Changed On | ||||
| changed_by_i | CRMT_CHANGED_BY | Changed By | ||||
| objtype_i | CRMT_SWO_OBJTYP_PROCESS_ITM_DB | Object Type | ||||
| header_guid | CRMT_OBJECT_GUID | Object GUID | ||||
| parent | CRMT_OBJECT_GUID | Object GUID | ||||
| alternative | CRMT_OBJECT_GUID | Object GUID | ||||
| product | CRMT_PRODUCT_GUID_DB | Product GUID | ||||
| ordered_prod | CRMT_ORDERED_PROD_DB | Product | ||||
| partner_prod | CRMT_ITEM_DESCR_PARTNER | Partner Product | ||||
| description_i | CRMT_PRSHTEXTX_DB | Short Text | ||||
| itm_language | CRMT_ITEM_LANGU | Language | ||||
| number_ext | CRMT_ITEM_NO_EXT | Ext. Item No. | ||||
| itm_type | CRMT_ITEM_TYPE_DB | Item Category | ||||
| order_date | CRMS4_ORDER_DATE | Posting Date | ||||
| itm_usage | CRMT_ITEM_USAGE | Usage HL Item | ||||
| itm_type_usage | CRMT_IT_TYPE_USAGE | Item Cat. Usage | ||||
| product_kind | CRMT_PRODUCT_KIND | Prod. Tech. Typ | ||||
| revacc_refid | CRMT_REVACC_REFID | RA Reference ID | ||||
| revacc_reftype | CRMT_REVACC_REFTYPE | RA Reference Type | ||||
| revacc_relevant_type | CRMT_REVACC_RELEVANT_TYPE | Type | ||||
| product_id | PRODUCTNUMBER | Product | ||||
| item_guid_char | CRMS4_OBJECT_CHARGUID32 | Object GUID | ||||
| item_number | CRMS4_IU_CONTRACT_ITEM_NUMBER | Contract Item Number | ||||
| pf_process | CRMS4_IU_PFPROCESSNAME | Name of Process | ||||
| ui_process | CRMS4_IU_UIPROCESSNAME | Name of UI Process | ||||
| contstart | CRMS4_CONT_START | Contract Start Date | ||||
| contend | CRMS4_CONT_END | Contract End Date | ||||
| int_obj_no | CRMT_INT_OBJ_NO | Int. object no. | ||||
| exist_vckey | CRMT_EXIST_VCKEY | IndicVariantKey | ||||
| root_config | CRMT_ROOT_CONFIG | RtCnfIndic | ||||
| stat_lifecycle | CRMS4_STAT_LIFECYCLE | Life Cycle Status | ||||
| stat_released | CRMS4_STAT_RELEASED | Release Status | ||||
| stat_quotation | CRMS4_STAT_QUOTATION | Quotation Status | ||||
| stat_error | CRMS4_STAT_ERROR | Error Status | ||||
| stat_cancelled | CRMS4_STAT_CANCELLED | Cancellation Status | ||||
| stat_open | CRMS4_STAT_OPEN | Open | ||||
| stat_archivable | CRMS4_STAT_ARCHIVABLE | Archivable | ||||
| stat_archived | CRMS4_STAT_ARCHIVED | Archived | ||||
| process_type | CRMT_PROCESS_TYPE_DB | Transaction Type | ||||
| iucp_i_dummy_ps | CHAR1 | Single-Character Flag | ||||
| iucp_i_dummy_tr | CHAR1 | Single-Character Flag | ||||
| item_no_appt | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_partner | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_qualif | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_refobj | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_subject | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_survey | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_billplan | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| item_no_payplan | CRMS4_NUMBER_INT | Item Number in Doc. | ||||
| ref_guid_appt | CRMT_OBJECT_GUID | Object GUID |
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.
-- OneOrder - Utilities Contract - Period Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_IUCP_I (
CLIENT, -- Client [MANDT]
OBJTYPE_H, -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
OBJECT_ID, -- Transaction ID [CRMT_OBJECT_ID_DB]
NUMBER_INT, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_GUID, -- Object GUID [CRMT_OBJECT_GUID]
CREATED_AT_I, -- Created On [CRMS4_CREATED_AT]
CREATED_BY_I, -- Created By [CRMT_CREATED_BY]
CHANGED_AT_I, -- Changed On [CRMS4_CHANGED_AT]
CHANGED_BY_I, -- Changed By [CRMT_CHANGED_BY]
OBJTYPE_I, -- Object Type [CRMT_SWO_OBJTYP_PROCESS_ITM_DB]
HEADER_GUID, -- Object GUID [CRMT_OBJECT_GUID]
PARENT, -- Object GUID [CRMT_OBJECT_GUID]
ALTERNATIVE, -- Object GUID [CRMT_OBJECT_GUID]
PRODUCT, -- Product GUID [CRMT_PRODUCT_GUID_DB]
ORDERED_PROD, -- Product [CRMT_ORDERED_PROD_DB]
PARTNER_PROD, -- Partner Product [CRMT_ITEM_DESCR_PARTNER]
DESCRIPTION_I, -- Short Text [CRMT_PRSHTEXTX_DB]
ITM_LANGUAGE, -- Language [CRMT_ITEM_LANGU]
NUMBER_EXT, -- Ext. Item No. [CRMT_ITEM_NO_EXT]
ITM_TYPE, -- Item Category [CRMT_ITEM_TYPE_DB]
ORDER_DATE, -- Posting Date [CRMS4_ORDER_DATE]
ITM_USAGE, -- Usage HL Item [CRMT_ITEM_USAGE]
ITM_TYPE_USAGE, -- Item Cat. Usage [CRMT_IT_TYPE_USAGE]
PRODUCT_KIND, -- Prod. Tech. Typ [CRMT_PRODUCT_KIND]
REVACC_REFID, -- RA Reference ID [CRMT_REVACC_REFID]
REVACC_REFTYPE, -- RA Reference Type [CRMT_REVACC_REFTYPE]
REVACC_RELEVANT_TYPE, -- Type [CRMT_REVACC_RELEVANT_TYPE]
PRODUCT_ID, -- Product [PRODUCTNUMBER]
ITEM_GUID_CHAR, -- Object GUID [CRMS4_OBJECT_CHARGUID32]
ITEM_NUMBER, -- Contract Item Number [CRMS4_IU_CONTRACT_ITEM_NUMBER]
PF_PROCESS, -- Name of Process [CRMS4_IU_PFPROCESSNAME]
UI_PROCESS, -- Name of UI Process [CRMS4_IU_UIPROCESSNAME]
CONTSTART, -- Contract Start Date [CRMS4_CONT_START]
CONTEND, -- Contract End Date [CRMS4_CONT_END]
INT_OBJ_NO, -- Int. object no. [CRMT_INT_OBJ_NO]
EXIST_VCKEY, -- IndicVariantKey [CRMT_EXIST_VCKEY]
ROOT_CONFIG, -- RtCnfIndic [CRMT_ROOT_CONFIG]
STAT_LIFECYCLE, -- Life Cycle Status [CRMS4_STAT_LIFECYCLE]
STAT_RELEASED, -- Release Status [CRMS4_STAT_RELEASED]
STAT_QUOTATION, -- Quotation Status [CRMS4_STAT_QUOTATION]
STAT_ERROR, -- Error Status [CRMS4_STAT_ERROR]
STAT_CANCELLED, -- Cancellation Status [CRMS4_STAT_CANCELLED]
STAT_OPEN, -- Open [CRMS4_STAT_OPEN]
STAT_ARCHIVABLE, -- Archivable [CRMS4_STAT_ARCHIVABLE]
STAT_ARCHIVED, -- Archived [CRMS4_STAT_ARCHIVED]
PROCESS_TYPE, -- Transaction Type [CRMT_PROCESS_TYPE_DB]
IUCP_I_DUMMY_PS, -- Single-Character Flag [CHAR1]
IUCP_I_DUMMY_TR, -- Single-Character Flag [CHAR1]
ITEM_NO_APPT, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_PARTNER, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_QUALIF, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_REFOBJ, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_SUBJECT, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_SURVEY, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_BILLPLAN, -- Item Number in Doc. [CRMS4_NUMBER_INT]
ITEM_NO_PAYPLAN, -- Item Number in Doc. [CRMS4_NUMBER_INT]
REF_GUID_APPT, -- Object GUID [CRMT_OBJECT_GUID]
PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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