PPS_EKPO_EXT

Transparent Table Application Table
17 Fields 4 CDS Views

PPS: EKPO Extensions - Table

PPS_EKPO_EXT is an SAP database table in S/4HANA. PPS: EKPO Extensions - Table. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_PPS_PurgDocItemExtension view_entity from BASIC Purchase document Item - Extension
PPS_V_EKPO_EXT view left_outer PPS: View on EKPO+PPS_EKPO_EXT
R_PPS_PurContractItemExtension view_entity from BASIC PPS field for Purchase Contract Item
R_PPS_PurOrderItemExtension view_entity from BASIC PPS Fields on Purchase Order Item

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
tolerance_key PPS_E_TOLERANCE_KEY Tolerance Key
ppsoptionexerciseenddate PPS_E_OPT_EXEC_PER_END_DATE Execution End Date
ppsoptionexercisestartdate PPS_E_OPT_EXEC_PER_START_DATE Exe Start Date
ppsoptionalitemstatustext PPS_E_OPT_ITEM_STATUS_TXT Opt Itm Stat Txt
ppsoptionalitemstatus PPS_E_OPT_ITEM_STATUS Optional Item Status
ppsisoptionalitem PPS_E_OPT_ITM Optional Item
pps_ekpo_ext_key PPS_E_EKPO_EXT_DB_KEY Item Key
pps_perop_beg PPS_E_PEROP_START_DATE PeROP Start Date
pps_perop_end PPS_E_PEROP_END_DATE PeROP End Date
pps_itm_smart_number PPS_E_SMT_SMART_NUMBER Smart Number
pps_itm_is_smart_number_manual XFELD Checkbox
pps_config_item_no PPS_E_CONFIG_ITEM_NO Config. Itm. No.
pps_item_status PPS_E_ITEM_STATUS Item Status
kschl KSCHA Condition Type

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.

-- PPS: EKPO Extensions - Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_EKPO_EXT (
    MANDT,                           -- Client [MANDT]
    EBELN,                           -- Purchasing Doc. [EBELN]
    EBELP,                           -- Item [EBELP]
    TOLERANCE_KEY,                   -- Tolerance Key [PPS_E_TOLERANCE_KEY]
    PPSOPTIONEXERCISEENDDATE,        -- Execution End Date [PPS_E_OPT_EXEC_PER_END_DATE]
    PPSOPTIONEXERCISESTARTDATE,      -- Exe Start Date [PPS_E_OPT_EXEC_PER_START_DATE]
    PPSOPTIONALITEMSTATUSTEXT,       -- Opt Itm Stat Txt [PPS_E_OPT_ITEM_STATUS_TXT]
    PPSOPTIONALITEMSTATUS,           -- Optional Item Status [PPS_E_OPT_ITEM_STATUS]
    PPSISOPTIONALITEM,               -- Optional Item [PPS_E_OPT_ITM]
    PPS_EKPO_EXT_KEY,                -- Item Key [PPS_E_EKPO_EXT_DB_KEY]
    PPS_PEROP_BEG,                   -- PeROP Start Date [PPS_E_PEROP_START_DATE]
    PPS_PEROP_END,                   -- PeROP End Date [PPS_E_PEROP_END_DATE]
    PPS_ITM_SMART_NUMBER,            -- Smart Number [PPS_E_SMT_SMART_NUMBER]
    PPS_ITM_IS_SMART_NUMBER_MANUAL,  -- Checkbox [XFELD]
    PPS_CONFIG_ITEM_NO,              -- Config. Itm. No. [PPS_E_CONFIG_ITEM_NO]
    PPS_ITEM_STATUS,                 -- Item Status [PPS_E_ITEM_STATUS]
    KSCHL,                           -- Condition Type [KSCHA]
    PRIMARY KEY (MANDT, EBELN, EBELP)
);

Learn More