EBAN_TECH

Transparent Table Application Table
19 Fields 3 CDS Views

Purchase Requisition for External Sourcing

EBAN_TECH is an SAP database table in S/4HANA. Purchase Requisition for External Sourcing. It contains 19 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FNDEI_EBAN_TECH_BLOCKINGINFO view from Filter View for table EBAN_TECH
FNDEI_EBAN_TECH_FILTER view from Filter View for table EBAN_TECH
I_ExternalRefForPurReqnItm view from BASIC Purchase Reqn Item External Reference

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY banfn banfn Purchase Req.
KEY bnfpo bnfpo Requisn. item
proc_status mereq_proc_type Processing State
proc_date mmpur_utc Timestamp
ext_proc_status mereq_proc_status Processing State
ext_proc_date mmpur_utc Timestamp
activity mmpur_activity_ty Activity for Purchase Requisition Item in External Sourcing
ext_doc_number me_pur_ext_doc_id External Document
ext_doc_item me_pur_ext_doc_item_id External Item
ext_doc_type me_pur_ext_doc_type Ext. Document Type
create_ind estkz Creation ind.
state mereq_state Status Description
sc_object_id /srmerp/object_id Object ID
sc_itm_no /srmerp/sc_itm_no Int. SC Itm No.
ext_rel_state mmpur_ext_rel_state Status Ext. Release
ext_rel_date mmpur_ext_rel_date Time Ext. Release
ext_system_id mmpur_ext_system External System ID
ext_system_type mmpur_ext_systype External System 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.

-- Purchase Requisition for External Sourcing
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EBAN_TECH (
    MANDT,            -- Client [mandt]
    BANFN,            -- Purchase Req. [banfn]
    BNFPO,            -- Requisn. item [bnfpo]
    PROC_STATUS,      -- Processing State [mereq_proc_type]
    PROC_DATE,        -- Timestamp [mmpur_utc]
    EXT_PROC_STATUS,  -- Processing State [mereq_proc_status]
    EXT_PROC_DATE,    -- Timestamp [mmpur_utc]
    ACTIVITY,         -- Activity for Purchase Requisition Item in External Sourcing [mmpur_activity_ty]
    EXT_DOC_NUMBER,   -- External Document [me_pur_ext_doc_id]
    EXT_DOC_ITEM,     -- External Item [me_pur_ext_doc_item_id]
    EXT_DOC_TYPE,     -- Ext. Document Type [me_pur_ext_doc_type]
    CREATE_IND,       -- Creation ind. [estkz]
    STATE,            -- Status Description [mereq_state]
    SC_OBJECT_ID,     -- Object ID [/srmerp/object_id]
    SC_ITM_NO,        -- Int. SC Itm No. [/srmerp/sc_itm_no]
    EXT_REL_STATE,    -- Status Ext. Release [mmpur_ext_rel_state]
    EXT_REL_DATE,     -- Time Ext. Release [mmpur_ext_rel_date]
    EXT_SYSTEM_ID,    -- External System ID [mmpur_ext_system]
    EXT_SYSTEM_TYPE,  -- External System Type [mmpur_ext_systype]
    PRIMARY KEY (MANDT, BANFN, BNFPO)
);

Learn More