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