CRMS4D_GRCL_H

Transparent Table Application Table
118 Fields 3 CDS Views

Grantor Claim Header

CRMS4D_GRCL_H is an SAP database table in S/4HANA. Grantor Claim Header. It contains 118 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CRMS4_GRCL_H_SEARCH view from Grantor Claim Header Search
E_GrantorClaim view from EXTENSION Grantor Claim - Extension
I_GrantorClaim view_entity from BASIC Grantor Claim

Fields (118)

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
pricing_document KNUMV Doc. Condition
pricing_procedure KALSM_D Procedure
header_guid_char CRMT_OBJECT_GUID32 Object GUID
sdm_status_dura CRMS4_SDM_STATUS_DURA Duration Flag
grantee CRMT_SOLD_TO_PART Customer
employee_resp CRMT_PERSON_RESP Employee Resp.
grantee_contact CRMT_CONTACT_PERSON Contact Pers.
bill_to_party CRMT_BILL_TO_PART Bill-To Party
inbox_assigned_to CRMT_PERSON_RESP Employee Resp.
inbox_group_assigned CRMT_RESPONSIBLE_GROUP Responsible Group
inbox_account CRMT_SALESPARTNER Sales Partners
inbox_contact_person CRMT_CONTACT_PERSON Contact Pers.
valid_from CRMT_DATE_VALID_FROM Valid From
valid_to CRMT_DATE_VALID_TO Valid To
stat_lifecycle CRMS4_STAT_LIFECYCLE Life Cycle Status
stat_released CRMS4_STAT_RELEASED Release Status
stat_open CRMS4_STAT_OPEN Open
stat_archivable CRMS4_STAT_ARCHIVABLE Archivable
stat_archived CRMS4_STAT_ARCHIVED Archived
stat_error CRMS4_STAT_ERROR Error Status
stat_cancelled CRMS4_STAT_CANCELLED Cancellation Status
stat_transfer_ok CRMS4_GRM_STAT_TRANSFER_OK Transferred
stat_transfer_failed CRMS4_GRM_STAT_TRANSFER_FAILED Transfer failed
stat_grm_cancelled CRMS4_GRM_STAT_CANCELLED Cancelled
stat_grm_final_claim CRMS4_GRM_STAT_FINAL_CLAIM Final Claim Indicat.
inbox_status CRMT_AUI_STATUS Status
dis_channel CRMT_DISTRIBUTION_CHANNEL Distribution Channel
division CRMT_DIVISION Division
service_org_ori CRMT_SERVICE_ORG_ORIGIN Origin srvc. org.
service_orgr_ori CRMT_SERVICE_ORG_RESP_ORIGIN Origin Sales Org.
sales_org_ori CRMT_SALES_ORG_ORIGIN Origin sales org.
dis_channel_ori CRMT_DIS_CHANNEL_ORIGIN Origin: Distr. chnl
sales_off_ori CRMT_SALES_OFFICE_ORIGIN Origin: Sales office
sales_group_ori CRMT_SALES_GROUP_ORIGIN Origin: Sales group
sales_orgr_ori CRMT_SALES_ORG_RESP_ORIGIN Origin SOrg
division_ori CRMT_DIVISION_ORIGIN Origin: Division
sales_org CRMT_SALES_ORG Sales Org. ID
sales_office CRMT_SALES_OFFICE Sales Office
sales_group CRMT_SALES_GROUP Sales Group
sales_org_resp CRMT_SALES_ORG_RESP Org. Unit (Sales)
service_org CRMT_SERVICE_ORG Service Organization
service_org_resp CRMT_SERVICE_ORG_RESP OU (Service)
sales_org_sd VKORG Sales Org.
sales_office_sd VKBUR Sales Office
sales_group_sd VKGRP Sales Group
grantor_program_id CGPL_EXTID Number
grantor_agreement_id CRMT_OBJECT_ID_DB Transaction ID
exchg_type CRMT_EXCHG_TYPE Exch. Rate Type
exchg_date CRMT_EXCHG_DATE Exch. Rate Date
taxjurcode CRMT_TAXJURCODE Jurisdict.Code
cust_pric_proc CRMT_CUST_PRIC_PROC Cust.Pric.Proc.
ref_currency CRMT_REF_CURRENCY Ref. Currency
currency CRMT_CURRENCY Currency
price_date CRMT_PRICE_DATE Pricing Date
pmnttrms CRMT_PMNTTRMS Terms of Paymnt
price_grp CRMT_PRICE_GRP Price Group
cust_group CRMT_CUST_GROUP Customer Group
exchg_rate CRMT_EXCHG_RATE Exchange Rate
tax_dest_cty CRMT_TAX_DEST_CTY Dest.Ctry/Reg.
tax_dest_reg CRMT_REGION Region
vat_reg_no CRMT_VAT_REG_NO Sales tax no.
ac_indicator CRMT_AC_INDICATOR Account. Indic.
customer_type CRMT_CUSTOMER_TYPE Part. Type
payment_method CRMT_BUAG_PAYMETH Payment Method
price_list CRMT_PRICE_LIST Price List
pricing_control CRMS4_PRICING_CONTROL Pricing Control
po_number_sold CRMT_PO_NUMBER_SOLD Ext. Reference
rejection CRMT_REJECTION_CODE Cancel Rsn Code
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
dip_profile AD01PROFNR DIP Profile
results_analysis_key ABGR_SCHL_APPL RA Key
billing_relevance CRMS4_BILLING_RELEVANCE Bill. Relevance
grcl_h_dummy_ps 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.

