CRMS4D_SOM_PA

Transparent Table Application Table
29 Fields 1 CDS Views

Charge Plan Parameter

CRMS4D_SOM_PA is an SAP database table in S/4HANA. Charge Plan Parameter. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChargePlanParameter view from BASIC Parameter provided from and used by the charge plan

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY chargeplanparameteruuid CRMS4_SOM_PARAM_UUID Parameter UUID
createdbyuser CRMS4_SOM_CREATED_BY Created By
creationdatetime CRMS4_SOM_CREATED_AT Created At
lastchangedbyuser CRMS4_SOM_CHANGED_BY Changed By
lastchangedatetime CRMS4_SOM_CHANGED_AT Changed At
chargeplanassignmentuuid CRMS4_SOM_CPASSI_UUID Assignment UUID
subscrpnprodspecuuid CRMS4_SOM_PROD_SPCFC_UUID Sub. Prod. Data UUID
chargeplanparameterid CRM_ISX_PARAM_ID Parameter ID
chargeplanparameterdescription CRM_ISX_PARAM_DESC Parameter Descript.
chargeplanparametertype CRM_ISX_PARAM_TYPE Parameter Type
chargeplanparameterusage CRM_ISX_PARAM_USAGE Parameter Usage
chargeplanparameterusevalue CRM_ISX_PARAM_VALSTA Value Used
chrgplanparameternumericvalue CRMS4_SOM_NUMERIC_VALUE Numeric Value
chrgplnparamnmrcdefaultvalue CRMS4_SOM_NUMERIC_VALUE Numeric Value
chargeplanparameterstringvalue CRMS4_SOM_STRING_VALUE_CC String Value
chrgplnparamstringdefaultvalue CRMS4_SOM_STRING_VALUE_CC String Value
chargeplanparameterdatevalue CRMS4_SOM_DATE_VALUE Date Parameter Value
chrgplnparamdatedefaultvalue CRMS4_SOM_DATE_VALUE Date Parameter Value
brffunctionuuid CRMS4_SOM_BRF_UUID BRFplus UUID
chargeplanparameterismandatory CRM_ISX_PARAM_MNDTRY Parameter Is Mandato
convergentchargingtableclassid CRM_ISX_MAPTAB_CLASS Class ID
characteristic ATNAM Characteristic
allowancedefinitiongroupuuid CRMS4_SOM_ADG_UUID Allo. Def. Grp. UUID
allowancedefinitiongroupid CRMS4_SOM_ADG_ID Allo. Def. Group ID
variantcondition VARCOND Variant Key
conditiontype KSCHL Condition Type
chrgplnparampriceismandatory CRMS4_SOM_PARAM_PRICE_IS_MAND Price Param. is Mand
sbschrgplnparamisrlvtforprrtn CRMS4_SOM_PRRTN_REL Relevant for Proration

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.

-- Charge Plan Parameter
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_SOM_PA (
    CLIENT,                          -- Client [MANDT]
    CHARGEPLANPARAMETERUUID,         -- Parameter UUID [CRMS4_SOM_PARAM_UUID]
    CREATEDBYUSER,                   -- Created By [CRMS4_SOM_CREATED_BY]
    CREATIONDATETIME,                -- Created At [CRMS4_SOM_CREATED_AT]
    LASTCHANGEDBYUSER,               -- Changed By [CRMS4_SOM_CHANGED_BY]
    LASTCHANGEDATETIME,              -- Changed At [CRMS4_SOM_CHANGED_AT]
    CHARGEPLANASSIGNMENTUUID,        -- Assignment UUID [CRMS4_SOM_CPASSI_UUID]
    SUBSCRPNPRODSPECUUID,            -- Sub. Prod. Data UUID [CRMS4_SOM_PROD_SPCFC_UUID]
    CHARGEPLANPARAMETERID,           -- Parameter ID [CRM_ISX_PARAM_ID]
    CHARGEPLANPARAMETERDESCRIPTION,  -- Parameter Descript. [CRM_ISX_PARAM_DESC]
    CHARGEPLANPARAMETERTYPE,         -- Parameter Type [CRM_ISX_PARAM_TYPE]
    CHARGEPLANPARAMETERUSAGE,        -- Parameter Usage [CRM_ISX_PARAM_USAGE]
    CHARGEPLANPARAMETERUSEVALUE,     -- Value Used [CRM_ISX_PARAM_VALSTA]
    CHRGPLANPARAMETERNUMERICVALUE,   -- Numeric Value [CRMS4_SOM_NUMERIC_VALUE]
    CHRGPLNPARAMNMRCDEFAULTVALUE,    -- Numeric Value [CRMS4_SOM_NUMERIC_VALUE]
    CHARGEPLANPARAMETERSTRINGVALUE,  -- String Value [CRMS4_SOM_STRING_VALUE_CC]
    CHRGPLNPARAMSTRINGDEFAULTVALUE,  -- String Value [CRMS4_SOM_STRING_VALUE_CC]
    CHARGEPLANPARAMETERDATEVALUE,    -- Date Parameter Value [CRMS4_SOM_DATE_VALUE]
    CHRGPLNPARAMDATEDEFAULTVALUE,    -- Date Parameter Value [CRMS4_SOM_DATE_VALUE]
    BRFFUNCTIONUUID,                 -- BRFplus UUID [CRMS4_SOM_BRF_UUID]
    CHARGEPLANPARAMETERISMANDATORY,  -- Parameter Is Mandato [CRM_ISX_PARAM_MNDTRY]
    CONVERGENTCHARGINGTABLECLASSID,  -- Class ID [CRM_ISX_MAPTAB_CLASS]
    CHARACTERISTIC,                  -- Characteristic [ATNAM]
    ALLOWANCEDEFINITIONGROUPUUID,    -- Allo. Def. Grp. UUID [CRMS4_SOM_ADG_UUID]
    ALLOWANCEDEFINITIONGROUPID,      -- Allo. Def. Group ID [CRMS4_SOM_ADG_ID]
    VARIANTCONDITION,                -- Variant Key [VARCOND]
    CONDITIONTYPE,                   -- Condition Type [KSCHL]
    CHRGPLNPARAMPRICEISMANDATORY,    -- Price Param. is Mand [CRMS4_SOM_PARAM_PRICE_IS_MAND]
    SBSCHRGPLNPARAMISRLVTFORPRRTN,   -- Relevant for Proration [CRMS4_SOM_PRRTN_REL]
    PRIMARY KEY (CLIENT, CHARGEPLANPARAMETERUUID)
);

Learn More