PPS_EBAN_EXT

Transparent Table Application Table

PPS: EBAN Extensions - Table

PPS_EBAN_EXT is an SAP database table in S/4HANA. PPS: EBAN Extensions - Table. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PPS_PurReqnHdrExtensionBasic view_entity from BASIC PPS Fields on PR Header Basic
I_PPS_PurReqnItmExtensionBasic view_entity from BASIC PPS Fields on PR Item Basic

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY banfn BANFN Purchase Req.
KEY bnfpo BNFPO Requisn. item
pps_perop_beg PPS_E_PEROP_START_DATE PeROP Start Date
pps_perop_end PPS_E_PEROP_END_DATE PeROP End Date
pps_config_item_no PPS_E_CONFIG_ITEM_NO Config. Itm. No.
acc_asngmt_smt_num CHAR60 Logical System
unfunded BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
pps_itm_cmpltn_sts PPS_E_PR_CMPLTN_STATUS Completion Status
optionalitem PPS_E_OPT_ITM Optional Item
exerperiodstartdate PPS_E_OPT_EXEC_PER_START_DATE Exe Start Date
exerperiodenddate PPS_E_OPT_EXEC_PER_END_DATE Execution End Date
pps_estimated_delivery_date PPS_E_ESTIMATED_DELIVERY_DATE Estimated Deliv Date
responsible_purchaser PPS_E_RESPONSIBLE_PURCHASER Resp. Purchaser
pps_itm_srcg_typ PPS_E_PPR_SRCG_TYPE Sourcing Type
pps_itm_procg_status PPS_E_PR_PROCESSING_STATUS Processing Status
pps_itm_approval_date DATUM Date
pps_item_status PPS_E_ITEM_STATUS Item Status
pps_itm_smart_number PPS_E_SMT_SMART_NUMBER Smart Number
pps_itm_is_smart_number_manual XFELD Checkbox
future_pstng_date PPS_E_FUTURE_BUDAT Future Posting Date
pps_perop_beg_hdr PPS_E_PEROP_START_DATE PeROP Start Date
pps_perop_end_hdr PPS_E_PEROP_END_DATE PeROP End Date
classification PPS_E_CLASSIFICATION Classification
pps_hdr_status PPS_E_HDR_STATUS Status
pps_hdr_smart_number PPS_E_SMT_SMART_NUMBER Smart Number
pps_hdr_is_smart_number_manual XFELD Checkbox

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: EBAN Extensions - Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_EBAN_EXT (
    MANDT,                           -- Client [MANDT]
    BANFN,                           -- Purchase Req. [BANFN]
    BNFPO,                           -- Requisn. item [BNFPO]
    PPS_PEROP_BEG,                   -- PeROP Start Date [PPS_E_PEROP_START_DATE]
    PPS_PEROP_END,                   -- PeROP End Date [PPS_E_PEROP_END_DATE]
    PPS_CONFIG_ITEM_NO,              -- Config. Itm. No. [PPS_E_CONFIG_ITEM_NO]
    ACC_ASNGMT_SMT_NUM,              -- Logical System [CHAR60]
    UNFUNDED,                        -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PPS_ITM_CMPLTN_STS,              -- Completion Status [PPS_E_PR_CMPLTN_STATUS]
    OPTIONALITEM,                    -- Optional Item [PPS_E_OPT_ITM]
    EXERPERIODSTARTDATE,             -- Exe Start Date [PPS_E_OPT_EXEC_PER_START_DATE]
    EXERPERIODENDDATE,               -- Execution End Date [PPS_E_OPT_EXEC_PER_END_DATE]
    PPS_ESTIMATED_DELIVERY_DATE,     -- Estimated Deliv Date [PPS_E_ESTIMATED_DELIVERY_DATE]
    RESPONSIBLE_PURCHASER,           -- Resp. Purchaser [PPS_E_RESPONSIBLE_PURCHASER]
    PPS_ITM_SRCG_TYP,                -- Sourcing Type [PPS_E_PPR_SRCG_TYPE]
    PPS_ITM_PROCG_STATUS,            -- Processing Status [PPS_E_PR_PROCESSING_STATUS]
    PPS_ITM_APPROVAL_DATE,           -- Date [DATUM]
    PPS_ITEM_STATUS,                 -- Item Status [PPS_E_ITEM_STATUS]
    PPS_ITM_SMART_NUMBER,            -- Smart Number [PPS_E_SMT_SMART_NUMBER]
    PPS_ITM_IS_SMART_NUMBER_MANUAL,  -- Checkbox [XFELD]
    FUTURE_PSTNG_DATE,               -- Future Posting Date [PPS_E_FUTURE_BUDAT]
    PPS_PEROP_BEG_HDR,               -- PeROP Start Date [PPS_E_PEROP_START_DATE]
    PPS_PEROP_END_HDR,               -- PeROP End Date [PPS_E_PEROP_END_DATE]
    CLASSIFICATION,                  -- Classification [PPS_E_CLASSIFICATION]
    PPS_HDR_STATUS,                  -- Status [PPS_E_HDR_STATUS]
    PPS_HDR_SMART_NUMBER,            -- Smart Number [PPS_E_SMT_SMART_NUMBER]
    PPS_HDR_IS_SMART_NUMBER_MANUAL,  -- Checkbox [XFELD]
    PRIMARY KEY (MANDT, BANFN, BNFPO)
);