-- Grantor Claim Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_GRCL_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]
    PRICING_DOCUMENT,      -- Doc. Condition [KNUMV]
    PRICING_PROCEDURE,     -- Procedure [KALSM_D]
    HEADER_GUID_CHAR,      -- Object GUID [CRMT_OBJECT_GUID32]
    SDM_STATUS_DURA,       -- Duration Flag [CRMS4_SDM_STATUS_DURA]
    GRANTEE,               -- Customer [CRMT_SOLD_TO_PART]
    EMPLOYEE_RESP,         -- Employee Resp. [CRMT_PERSON_RESP]
    GRANTEE_CONTACT,       -- Contact Pers. [CRMT_CONTACT_PERSON]
    BILL_TO_PARTY,         -- Bill-To Party [CRMT_BILL_TO_PART]
    INBOX_ASSIGNED_TO,     -- Employee Resp. [CRMT_PERSON_RESP]
    INBOX_GROUP_ASSIGNED,  -- Responsible Group [CRMT_RESPONSIBLE_GROUP]
    INBOX_ACCOUNT,         -- Sales Partners [CRMT_SALESPARTNER]
    INBOX_CONTACT_PERSON,  -- Contact Pers. [CRMT_CONTACT_PERSON]
    VALID_FROM,            -- Valid From [CRMT_DATE_VALID_FROM]
    VALID_TO,              -- Valid To [CRMT_DATE_VALID_TO]
    STAT_LIFECYCLE,        -- Life Cycle Status [CRMS4_STAT_LIFECYCLE]
    STAT_RELEASED,         -- Release Status [CRMS4_STAT_RELEASED]
    STAT_OPEN,             -- Open [CRMS4_STAT_OPEN]
    STAT_ARCHIVABLE,       -- Archivable [CRMS4_STAT_ARCHIVABLE]
    STAT_ARCHIVED,         -- Archived [CRMS4_STAT_ARCHIVED]
    STAT_ERROR,            -- Error Status [CRMS4_STAT_ERROR]
    STAT_CANCELLED,        -- Cancellation Status [CRMS4_STAT_CANCELLED]
    STAT_TRANSFER_OK,      -- Transferred [CRMS4_GRM_STAT_TRANSFER_OK]
    STAT_TRANSFER_FAILED,  -- Transfer failed [CRMS4_GRM_STAT_TRANSFER_FAILED]
    STAT_GRM_CANCELLED,    -- Cancelled [CRMS4_GRM_STAT_CANCELLED]
    STAT_GRM_FINAL_CLAIM,  -- Final Claim Indicat. [CRMS4_GRM_STAT_FINAL_CLAIM]
    INBOX_STATUS,          -- Status [CRMT_AUI_STATUS]
    DIS_CHANNEL,           -- Distribution Channel [CRMT_DISTRIBUTION_CHANNEL]
    DIVISION,              -- Division [CRMT_DIVISION]
    SERVICE_ORG_ORI,       -- Origin srvc. org. [CRMT_SERVICE_ORG_ORIGIN]
    SERVICE_ORGR_ORI,      -- Origin Sales Org. [CRMT_SERVICE_ORG_RESP_ORIGIN]
    SALES_ORG_ORI,         -- Origin sales org. [CRMT_SALES_ORG_ORIGIN]
    DIS_CHANNEL_ORI,       -- Origin: Distr. chnl [CRMT_DIS_CHANNEL_ORIGIN]
    SALES_OFF_ORI,         -- Origin: Sales office [CRMT_SALES_OFFICE_ORIGIN]
    SALES_GROUP_ORI,       -- Origin: Sales group [CRMT_SALES_GROUP_ORIGIN]
    SALES_ORGR_ORI,        -- Origin SOrg [CRMT_SALES_ORG_RESP_ORIGIN]
    DIVISION_ORI,          -- Origin: Division [CRMT_DIVISION_ORIGIN]
    SALES_ORG,             -- Sales Org. ID [CRMT_SALES_ORG]
    SALES_OFFICE,          -- Sales Office [CRMT_SALES_OFFICE]
    SALES_GROUP,           -- Sales Group [CRMT_SALES_GROUP]
    SALES_ORG_RESP,        -- Org. Unit (Sales) [CRMT_SALES_ORG_RESP]
    SERVICE_ORG,           -- Service Organization [CRMT_SERVICE_ORG]
    SERVICE_ORG_RESP,      -- OU (Service) [CRMT_SERVICE_ORG_RESP]
    SALES_ORG_SD,          -- Sales Org. [VKORG]
    SALES_OFFICE_SD,       -- Sales Office [VKBUR]
    SALES_GROUP_SD,        -- Sales Group [VKGRP]
    GRANTOR_PROGRAM_ID,    -- Number [CGPL_EXTID]
    GRANTOR_AGREEMENT_ID,  -- Transaction ID [CRMT_OBJECT_ID_DB]
    EXCHG_TYPE,            -- Exch. Rate Type [CRMT_EXCHG_TYPE]
    EXCHG_DATE,            -- Exch. Rate Date [CRMT_EXCHG_DATE]
    TAXJURCODE,            -- Jurisdict.Code [CRMT_TAXJURCODE]
    CUST_PRIC_PROC,        -- Cust.Pric.Proc. [CRMT_CUST_PRIC_PROC]
    REF_CURRENCY,          -- Ref. Currency [CRMT_REF_CURRENCY]
    CURRENCY,              -- Currency [CRMT_CURRENCY]
    PRICE_DATE,            -- Pricing Date [CRMT_PRICE_DATE]
    PMNTTRMS,              -- Terms of Paymnt [CRMT_PMNTTRMS]
    PRICE_GRP,             -- Price Group [CRMT_PRICE_GRP]
    CUST_GROUP,            -- Customer Group [CRMT_CUST_GROUP]
    EXCHG_RATE,            -- Exchange Rate [CRMT_EXCHG_RATE]
    TAX_DEST_CTY,          -- Dest.Ctry/Reg. [CRMT_TAX_DEST_CTY]
    TAX_DEST_REG,          -- Region [CRMT_REGION]
    VAT_REG_NO,            -- Sales tax no. [CRMT_VAT_REG_NO]
    AC_INDICATOR,          -- Account. Indic. [CRMT_AC_INDICATOR]
    CUSTOMER_TYPE,         -- Part. Type [CRMT_CUSTOMER_TYPE]
    PAYMENT_METHOD,        -- Payment Method [CRMT_BUAG_PAYMETH]
    PRICE_LIST,            -- Price List [CRMT_PRICE_LIST]
    PRICING_CONTROL,       -- Pricing Control [CRMS4_PRICING_CONTROL]
    PO_NUMBER_SOLD,        -- Ext. Reference [CRMT_PO_NUMBER_SOLD]
    REJECTION,             -- Cancel Rsn Code [CRMT_REJECTION_CODE]
    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]
    DIP_PROFILE,           -- DIP Profile [AD01PROFNR]
    RESULTS_ANALYSIS_KEY,  -- RA Key [ABGR_SCHL_APPL]
    BILLING_RELEVANCE,     -- Bill. Relevance [CRMS4_BILLING_RELEVANCE]
    GRCL_H_DUMMY_PS,       -- Single-Character Flag [CHAR1]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID)
);

Learn More