CRMS4D_GRCL_I

Transparent Table Application Table
195 Fields 2 CDS Views

Grantor Claim Item

CRMS4D_GRCL_I is an SAP database table in S/4HANA. Grantor Claim Item. It contains 195 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_GrantorClaimItem view_entity from EXTENSION Grantor Claim Item - Extension
I_GrantorClaimItem view_entity from BASIC Grantor Claim Item

Fields (195)

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 CRMT_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 CRMT_OBJECT_GUID32 Object GUID
grantee CRMT_SOLD_TO_PART Sold-To Party
grantee_address_number AD_ADDRNUM Address Number
employee_resp CRMT_PERSON_RESP Employee Resp.
grantee_contact CRMT_CONTACT_PERSON Contact Pers.
bill_to_party CRMT_BILL_TO_PART Bill-To Party
payer CRMS4_GRM_PAYER Payer
payment_recipient CRMS4_GRM_PAYMENT_RECIPIENT Payment Recipient
valid_from CRMT_DATE_VALID_FROM Valid From
valid_from_date CRMT_GRM_VALID_FROM Start Date
valid_to CRMT_DATE_VALID_TO Valid To
valid_to_date CRMT_GRM_VALID_TO End Date
due_date CRMS4_GRM_DUE_DATE Due Date
due_date_date CRMT_GRM_DUE_DATE Due Date
expense_date CRMS4_GRM_EXPENSE_DATE Expense Date
expense_date_date CRMT_GRM_EXPENSE_DATE Expense Date
process_type CRMT_PROCESS_TYPE_DB Transaction Type
posting_date CRMT_POSTING_DATE Posting Date
description_h CRMT_PROCESS_DESCRIPTION Description
auth_scope CRM_AUTH_SCOPE Authorization Scope
archiving_flag CRMT_ARCHIVING_FLAG Can Be Archived
grantor_program_id CGPL_EXTID Number
grantor_agreement_id CRMT_OBJECT_ID_DB Transaction ID
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
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_called_off CRMS4_GRM_STAT_CALLED_OFF Status Called Off
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
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 Accounting Indicator
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
net_value_man_i CRMT_NET_VALUE_MAN Exp.Total Value
cost_amount_man CRMT_COST_AMOUNT_MAN Exp. Total Cost
statistical CRMT_STATISTICAL Statist.value
prc_indicator CRMT_PRICING_INDICATOR Pric. indicat.
net_value_i CRMT_NET_VALUE Net Value
net_price_i CRMT_NET_PRICE Net price
tax_amount_i CRMT_TAX_AMOUNT Tax amount
freight_i CRMT_FREIGHT Shipment costs
gross_value_i CRMT_GROSS_VALUE Gross Value
net_wo_freight_i PRCT_NET_VALUE_WITHOUT_FREIGHT Net value
subtotal1 CRMT_SUBTOTAL1 Subtotal 1
subtotal2 CRMT_SUBTOTAL2 Subtotal 2
subtotal3 CRMT_SUBTOTAL3 Subtotal 3
subtotal4 CRMT_SUBTOTAL4 Subtotal 4
subtotal5 CRMT_SUBTOTAL5 Subtotal 5
subtotal6 CRMT_SUBTOTAL6 Subtotal 6
credit_indicator CRMT_CREDIT_INDICATOR Credit
netpr_pric_unit PRCT_COND_PRICING_UNIT Price Unit
netpr_uom PRCT_COND_UOM Condition Unit
total_discount_i PRCT_COND_VALUE Condition Value
target_value CRMS4_TARGET_VALUE Target Value
price_source PRICE_SOURCE Price source
grantor_requested_amount CRMS4_GRM_REQUESTED_AMOUNT Requested Amount
grantor_eligible_amount CRMS4_GRM_ELIGIBLE_AMOUNT Eligible Amount
grantor_authorized_amount CRMS4_GRM_AUTHORIZED_AMOUNT Authorized Amount
grantor_cleared_amount CRMS4_GRM_CLEARED_AMOUNT Cleared Amount
grantor_holdback_amount CRMS4_GRM_HOLDBACK_AMOUNT Holdback Amount
po_number_sold CRMT_PO_NUMBER_SOLD Ext. Ref. Number
rejection CRMT_REJECTION_CODE Cancel Rsn Code
billplan_type CRMT_BILLPLAN_TYPE BillingPlanType
rule_horizon CRMT_RULE_HORIZON Horizon
billplan_start_date CRMT_START_DATE Start date
rule_start_date CRMT_RULE_START_DATE DeterStartDate
billplan_end_date CRMT_END_DATE End Date
rule_end_date CRMT_RULE_END_DATE DeterminEndDate
billplan_date_from CRMT_DATE_FROM Dates from
rule_date_from CRMT_RULE_DATE_FROM DetermineDateFr
billplan_date_to CRMT_DATE_TO Dates to
rule_date_to CRMT_RULE_DATE_TO DetermineDateTo
billplan_timezone CRMT_BILLING_TIMEZONE Time zone
billplan_d_rule_period_date CRMT_RULE_PERIOD_DATE Rule PeriodDate
billplan_d_rule_settl_from CRMT_RULE_SETTL_FROM Determine SePer
billplan_d_rule_settl_to CRMT_RULE_SETTL_TO Settlement end
billplan_d_rule_bill_date CRMT_RULE_BILL_DATE Rule BillDate
billplan_d_rule_price_date CRMS4_RULE_PRICE_DATE Price Date Rule
billplan_d_rule_invcr_date CRMT_RULE_INVCR_DATE Rule: BillDoc
billplan_d_timezone CRMT_BILLING_TIMEZONE Time zone
cashflow_type CRMT_CASHFLOW_TYPE Flow Category
no_billitems CRMT_NO_BILLITEMS No Bill Request Itms
billplan_line_id CRMT_BILLPLAN_LINE_ID BillPlan Line ID
billingplanisfinalized CRMS4_BILLINGPLAN_IS_FINALIZED Bill.Plan Finalized
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 Billing Relevance
katalogart COMT_CATALOG Catalog
codegruppe CRM_QCODEGRP Code Group
code CRM_QCODE Code
agreement_item CRMS4_GRAG_ITEM_NUMBER_INT Agreement Item
grcl_i_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 Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_GRCL_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 [CRMT_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 [CRMT_OBJECT_GUID32]
    GRANTEE,                      -- Sold-To Party [CRMT_SOLD_TO_PART]
    GRANTEE_ADDRESS_NUMBER,       -- Address Number [AD_ADDRNUM]
    EMPLOYEE_RESP,                -- Employee Resp. [CRMT_PERSON_RESP]
    GRANTEE_CONTACT,              -- Contact Pers. [CRMT_CONTACT_PERSON]
    BILL_TO_PARTY,                -- Bill-To Party [CRMT_BILL_TO_PART]
    PAYER,                        -- Payer [CRMS4_GRM_PAYER]
    PAYMENT_RECIPIENT,            -- Payment Recipient [CRMS4_GRM_PAYMENT_RECIPIENT]
    VALID_FROM,                   -- Valid From [CRMT_DATE_VALID_FROM]
    VALID_FROM_DATE,              -- Start Date [CRMT_GRM_VALID_FROM]
    VALID_TO,                     -- Valid To [CRMT_DATE_VALID_TO]
    VALID_TO_DATE,                -- End Date [CRMT_GRM_VALID_TO]
    DUE_DATE,                     -- Due Date [CRMS4_GRM_DUE_DATE]
    DUE_DATE_DATE,                -- Due Date [CRMT_GRM_DUE_DATE]
    EXPENSE_DATE,                 -- Expense Date [CRMS4_GRM_EXPENSE_DATE]
    EXPENSE_DATE_DATE,            -- Expense Date [CRMT_GRM_EXPENSE_DATE]
    PROCESS_TYPE,                 -- Transaction Type [CRMT_PROCESS_TYPE_DB]
    POSTING_DATE,                 -- Posting Date [CRMT_POSTING_DATE]
    DESCRIPTION_H,                -- Description [CRMT_PROCESS_DESCRIPTION]
    AUTH_SCOPE,                   -- Authorization Scope [CRM_AUTH_SCOPE]
    ARCHIVING_FLAG,               -- Can Be Archived [CRMT_ARCHIVING_FLAG]
    GRANTOR_PROGRAM_ID,           -- Number [CGPL_EXTID]
    GRANTOR_AGREEMENT_ID,         -- Transaction ID [CRMT_OBJECT_ID_DB]
    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]
    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_CALLED_OFF,          -- Status Called Off [CRMS4_GRM_STAT_CALLED_OFF]
    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]
    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,                 -- Accounting Indicator [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]
    NET_VALUE_MAN_I,              -- Exp.Total Value [CRMT_NET_VALUE_MAN]
    COST_AMOUNT_MAN,              -- Exp. Total Cost [CRMT_COST_AMOUNT_MAN]
    STATISTICAL,                  -- Statist.value [CRMT_STATISTICAL]
    PRC_INDICATOR,                -- Pric. indicat. [CRMT_PRICING_INDICATOR]
    NET_VALUE_I,                  -- Net Value [CRMT_NET_VALUE]
    NET_PRICE_I,                  -- Net price [CRMT_NET_PRICE]
    TAX_AMOUNT_I,                 -- Tax amount [CRMT_TAX_AMOUNT]
    FREIGHT_I,                    -- Shipment costs [CRMT_FREIGHT]
    GROSS_VALUE_I,                -- Gross Value [CRMT_GROSS_VALUE]
    NET_WO_FREIGHT_I,             -- Net value [PRCT_NET_VALUE_WITHOUT_FREIGHT]
    SUBTOTAL1,                    -- Subtotal 1 [CRMT_SUBTOTAL1]
    SUBTOTAL2,                    -- Subtotal 2 [CRMT_SUBTOTAL2]
    SUBTOTAL3,                    -- Subtotal 3 [CRMT_SUBTOTAL3]
    SUBTOTAL4,                    -- Subtotal 4 [CRMT_SUBTOTAL4]
    SUBTOTAL5,                    -- Subtotal 5 [CRMT_SUBTOTAL5]
    SUBTOTAL6,                    -- Subtotal 6 [CRMT_SUBTOTAL6]
    CREDIT_INDICATOR,             -- Credit [CRMT_CREDIT_INDICATOR]
    NETPR_PRIC_UNIT,              -- Price Unit [PRCT_COND_PRICING_UNIT]
    NETPR_UOM,                    -- Condition Unit [PRCT_COND_UOM]
    TOTAL_DISCOUNT_I,             -- Condition Value [PRCT_COND_VALUE]
    TARGET_VALUE,                 -- Target Value [CRMS4_TARGET_VALUE]
    PRICE_SOURCE,                 -- Price source [PRICE_SOURCE]
    GRANTOR_REQUESTED_AMOUNT,     -- Requested Amount [CRMS4_GRM_REQUESTED_AMOUNT]
    GRANTOR_ELIGIBLE_AMOUNT,      -- Eligible Amount [CRMS4_GRM_ELIGIBLE_AMOUNT]
    GRANTOR_AUTHORIZED_AMOUNT,    -- Authorized Amount [CRMS4_GRM_AUTHORIZED_AMOUNT]
    GRANTOR_CLEARED_AMOUNT,       -- Cleared Amount [CRMS4_GRM_CLEARED_AMOUNT]
    GRANTOR_HOLDBACK_AMOUNT,      -- Holdback Amount [CRMS4_GRM_HOLDBACK_AMOUNT]
    PO_NUMBER_SOLD,               -- Ext. Ref. Number [CRMT_PO_NUMBER_SOLD]
    REJECTION,                    -- Cancel Rsn Code [CRMT_REJECTION_CODE]
    BILLPLAN_TYPE,                -- BillingPlanType [CRMT_BILLPLAN_TYPE]
    RULE_HORIZON,                 -- Horizon [CRMT_RULE_HORIZON]
    BILLPLAN_START_DATE,          -- Start date [CRMT_START_DATE]
    RULE_START_DATE,              -- DeterStartDate [CRMT_RULE_START_DATE]
    BILLPLAN_END_DATE,            -- End Date [CRMT_END_DATE]
    RULE_END_DATE,                -- DeterminEndDate [CRMT_RULE_END_DATE]
    BILLPLAN_DATE_FROM,           -- Dates from [CRMT_DATE_FROM]
    RULE_DATE_FROM,               -- DetermineDateFr [CRMT_RULE_DATE_FROM]
    BILLPLAN_DATE_TO,             -- Dates to [CRMT_DATE_TO]
    RULE_DATE_TO,                 -- DetermineDateTo [CRMT_RULE_DATE_TO]
    BILLPLAN_TIMEZONE,            -- Time zone [CRMT_BILLING_TIMEZONE]
    BILLPLAN_D_RULE_PERIOD_DATE,  -- Rule PeriodDate [CRMT_RULE_PERIOD_DATE]
    BILLPLAN_D_RULE_SETTL_FROM,   -- Determine SePer [CRMT_RULE_SETTL_FROM]
    BILLPLAN_D_RULE_SETTL_TO,     -- Settlement end [CRMT_RULE_SETTL_TO]
    BILLPLAN_D_RULE_BILL_DATE,    -- Rule BillDate [CRMT_RULE_BILL_DATE]
    BILLPLAN_D_RULE_PRICE_DATE,   -- Price Date Rule [CRMS4_RULE_PRICE_DATE]
    BILLPLAN_D_RULE_INVCR_DATE,   -- Rule: BillDoc [CRMT_RULE_INVCR_DATE]
    BILLPLAN_D_TIMEZONE,          -- Time zone [CRMT_BILLING_TIMEZONE]
    CASHFLOW_TYPE,                -- Flow Category [CRMT_CASHFLOW_TYPE]
    NO_BILLITEMS,                 -- No Bill Request Itms [CRMT_NO_BILLITEMS]
    BILLPLAN_LINE_ID,             -- BillPlan Line ID [CRMT_BILLPLAN_LINE_ID]
    BILLINGPLANISFINALIZED,       -- Bill.Plan Finalized [CRMS4_BILLINGPLAN_IS_FINALIZED]
    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,            -- Billing Relevance [CRMS4_BILLING_RELEVANCE]
    KATALOGART,                   -- Catalog [COMT_CATALOG]
    CODEGRUPPE,                   -- Code Group [CRM_QCODEGRP]
    CODE,                         -- Code [CRM_QCODE]
    AGREEMENT_ITEM,               -- Agreement Item [CRMS4_GRAG_ITEM_NUMBER_INT]
    GRCL_I_DUMMY_PS,              -- Single-Character Flag [CHAR1]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT)
);

Learn More