CRMS4D_PAYPLAN_D

Transparent Table Application Table
32 Fields 1 CDS Views

Payment Plan: Payment Card Data

CRMS4D_PAYPLAN_D is an SAP database table in S/4HANA. Payment Plan: Payment Card Data. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ServiceManagementPaymentPlan view_entity from BASIC Service Management Payment Plan

Fields (32)

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 line CRMS4_PAYPLAN_D_LINE Line: Pymt Pln Date
parent_line CRMS4_PAYPLAN_D_PARENT_LINE Prnt Line: PymtPln D
date_type COMT_PAYPLAN_DATE_TYPE Date category
paym_type COMT_PAYM_TYPE Payment Form
sort_int COMT_SORT_INT Internal number
sort_ext COMT_SORT_EXT External number
currency COMT_PAYPLAN_CURRENCY Currency
exch_rate COMT_PAYPLAN_EXCH_RATE Exchange rate
planned_val COMT_PAY_PLANNED_VAL Planned Value
card_token CCTOKEN Token
card_ref_no COMT_CARD_REF_NO Reference Number
auth_limit COMT_AUTH_LIMIT Maximum Amount
auth_limited COMT_AUTH_LIMITED Limited
auth_amount COMT_AUTH_AMOUNT Authorized Amount
auth_used COMT_AUTH_USED Authrztion Used
auth_used_by COMT_AUTH_USED_BY Used By
auth_used_objtyp COMT_AUTH_USED_OBJTYPE Object Type
auth_no COMT_AUTH_NO Authorization Number
auth_ref COMT_AUTH_REF Auth. Ref. Number
auth_pre COMT_AUTH_PRE Preauthorization
auth_timestamp COMT_AUTH_TIMESTAMP Auth. Date
auth_call_status COMT_AUTH_CALL_STATUS Call Status
auth_resp COMT_AUTH_RESP Response
auth_req_amount COMT_AUTH_REQ_AMOUNT Amount to be Author.
auth_type COMT_AUTH_TYPE Authorization type
auth_separate COMT_AUTH_SEPARATE Separate
auth_resp_code COMT_AUTH_RESP_CODE Results Text
auth_exp_timestamp CRMS4T_AUTH_EXP_TIMESTAMP Auth. Exp. Date

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.

-- Payment Plan: Payment Card Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_PAYPLAN_D (
    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]
    LINE,                -- Line: Pymt Pln Date [CRMS4_PAYPLAN_D_LINE]
    PARENT_LINE,         -- Prnt Line: PymtPln D [CRMS4_PAYPLAN_D_PARENT_LINE]
    DATE_TYPE,           -- Date category [COMT_PAYPLAN_DATE_TYPE]
    PAYM_TYPE,           -- Payment Form [COMT_PAYM_TYPE]
    SORT_INT,            -- Internal number [COMT_SORT_INT]
    SORT_EXT,            -- External number [COMT_SORT_EXT]
    CURRENCY,            -- Currency [COMT_PAYPLAN_CURRENCY]
    EXCH_RATE,           -- Exchange rate [COMT_PAYPLAN_EXCH_RATE]
    PLANNED_VAL,         -- Planned Value [COMT_PAY_PLANNED_VAL]
    CARD_TOKEN,          -- Token [CCTOKEN]
    CARD_REF_NO,         -- Reference Number [COMT_CARD_REF_NO]
    AUTH_LIMIT,          -- Maximum Amount [COMT_AUTH_LIMIT]
    AUTH_LIMITED,        -- Limited [COMT_AUTH_LIMITED]
    AUTH_AMOUNT,         -- Authorized Amount [COMT_AUTH_AMOUNT]
    AUTH_USED,           -- Authrztion Used [COMT_AUTH_USED]
    AUTH_USED_BY,        -- Used By [COMT_AUTH_USED_BY]
    AUTH_USED_OBJTYP,    -- Object Type [COMT_AUTH_USED_OBJTYPE]
    AUTH_NO,             -- Authorization Number [COMT_AUTH_NO]
    AUTH_REF,            -- Auth. Ref. Number [COMT_AUTH_REF]
    AUTH_PRE,            -- Preauthorization [COMT_AUTH_PRE]
    AUTH_TIMESTAMP,      -- Auth. Date [COMT_AUTH_TIMESTAMP]
    AUTH_CALL_STATUS,    -- Call Status [COMT_AUTH_CALL_STATUS]
    AUTH_RESP,           -- Response [COMT_AUTH_RESP]
    AUTH_REQ_AMOUNT,     -- Amount to be Author. [COMT_AUTH_REQ_AMOUNT]
    AUTH_TYPE,           -- Authorization type [COMT_AUTH_TYPE]
    AUTH_SEPARATE,       -- Separate [COMT_AUTH_SEPARATE]
    AUTH_RESP_CODE,      -- Results Text [COMT_AUTH_RESP_CODE]
    AUTH_EXP_TIMESTAMP,  -- Auth. Exp. Date [CRMS4T_AUTH_EXP_TIMESTAMP]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, LINE)
);

Learn More