CRMS4D_IUCH_H

Transparent Table Application Table
58 Fields 5 CDS Views

OneOrder - Utilities Contract - Header

CRMS4D_IUCH_H is an SAP database table in S/4HANA. OneOrder - Utilities Contract - Header. It contains 58 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
CRMS4_IU_E_CTH view from Utilities Contract Header Extension
CRMS4_IU_I_CTH view from Utilities Contract Header
CRMS4_IU_I_S_CTH view from Utilities Sales Contract
E_UtilitiesSalesContract view_entity from EXTENSION Utilities Sales Contract - Extension
I_UtilitiesSalesContract view_entity from BASIC Utilities Sales Contract

Fields (58)

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
header_guid CRMT_OBJECT_GUID Object GUID
process_type CRMT_PROCESS_TYPE_DB Transaction Type
posting_date CRMT_POSTING_DATE Posting Date
description_h CRMT_PROCESS_DESCRIPTION Description
descr_language CRMT_PROCESS_DESCRIPTION_LANGU Language
template_type CRMT_TEMPLATE_TYPE_DB Templ. Type
created_at_h CRMS4_CREATED_AT Created On
created_by_h CRMT_CREATED_BY Created By
changed_at_h CRMS4_CHANGED_AT Changed On
changed_by_h CRMT_CHANGED_BY Changed By
head_changed_at CRMT_CHANGED_AT Changed On
btx_class CRMT_TRANSACTION_CLASSIFICATN Trans.Classification
auth_scope CRM_AUTH_SCOPE Authorization Scope
archiving_flag CRMT_ARCHIVING_FLAG Can Be Archived
object_id_ok CRMT_OBJECT_ID_OK ID Valid
verify_date CRMT_VERIFY_DATE Verify Date
header_guid_char CRMS4_OBJECT_CHARGUID32 Object GUID
dummy CHAR1 Single-Character Flag
sold_to_party CRMT_SOLD_TO_PART Customer
sold_to_region CRMT_REGION Region
sold_to_country CRMT_COUNTRY Country/Region
ship_to_party CRMT_SHIP_TO_PART Ship-To Party
bill_to_party CRMT_BILL_TO_PART Bill-To Party
payer CRMT_RP_PAYER Payer
person_resp CRMT_PERSON_RESP Employee Resp.
contact_person CRMT_CONTACT_PERSON Contact Pers.
resp_group CRMT_RESPONSIBLE_GROUP Responsible Group
service_team CRMT_SERVICE_TEAM Service Team
service_employee CRMT_SERVICE_EMPLOYEE Exec.Service Emp.
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.
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
iuct_h_dummy_ps CHAR1 Single-Character Flag
iuct_h_dummy_tr CHAR1 Single-Character Flag

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 - Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_IUCH_H (
    CLIENT,            -- Client [MANDT]
    OBJTYPE_H,         -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,         -- Transaction ID [CRMT_OBJECT_ID_DB]
    HEADER_GUID,       -- Object GUID [CRMT_OBJECT_GUID]
    PROCESS_TYPE,      -- Transaction Type [CRMT_PROCESS_TYPE_DB]
    POSTING_DATE,      -- Posting Date [CRMT_POSTING_DATE]
    DESCRIPTION_H,     -- Description [CRMT_PROCESS_DESCRIPTION]
    DESCR_LANGUAGE,    -- Language [CRMT_PROCESS_DESCRIPTION_LANGU]
    TEMPLATE_TYPE,     -- Templ. Type [CRMT_TEMPLATE_TYPE_DB]
    CREATED_AT_H,      -- Created On [CRMS4_CREATED_AT]
    CREATED_BY_H,      -- Created By [CRMT_CREATED_BY]
    CHANGED_AT_H,      -- Changed On [CRMS4_CHANGED_AT]
    CHANGED_BY_H,      -- Changed By [CRMT_CHANGED_BY]
    HEAD_CHANGED_AT,   -- Changed On [CRMT_CHANGED_AT]
    BTX_CLASS,         -- Trans.Classification [CRMT_TRANSACTION_CLASSIFICATN]
    AUTH_SCOPE,        -- Authorization Scope [CRM_AUTH_SCOPE]
    ARCHIVING_FLAG,    -- Can Be Archived [CRMT_ARCHIVING_FLAG]
    OBJECT_ID_OK,      -- ID Valid [CRMT_OBJECT_ID_OK]
    VERIFY_DATE,       -- Verify Date [CRMT_VERIFY_DATE]
    HEADER_GUID_CHAR,  -- Object GUID [CRMS4_OBJECT_CHARGUID32]
    DUMMY,             -- Single-Character Flag [CHAR1]
    SOLD_TO_PARTY,     -- Customer [CRMT_SOLD_TO_PART]
    SOLD_TO_REGION,    -- Region [CRMT_REGION]
    SOLD_TO_COUNTRY,   -- Country/Region [CRMT_COUNTRY]
    SHIP_TO_PARTY,     -- Ship-To Party [CRMT_SHIP_TO_PART]
    BILL_TO_PARTY,     -- Bill-To Party [CRMT_BILL_TO_PART]
    PAYER,             -- Payer [CRMT_RP_PAYER]
    PERSON_RESP,       -- Employee Resp. [CRMT_PERSON_RESP]
    CONTACT_PERSON,    -- Contact Pers. [CRMT_CONTACT_PERSON]
    RESP_GROUP,        -- Responsible Group [CRMT_RESPONSIBLE_GROUP]
    SERVICE_TEAM,      -- Service Team [CRMT_SERVICE_TEAM]
    SERVICE_EMPLOYEE,  -- Exec.Service Emp. [CRMT_SERVICE_EMPLOYEE]
    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]
    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]
    IUCT_H_DUMMY_PS,   -- Single-Character Flag [CHAR1]
    IUCT_H_DUMMY_TR,   -- Single-Character Flag [CHAR1]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID)
);

Learn More