EINE

Transparent Table Application Table
74 Fields 11 CDS Views

Purchasing Info Record: Purchasing Organization Data

EINE is an SAP database table in S/4HANA. Purchasing Info Record: Purchasing Organization Data. It contains 74 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
E_PurgInfoRecdOrgPlantData view from EXTENSION Extension view for EINE
FSH_V_Inforecord_Sos_B view from MM-PUR: Basic CDS View for SOS
I_PurgInfoRecdOrgPlantData view from BASIC Info Record Purch. Org. and Plant Data
InfoRecOrg view from Proxy for Inforecord Purchasing Organization Data (EINE)
M_V_inforecord view from MM-PUR: CDS View for Purchasing Info Record
m_v_inforecord_sos view inner MM-PUR: CDS View for SOS
M_V_Inforecord_Sos_B view from MM-PUR: Basic CDS View for SOS
M_V_Inforecord_Sos_B view union_all MM-PUR: Basic CDS View for SOS
M_V_Outline_Agreement_Sos_B view left_outer MM-PUR: Basic CDS View for SOS
pp_mrp_read_purchase_req view left_outer Deprecated: Replaced by I_MRPPurchaseRequisition
R_PurgInfoRecdOrgPlantData view_entity from BASIC Info Record Purch Org and Plant Data

