CRMS4D_BILLREQ_I

Transparent Table Application Table
24 Fields 3 CDS Views

CRM Billing Request Extension: DB Table

CRMS4D_BILLREQ_I is an SAP database table in S/4HANA. CRM Billing Request Extension: DB Table. It contains 24 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BillingRequestItem view from BASIC Billg Request Line for Srvc Transaction
I_GrntoAgreementBillgReqLine view_entity from BASIC Billing Request Line for Grnto Agreement
I_GrntoClaimBillgReqLine view_entity from BASIC Billing Request Line for Grantor Claim

Fields (24)

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.
KEY record_no CRMS4_BILLING_ITEM_NO Item
record CRMT_OBJECT_GUID Object GUID
settl_from CRMS4_SETTL_FROM_TSTMP SettlementStart
settl_to CRMS4_SETTL_TO_TSTMP Settlement End
period_date CRMS4_PERIOD_DATE_TSTMP Period Date
bill_date CRMS4_BILL_DATE_TSTMP Billing Date
price_date CRMT_PRICE_DATE Pricing Date
billing_block CRMT_BUS_BILL_BLOCK_REASON Bill Block Reason
bill_settl_stat CRM_BILLING_SETTLEMENT_STATUS Settlmnt Status
net_value CRMT_NET_VALUE Net Value
tax_amount CRMT_TAX_AMOUNT Tax amount
gross_value CRMT_GROSS_VALUE Gross Value
grouping_ref_item CRMS4_NUMBER_INT Item Number in Doc.
description CRMT_DESC Description
servicesrendereddate abap.dats
servicesrendereddatetime CRMS4_SRV_RENDER_TSTMP Serv. Rendered Date
credit_indicator CRMT_CREDIT_INDICATOR Credit
billreq_i_usage_type CRMS4_BILLREQ_I_USAGE_TYPE Usage Type
multiplicity PRCT_MULTIPLICITY Multiplier
bill_del_stat CRM_BILLING_DEL_STATUS Deletion 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.

-- CRM Billing Request Extension: DB Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_BILLREQ_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]
    RECORD_NO,                 -- Item [CRMS4_BILLING_ITEM_NO]
    RECORD,                    -- Object GUID [CRMT_OBJECT_GUID]
    SETTL_FROM,                -- SettlementStart [CRMS4_SETTL_FROM_TSTMP]
    SETTL_TO,                  -- Settlement End [CRMS4_SETTL_TO_TSTMP]
    PERIOD_DATE,               -- Period Date [CRMS4_PERIOD_DATE_TSTMP]
    BILL_DATE,                 -- Billing Date [CRMS4_BILL_DATE_TSTMP]
    PRICE_DATE,                -- Pricing Date [CRMT_PRICE_DATE]
    BILLING_BLOCK,             -- Bill Block Reason [CRMT_BUS_BILL_BLOCK_REASON]
    BILL_SETTL_STAT,           -- Settlmnt Status [CRM_BILLING_SETTLEMENT_STATUS]
    NET_VALUE,                 -- Net Value [CRMT_NET_VALUE]
    TAX_AMOUNT,                -- Tax amount [CRMT_TAX_AMOUNT]
    GROSS_VALUE,               -- Gross Value [CRMT_GROSS_VALUE]
    GROUPING_REF_ITEM,         -- Item Number in Doc. [CRMS4_NUMBER_INT]
    DESCRIPTION,               -- Description [CRMT_DESC]
    SERVICESRENDEREDDATE,      -- abap.dats
    SERVICESRENDEREDDATETIME,  -- Serv. Rendered Date [CRMS4_SRV_RENDER_TSTMP]
    CREDIT_INDICATOR,          -- Credit [CRMT_CREDIT_INDICATOR]
    BILLREQ_I_USAGE_TYPE,      -- Usage Type [CRMS4_BILLREQ_I_USAGE_TYPE]
    MULTIPLICITY,              -- Multiplier [PRCT_MULTIPLICITY]
    BILL_DEL_STAT,             -- Deletion Status [CRM_BILLING_DEL_STATUS]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, RECORD_NO)
);

Learn More