EINA_EINE_D

Transparent Table Application Table
63 Fields 6 CDS Views

#GENERATED#

EINA_EINE_D is an SAP database table in S/4HANA. #GENERATED#. It contains 63 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_Inforecordmanagesosdraft view from EXTENSION Extension for InfoRecord draft
E_PurgInfoRecdOrgPlantDatadrft view from EXTENSION Extension view for EINE Draft
M_V_inforecord view left_outer MM-PUR: CDS View for Purchasing Info Record
m_v_inforecord_entity view from Info Record General Data - Draft and Original
P_Inforecordmanagesos view left_outer CONSUMPTION
P_Inforecordmanagesosdraft view from CONSUMPTION

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
guid CHAR32 Character field, length 32
infnr INFNR Info Record
ekorg EKORG Purchasing Org.
esokz ESOKZ Infotype
werks EWERK Plant
lifnr ELIFN Supplier
name1 NAME1_GP Name
matnr MATNR Material
maktx MAKTX Description
ekotx EKOTX Description
name1_p NAME1 Name 1
wgbez WGBEZ Matl Grp Desc.
matkl MATKL Material Group
loekz_a ILOEA Complete
txz01 EINATX Info Short Text
meins BSTME Order Unit
umrez UMBSZ Equal To
umren UMBSN Denominator
idnlf IDNLF Supp. Mat. No.
verkf VERKF Salesperson
telf1 TELF0 Telephone
lmein MEINS Base Unit
wglif WGLIF Suppl. Mat. Grp
kolif KOLIF Prior Supplier
lifab LIFAB Available from
lifbi LIFBI Available to
vabme VABME Var. Order Unit
relif RELIF Reg. Supplier
ernam ERNAM Created By
loekz_e ILOEE Purch.org. data
ekgrp EKGRP Purch. Group
waers WAERS Currency
minbm MINBM Minimum Qty
norbm NORBM Standard Qty
aplfz PLIFZ Pl. Deliv. Time
uebto UEBTO Overdeliv. Tol.
untto UNTTO Underdel. Tol.
uebtk UEBTK Unlimited
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
netpr NETPR Net Price
peinh PEINH Price unit
bprme BBPRM Order Price Un.
prdat PRDAT Last forecast
bpumz BPUMZ Qty Conversion
bpumn BPUMN Qty Conversion
webre WEBRE GR-Based IV
mwskz MWSKZ Tax Code
inco1 INCO1 Incoterms
inco2 INCO2 Incoterms 2
bstma MAXBM Max. Quantity
aut_source AUT_SOURCE Auto. Sourcing
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
entitystate CHAR1 Single-Character Flag
locked CHAR1 Single-Character Flag
activated CHAR1 Single-Character Flag
dummy_eina_incl_eew_ps EINA_INCL_EEW Ext. Include
dummy_eine_incl_eew_ps EINE_INCL_EEW Ext. Include

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.

-- #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EINA_EINE_D (
    MANDT,                   -- Client [MANDT]
    DB_KEY,                  -- NodeID [/BOBF/CONF_KEY]
    GUID,                    -- Character field, length 32 [CHAR32]
    INFNR,                   -- Info Record [INFNR]
    EKORG,                   -- Purchasing Org. [EKORG]
    ESOKZ,                   -- Infotype [ESOKZ]
    WERKS,                   -- Plant [EWERK]
    LIFNR,                   -- Supplier [ELIFN]
    NAME1,                   -- Name [NAME1_GP]
    MATNR,                   -- Material [MATNR]
    MAKTX,                   -- Description [MAKTX]
    EKOTX,                   -- Description [EKOTX]
    NAME1_P,                 -- Name 1 [NAME1]
    WGBEZ,                   -- Matl Grp Desc. [WGBEZ]
    MATKL,                   -- Material Group [MATKL]
    LOEKZ_A,                 -- Complete [ILOEA]
    TXZ01,                   -- Info Short Text [EINATX]
    MEINS,                   -- Order Unit [BSTME]
    UMREZ,                   -- Equal To [UMBSZ]
    UMREN,                   -- Denominator [UMBSN]
    IDNLF,                   -- Supp. Mat. No. [IDNLF]
    VERKF,                   -- Salesperson [VERKF]
    TELF1,                   -- Telephone [TELF0]
    LMEIN,                   -- Base Unit [MEINS]
    WGLIF,                   -- Suppl. Mat. Grp [WGLIF]
    KOLIF,                   -- Prior Supplier [KOLIF]
    LIFAB,                   -- Available from [LIFAB]
    LIFBI,                   -- Available to [LIFBI]
    VABME,                   -- Var. Order Unit [VABME]
    RELIF,                   -- Reg. Supplier [RELIF]
    ERNAM,                   -- Created By [ERNAM]
    LOEKZ_E,                 -- Purch.org. data [ILOEE]
    EKGRP,                   -- Purch. Group [EKGRP]
    WAERS,                   -- Currency [WAERS]
    MINBM,                   -- Minimum Qty [MINBM]
    NORBM,                   -- Standard Qty [NORBM]
    APLFZ,                   -- Pl. Deliv. Time [PLIFZ]
    UEBTO,                   -- Overdeliv. Tol. [UEBTO]
    UNTTO,                   -- Underdel. Tol. [UNTTO]
    UEBTK,                   -- Unlimited [UEBTK]
    EBELN,                   -- Purchasing Doc. [EBELN]
    EBELP,                   -- Item [EBELP]
    NETPR,                   -- Net Price [NETPR]
    PEINH,                   -- Price unit [PEINH]
    BPRME,                   -- Order Price Un. [BBPRM]
    PRDAT,                   -- Last forecast [PRDAT]
    BPUMZ,                   -- Qty Conversion [BPUMZ]
    BPUMN,                   -- Qty Conversion [BPUMN]
    WEBRE,                   -- GR-Based IV [WEBRE]
    MWSKZ,                   -- Tax Code [MWSKZ]
    INCO1,                   -- Incoterms [INCO1]
    INCO2,                   -- Incoterms 2 [INCO2]
    BSTMA,                   -- Max. Quantity [MAXBM]
    AUT_SOURCE,              -- Auto. Sourcing [AUT_SOURCE]
    CREA_DATE_TIME,          -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,              -- User Name [UNAME]
    LCHG_DATE_TIME,          -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,              -- User Name [UNAME]
    ENTITYSTATE,             -- Single-Character Flag [CHAR1]
    LOCKED,                  -- Single-Character Flag [CHAR1]
    ACTIVATED,               -- Single-Character Flag [CHAR1]
    DUMMY_EINA_INCL_EEW_PS,  -- Ext. Include [EINA_INCL_EEW]
    DUMMY_EINE_INCL_EEW_PS,  -- Ext. Include [EINE_INCL_EEW]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More