CRMS4D_IUCI_I

Transparent Table Application Table
110 Fields 9 CDS Views

OneOrder - Utilities Contract - Item

CRMS4D_IUCI_I is an SAP database table in S/4HANA. OneOrder - Utilities Contract - Item. It contains 110 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
CRMS4_IU_E_CTI view from Utilities Contract Item Extension
CRMS4_IU_I_CTH_DATES view from Determination of dates across contract items
CRMS4_IU_I_CTI view from Utilities Contract Item
CRMS4_IU_I_CTI_DATES view from Determine item dates
CRMS4_IU_I_S_CTI_L view inner Utilities Sales Contract Item Latest
CRMS4_IU_I_S_CTL_DATES view from Utilities Sales Contract Logical Dates
CRMS4_IU_P_S_CTI_L view from Utilities Sales Contract Item Latest
E_UtilitiesSalesContractItem view_entity from EXTENSION Utilities Sales Contract Item - Extension
I_UtilitiesSalesContractItem view_entity from BASIC Utilities Sales Contract Item

Fields (110)

KeyField Data ElementDescription DomainTypeLength
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
installation ANLAGE Installation
pod_int_ui INT_UI PoD
premise VSTELLE Premise
isu_contract VERTRAG Contract
previous_item CRMS4_IU_NUMBER_INT Item Number in Doc.
pf_process CRMS4_IU_PFPROCESSNAME Name of Process
ui_process CRMS4_IU_UIPROCESSNAME Name of UI Process
logical_contract_item CRMS4_IU_LOGICAL_CONTRACT_ITEM Logical Item Ident
salesdocument VBELN_VA Sales Document
salesdocumentitem POSNR_VA Item
person_resp CRMT_PERSON_RESP Employee Resp.
sales_org CRMT_SALES_ORG Sales Org. ID
sales_org_ori CRMT_SALES_ORG_ORIGIN Origin sales org.
sales_org_resp CRMT_SALES_ORG_RESP Org. Unit (Sales)
sales_orgr_ori CRMT_SALES_ORG_RESP_ORIGIN Origin SOrg
sales_office CRMT_SALES_OFFICE Sales Office
sales_off_ori CRMT_SALES_OFFICE_ORIGIN Origin: Sales office
sales_group CRMT_SALES_GROUP Sales Group
sales_group_ori CRMT_SALES_GROUP_ORIGIN Origin: Sales group
dis_channel CRMT_DISTRIBUTION_CHANNEL Distribution Channel
dis_channel_ori CRMT_DIS_CHANNEL_ORIGIN Origin: Distr. chnl
division CRMT_DIVISION Division
division_ori CRMT_DIVISION_ORIGIN Origin: Division
service_org CRMT_SERVICE_ORG Service Organization
service_org_ori CRMT_SERVICE_ORG_ORIGIN Origin srvc. org.
service_org_resp CRMT_SERVICE_ORG_RESP OU (Service)
service_orgr_ori CRMT_SERVICE_ORG_RESP_ORIGIN Origin Sales Org.
contstart CRMS4_CONT_START Contract Start Date
contend CRMS4_CONT_END Contract End Date
srv_cust_beg E_CACTSTARTDATETIME Start Date/Time
srv_cust_end E_CACTENDDATETIME End Date/Time
period_date CRMT_PERIOD_DATE Period date
rule_period_date CRMT_RULE_PERIOD_DATE Rule PeriodDate
settl_from CRMT_SETTL_FROM SettlementStart
rule_settl_from CRMT_RULE_SETTL_FROM Determine SePer
settl_to CRMT_SETTL_TO Settlement End
rule_settl_to CRMT_RULE_SETTL_TO Settlement end
bill_date CRMS4_BILL_DATE_TSTMP Billing Date
rule_bill_date CRMT_RULE_BILL_DATE Rule BillDate
invcr_date CRMS4_INVCR_DATE_TSTMP Billing Date
rule_invcr_date CRMT_RULE_INVCR_DATE Rule: BillDoc
value_date CRMT_VALUE_DATE Fixed Value Dat
rule_value_date CRMT_RULE_VALUE_DATE Value Date Rule
billing_timezone CRMT_BILLING_TIMEZONE Time zone
billing_block CRMT_BUS_BILL_BLOCK_REASON Bill Block Reason
sepa_on CRMT_SEPA_ON SEPA Relevant
mandate_id CRMT_MANDATE_ID Mandate ID
kind_period_date TIMENAEVEN Date type
kind_settl_from TIMENAEVEN Date type
kind_settl_to TIMENAEVEN Date type
kind_bill_date TIMENAEVEN Date type
kind_invcr_date TIMENAEVEN Date type
kind_value_date TIMENAEVEN Date type
kind_start_date TIMENAEVEN Date type
kind_end_date TIMENAEVEN Date type
kind_date_from TIMENAEVEN Date type
kind_date_to TIMENAEVEN Date type
contract_account VKONT_KK Contract Acct
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
cancproc CRMT_CANC_PROCEDURE Cancellation
cancparty CRMT_CANC_PARTY Cancelling Party
canc_reason CRMT_SRV_CANCEL_REASON Cancell.Reason
iuct_i_dummy_ps CHAR1 Single-Character Flag
iuct_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
sdm_status CRMS4_IU_SDM_STATUS SDM Status

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 - Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_IUCI_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]
    INSTALLATION,           -- Installation [ANLAGE]
    POD_INT_UI,             -- PoD [INT_UI]
    PREMISE,                -- Premise [VSTELLE]
    ISU_CONTRACT,           -- Contract [VERTRAG]
    PREVIOUS_ITEM,          -- Item Number in Doc. [CRMS4_IU_NUMBER_INT]
    PF_PROCESS,             -- Name of Process [CRMS4_IU_PFPROCESSNAME]
    UI_PROCESS,             -- Name of UI Process [CRMS4_IU_UIPROCESSNAME]
    LOGICAL_CONTRACT_ITEM,  -- Logical Item Ident [CRMS4_IU_LOGICAL_CONTRACT_ITEM]
    SALESDOCUMENT,          -- Sales Document [VBELN_VA]
    SALESDOCUMENTITEM,      -- Item [POSNR_VA]
    PERSON_RESP,            -- Employee Resp. [CRMT_PERSON_RESP]
    SALES_ORG,              -- Sales Org. ID [CRMT_SALES_ORG]
    SALES_ORG_ORI,          -- Origin sales org. [CRMT_SALES_ORG_ORIGIN]
    SALES_ORG_RESP,         -- Org. Unit (Sales) [CRMT_SALES_ORG_RESP]
    SALES_ORGR_ORI,         -- Origin SOrg [CRMT_SALES_ORG_RESP_ORIGIN]
    SALES_OFFICE,           -- Sales Office [CRMT_SALES_OFFICE]
    SALES_OFF_ORI,          -- Origin: Sales office [CRMT_SALES_OFFICE_ORIGIN]
    SALES_GROUP,            -- Sales Group [CRMT_SALES_GROUP]
    SALES_GROUP_ORI,        -- Origin: Sales group [CRMT_SALES_GROUP_ORIGIN]
    DIS_CHANNEL,            -- Distribution Channel [CRMT_DISTRIBUTION_CHANNEL]
    DIS_CHANNEL_ORI,        -- Origin: Distr. chnl [CRMT_DIS_CHANNEL_ORIGIN]
    DIVISION,               -- Division [CRMT_DIVISION]
    DIVISION_ORI,           -- Origin: Division [CRMT_DIVISION_ORIGIN]
    SERVICE_ORG,            -- Service Organization [CRMT_SERVICE_ORG]
    SERVICE_ORG_ORI,        -- Origin srvc. org. [CRMT_SERVICE_ORG_ORIGIN]
    SERVICE_ORG_RESP,       -- OU (Service) [CRMT_SERVICE_ORG_RESP]
    SERVICE_ORGR_ORI,       -- Origin Sales Org. [CRMT_SERVICE_ORG_RESP_ORIGIN]
    CONTSTART,              -- Contract Start Date [CRMS4_CONT_START]
    CONTEND,                -- Contract End Date [CRMS4_CONT_END]
    SRV_CUST_BEG,           -- Start Date/Time [E_CACTSTARTDATETIME]
    SRV_CUST_END,           -- End Date/Time [E_CACTENDDATETIME]
    PERIOD_DATE,            -- Period date [CRMT_PERIOD_DATE]
    RULE_PERIOD_DATE,       -- Rule PeriodDate [CRMT_RULE_PERIOD_DATE]
    SETTL_FROM,             -- SettlementStart [CRMT_SETTL_FROM]
    RULE_SETTL_FROM,        -- Determine SePer [CRMT_RULE_SETTL_FROM]
    SETTL_TO,               -- Settlement End [CRMT_SETTL_TO]
    RULE_SETTL_TO,          -- Settlement end [CRMT_RULE_SETTL_TO]
    BILL_DATE,              -- Billing Date [CRMS4_BILL_DATE_TSTMP]
    RULE_BILL_DATE,         -- Rule BillDate [CRMT_RULE_BILL_DATE]
    INVCR_DATE,             -- Billing Date [CRMS4_INVCR_DATE_TSTMP]
    RULE_INVCR_DATE,        -- Rule: BillDoc [CRMT_RULE_INVCR_DATE]
    VALUE_DATE,             -- Fixed Value Dat [CRMT_VALUE_DATE]
    RULE_VALUE_DATE,        -- Value Date Rule [CRMT_RULE_VALUE_DATE]
    BILLING_TIMEZONE,       -- Time zone [CRMT_BILLING_TIMEZONE]
    BILLING_BLOCK,          -- Bill Block Reason [CRMT_BUS_BILL_BLOCK_REASON]
    SEPA_ON,                -- SEPA Relevant [CRMT_SEPA_ON]
    MANDATE_ID,             -- Mandate ID [CRMT_MANDATE_ID]
    KIND_PERIOD_DATE,       -- Date type [TIMENAEVEN]
    KIND_SETTL_FROM,        -- Date type [TIMENAEVEN]
    KIND_SETTL_TO,          -- Date type [TIMENAEVEN]
    KIND_BILL_DATE,         -- Date type [TIMENAEVEN]
    KIND_INVCR_DATE,        -- Date type [TIMENAEVEN]
    KIND_VALUE_DATE,        -- Date type [TIMENAEVEN]
    KIND_START_DATE,        -- Date type [TIMENAEVEN]
    KIND_END_DATE,          -- Date type [TIMENAEVEN]
    KIND_DATE_FROM,         -- Date type [TIMENAEVEN]
    KIND_DATE_TO,           -- Date type [TIMENAEVEN]
    CONTRACT_ACCOUNT,       -- Contract Acct [VKONT_KK]
    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]
    CANCPROC,               -- Cancellation [CRMT_CANC_PROCEDURE]
    CANCPARTY,              -- Cancelling Party [CRMT_CANC_PARTY]
    CANC_REASON,            -- Cancell.Reason [CRMT_SRV_CANCEL_REASON]
    IUCT_I_DUMMY_PS,        -- Single-Character Flag [CHAR1]
    IUCT_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]
    SDM_STATUS,             -- SDM Status [CRMS4_IU_SDM_STATUS]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT)
);

Learn More