Fields (74)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY infnr infnr Info Record
KEY ekorg ekorg Purchasing Org.
KEY esokz esokz Infotype
KEY werks ewerk Plant
loekz iloee Purch.org. data
erdat erdat Created On
ernam ernam Created By
ekgrp bkgrp Purch. Group
waers waers Currency
bonus wrbon V. Rebate Ind.
mgbon mgbon Quantity Rebate
minbm minbm Minimum Qty
norbm norbm Standard Qty
aplfz plifz Pl. Deliv. Time
uebto uebto Overdeliv. Tol.
uebtk uebtk Unlimited
untto untto Underdel. Tol.
angnr angnr Quotation
angdt angdt Quotation from
anfnr anfnr RFQ
anfps anfps Item
abskz abskz Rejection Ind.
amodv amodv Period from
amodb amodb Period to
amobm amobm Amort.plan.qty.
amobw amobw Amort.plan.val.
amoam amoam Amort. act. qty
amoaw amoaw Amort.act.value
amors amors Amort. reset
bstyp bstyp Doc. Category
ebeln ebeln Purchasing Doc.
ebelp ebelp Item
datlb datlb Document Date
netpr iprei Net Price
peinh epein Price Unit
bprme bbprm Order Price Un.
prdat prgbi Valid to
bpumz bpumz Qty Conversion
bpumn bpumn Qty Conversion
mtxno mtxno No Mat. Text
webre webre GR-Based IV
effpr effpr Effect. Price
ekkol ekkog Condition Group
sktof esktof No Cash Disc.
kzabs kzabs Acknowl. Reqd.
mwskz mwskz Tax Code
txdat_from fot_txdat_from Tax Rate Valid-From
tax_country fot_tax_country Tax Ctry/Reg.
bwtar bwtar_d Valuation Type
ebonu ebonu Sett. Group 1
evers evers Shipping Instr.
exprf exprf Procedure
bstae bstae Conf. Control
meprf meprf Pr. Date Cat.
inco1 inco1 Incoterms
inco2 inco2 Incoterms 2
xersn xersn No ERS
ebon2 ebon2 Sett. Group 2
ebon3 ebon3 Sett. Group 3
ebonf ebonf No Subs. Sett.
mhdrz mhdrz Rem. Shelf Life
verid mmpur_verid
bstma maxbm Max. Quantity
rdprf rdprf Rnding Profile
megru megru UoM Group
j_1bnbm j_1bnbmco1 NCM Code
spe_cre_ref_doc /spe/cre_ref_doc Create Ref Doc
iprkz dattp Period Ind.
co_order me_ir_co_order RT Consumption
vendor_rma_req msr_vrma_req_eine RMA Required
diff_invoice diff_invoice Diff. Invoicing
aut_source aut_source Auto. Sourcing
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: Purchasing Organization Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EINE (
    MANDT,            -- Client [mandt]
    INFNR,            -- Info Record [infnr]
    EKORG,            -- Purchasing Org. [ekorg]
    ESOKZ,            -- Infotype [esokz]
    WERKS,            -- Plant [ewerk]
    LOEKZ,            -- Purch.org. data [iloee]
    ERDAT,            -- Created On [erdat]
    ERNAM,            -- Created By [ernam]
    EKGRP,            -- Purch. Group [bkgrp]
    WAERS,            -- Currency [waers]
    BONUS,            -- V. Rebate Ind. [wrbon]
    MGBON,            -- Quantity Rebate [mgbon]
    MINBM,            -- Minimum Qty [minbm]
    NORBM,            -- Standard Qty [norbm]
    APLFZ,            -- Pl. Deliv. Time [plifz]
    UEBTO,            -- Overdeliv. Tol. [uebto]
    UEBTK,            -- Unlimited [uebtk]
    UNTTO,            -- Underdel. Tol. [untto]
    ANGNR,            -- Quotation [angnr]
    ANGDT,            -- Quotation from [angdt]
    ANFNR,            -- RFQ [anfnr]
    ANFPS,            -- Item [anfps]
    ABSKZ,            -- Rejection Ind. [abskz]
    AMODV,            -- Period from [amodv]
    AMODB,            -- Period to [amodb]
    AMOBM,            -- Amort.plan.qty. [amobm]
    AMOBW,            -- Amort.plan.val. [amobw]
    AMOAM,            -- Amort. act. qty [amoam]
    AMOAW,            -- Amort.act.value [amoaw]
    AMORS,            -- Amort. reset [amors]
    BSTYP,            -- Doc. Category [bstyp]
    EBELN,            -- Purchasing Doc. [ebeln]
    EBELP,            -- Item [ebelp]
    DATLB,            -- Document Date [datlb]
    NETPR,            -- Net Price [iprei]
    PEINH,            -- Price Unit [epein]
    BPRME,            -- Order Price Un. [bbprm]
    PRDAT,            -- Valid to [prgbi]
    BPUMZ,            -- Qty Conversion [bpumz]
    BPUMN,            -- Qty Conversion [bpumn]
    MTXNO,            -- No Mat. Text [mtxno]
    WEBRE,            -- GR-Based IV [webre]
    EFFPR,            -- Effect. Price [effpr]
    EKKOL,            -- Condition Group [ekkog]
    SKTOF,            -- No Cash Disc. [esktof]
    KZABS,            -- Acknowl. Reqd. [kzabs]
    MWSKZ,            -- Tax Code [mwskz]
    TXDAT_FROM,       -- Tax Rate Valid-From [fot_txdat_from]
    TAX_COUNTRY,      -- Tax Ctry/Reg. [fot_tax_country]
    BWTAR,            -- Valuation Type [bwtar_d]
    EBONU,            -- Sett. Group 1 [ebonu]
    EVERS,            -- Shipping Instr. [evers]
    EXPRF,            -- Procedure [exprf]
    BSTAE,            -- Conf. Control [bstae]
    MEPRF,            -- Pr. Date Cat. [meprf]
    INCO1,            -- Incoterms [inco1]
    INCO2,            -- Incoterms 2 [inco2]
    XERSN,            -- No ERS [xersn]
    EBON2,            -- Sett. Group 2 [ebon2]
    EBON3,            -- Sett. Group 3 [ebon3]
    EBONF,            -- No Subs. Sett. [ebonf]
    MHDRZ,            -- Rem. Shelf Life [mhdrz]
    VERID,            -- mmpur_verid
    BSTMA,            -- Max. Quantity [maxbm]
    RDPRF,            -- Rnding Profile [rdprf]
    MEGRU,            -- UoM Group [megru]
    J_1BNBM,          -- NCM Code [j_1bnbmco1]
    SPE_CRE_REF_DOC,  -- Create Ref Doc [/spe/cre_ref_doc]
    IPRKZ,            -- Period Ind. [dattp]
    CO_ORDER,         -- RT Consumption [me_ir_co_order]
    VENDOR_RMA_REQ,   -- RMA Required [msr_vrma_req_eine]
    DIFF_INVOICE,     -- Diff. Invoicing [diff_invoice]
    AUT_SOURCE,       -- Auto. Sourcing [aut_source]
    ISEOPBLOCKED,     -- Busin. Purp. Cmpltd. [eopblocked]
    PRIMARY KEY (MANDT, INFNR, EKORG, ESOKZ, WERKS)
);

Learn More