EINA

Transparent Table Application Table
41 Fields 15 CDS Views

Purchasing Info Record: General Data

EINA is an SAP database table in S/4HANA. Purchasing Info Record: General Data. It contains 41 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
E_PurchasingInforecord view from EXTENSION Extension view for EINA
FNDEI_EINA_BLOCKINGFILTER view from Blocking View for table EINA
FNDEI_EINA_FILTER view from Filter View for table EINA
FSH_V_Inforecord_Sos_B view inner MM-PUR: Basic CDS View for SOS
I_MRPPurchasingInfoRecord view from BASIC Basic InfoRecords for SOS
I_PurchasingInfoRecord view from BASIC Purchasing Info Record
InfoRec view from
M_V_EINA_EOP view from Relevant fields with for setting the EOP-Flag in EINA
M_V_inforecord view left_outer MM-PUR: CDS View for Purchasing Info Record
M_V_Inforecord_Basic view from CDS View for InfoRecords validity
M_V_Inforecord_Sos_B view inner MM-PUR: Basic CDS View for SOS
P_InvtryMgmtSuplrInfoRecdVH view inner BASIC
P_Prchinforecords_FS view from BASIC
pp_mrp_read_purchase_req view left_outer Deprecated: Replaced by I_MRPPurchaseRequisition
SHSM_EINA view from

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY infnr INFNR Info Record
matnr MATNR Material
matkl MATKL Material Group
lifnr ELIFN Supplier
loekz ILOEA Complete
erdat ERDAT Created On
ernam ERNAM Created By
txz01 EINATX Info Short Text
sortl SORTI Sort Term
meins BSTME Order Unit
umrez UMBSZ Equal To
umren UMBSN Denominator
idnlf IDNLF Supp. Mat. No.
verkf VERKF Salesperson
telf1 TELF0 Telephone
mahn1 MAHN1 1st Rem./Exped.
mahn2 MAHN2 2nd Rem./Exped.
mahn3 MAHN3 3rd Rem./Exped.
urznr URZNR Certificate
urzdt URZDT Valid to
urzla ULAND C/R. of Origin
urztp URZTP Certif. Cat.
urzzt URZZT Number
lmein MEINS Base Unit
regio REGIO Region
vabme VABME Var. Order Unit
ltsnr LTSNR Suppl. Subrange
ltssf LTSSF SSR Sort No.
wglif WGLIF Suppl. Mat. Grp
rueck W_RUECKNV Return Agmt
lifab LIFAB Available from
lifbi LIFBI Available to
kolif KOLIF Prior Supplier
anzpu ANZPU Points
punei PUNEI Points Unit
relif RELIF Reg. Supplier
mfrnr MFRNR1 Manufacturer
dummy_eina_incl_eew_ps EINA_INCL_EEW Ext. Include
lastchangedatetime TIMESTAMPL Time Stamp
iseopblocked EOPBLOCKED Busin. Purp. Cmpltd.

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.

-- Purchasing Info Record: General Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EINA (
    MANDT,                   -- Client [MANDT]
    INFNR,                   -- Info Record [INFNR]
    MATNR,                   -- Material [MATNR]
    MATKL,                   -- Material Group [MATKL]
    LIFNR,                   -- Supplier [ELIFN]
    LOEKZ,                   -- Complete [ILOEA]
    ERDAT,                   -- Created On [ERDAT]
    ERNAM,                   -- Created By [ERNAM]
    TXZ01,                   -- Info Short Text [EINATX]
    SORTL,                   -- Sort Term [SORTI]
    MEINS,                   -- Order Unit [BSTME]
    UMREZ,                   -- Equal To [UMBSZ]
    UMREN,                   -- Denominator [UMBSN]
    IDNLF,                   -- Supp. Mat. No. [IDNLF]
    VERKF,                   -- Salesperson [VERKF]
    TELF1,                   -- Telephone [TELF0]
    MAHN1,                   -- 1st Rem./Exped. [MAHN1]
    MAHN2,                   -- 2nd Rem./Exped. [MAHN2]
    MAHN3,                   -- 3rd Rem./Exped. [MAHN3]
    URZNR,                   -- Certificate [URZNR]
    URZDT,                   -- Valid to [URZDT]
    URZLA,                   -- C/R. of Origin [ULAND]
    URZTP,                   -- Certif. Cat. [URZTP]
    URZZT,                   -- Number [URZZT]
    LMEIN,                   -- Base Unit [MEINS]
    REGIO,                   -- Region [REGIO]
    VABME,                   -- Var. Order Unit [VABME]
    LTSNR,                   -- Suppl. Subrange [LTSNR]
    LTSSF,                   -- SSR Sort No. [LTSSF]
    WGLIF,                   -- Suppl. Mat. Grp [WGLIF]
    RUECK,                   -- Return Agmt [W_RUECKNV]
    LIFAB,                   -- Available from [LIFAB]
    LIFBI,                   -- Available to [LIFBI]
    KOLIF,                   -- Prior Supplier [KOLIF]
    ANZPU,                   -- Points [ANZPU]
    PUNEI,                   -- Points Unit [PUNEI]
    RELIF,                   -- Reg. Supplier [RELIF]
    MFRNR,                   -- Manufacturer [MFRNR1]
    DUMMY_EINA_INCL_EEW_PS,  -- Ext. Include [EINA_INCL_EEW]
    LASTCHANGEDATETIME,      -- Time Stamp [TIMESTAMPL]
    ISEOPBLOCKED,            -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    PRIMARY KEY (MANDT, INFNR)
);

Learn More