CRMS4_SERV_H_SEARCH

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.

-- Service Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4_SERV_H_SEARCH (
    OBJECT_ID,
    OBJECT_TYPE,
    CATEGORY,
    CATEGORY_TXT,
    CONTACT_PERSON,
    CONTACT_PERSON_LIST,
    CREATED_AT,
    CREATED_BY,
    CURRENCY,
    DESCRIPTION,
    DESCRIPTION_UC,
    GUID,
    HEADER_GUID,
    IMPACT,
    INBOX_STATUS,
    NET_VALUE,
    PAYER,
    PERSON_RESP,
    PERSON_RESP_LIST,
    PO_DATE_SOLD,
    PO_NUMBER_SOLD,
    PO_NUMBER_SOLD_UC,
    POSTING_DATE,
    PRIORITY,
    PRIORITY_TXT,
    PROCESS_TYPE,
    PROCESS_TYPE_TXT,
    RESP_GROUP,
    SERVICE_EMPLOYEE,
    SERVICE_EMPLOYEE_LIST,
    SERVICE_ORG,
    SERVICE_TEAM,
    SERVICE_TEAM_LIST,
    SHIP_TO_PARTY,
    SOLD_TO_PARTY,
    SOLD_TO_PARTY_LIST,
    STAT_ARCHIVABLE,
    STAT_ARCHIVABLE_DESC,
    STAT_ARCHIVED,
    STAT_ARCHIVED_DESC,
    STAT_BILLING,
    STAT_BILLING_DESC,
    STAT_CANCELLED,
    STAT_CANCELLED_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,
    TEMPLATE_TYPE,
    URGENCY,
    VALID_FROM,
    VALID_TO,
    PRIMARY KEY (OBJECT_ID, OBJECT_TYPE)
);