CRMS4D_DLVPLAN_I

Transparent Table Application Table
12 Fields 1 CDS Views

Delivery plan lines for the item

CRMS4D_DLVPLAN_I is an SAP database table in S/4HANA. Delivery plan lines for the item. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SrvcDocItemDeliveryPlan view_entity from BASIC Service Document Item Delivery Plan

Fields (12)

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_DLV_RECORD_NO Record Number
next_delivery_datetime CRMS4_DLV_DATETIME Next Delivery Date
delivery_qty CRMS4_DLV_QTY Delivery Quantity
delivery_qty_unit CRMS4_DLV_QTY_UNIT Delivery Qty UoM
delivery_plan_status CRMS4_DLV_PLAN_STATUS Delivery Plan Status
followup_doc_type CRMS4_FOLLOWUP_DOC_TYPE Follow-Up Doc Type
followup_doc_number CRMS4_FOLLOWUP_DOC_NUMBER Follow-Up Doc Number
followup_item_number CRMS4_FOLLOWUP_ITEM_NUMBER Follow-Up Itm Number

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.

-- Delivery plan lines for the item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_DLVPLAN_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,               -- Record Number [CRMS4_DLV_RECORD_NO]
    NEXT_DELIVERY_DATETIME,  -- Next Delivery Date [CRMS4_DLV_DATETIME]
    DELIVERY_QTY,            -- Delivery Quantity [CRMS4_DLV_QTY]
    DELIVERY_QTY_UNIT,       -- Delivery Qty UoM [CRMS4_DLV_QTY_UNIT]
    DELIVERY_PLAN_STATUS,    -- Delivery Plan Status [CRMS4_DLV_PLAN_STATUS]
    FOLLOWUP_DOC_TYPE,       -- Follow-Up Doc Type [CRMS4_FOLLOWUP_DOC_TYPE]
    FOLLOWUP_DOC_NUMBER,     -- Follow-Up Doc Number [CRMS4_FOLLOWUP_DOC_NUMBER]
    FOLLOWUP_ITEM_NUMBER,    -- Follow-Up Itm Number [CRMS4_FOLLOWUP_ITEM_NUMBER]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, RECORD_NO)
);

Learn More