EINE
Purchasing Info Record: Purchasing Organization Data
EINE is an SAP database table in S/4HANA. Purchasing Info Record: Purchasing Organization Data. It contains 90 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_PurgInfoRecdOrgPlantData | view | from | EXTENSION | Extension view for EINE |
| FNDEI_EINE_BLOCKINGINFO | view | from | Filter View for table EINE | |
| FNDEI_EINE_FILTER | view | from | Filter View for table EINE | |
| FSH_V_Inforecord_Sos_B | view | from | MM-PUR: Basic CDS View for SOS | |
| I_MRPPurchasingInfoRecord | view | inner | BASIC | Basic InfoRecords for SOS |
| I_PurgInfoRecdOrgPlantData | view | from | BASIC | Info Record Purch. Org. and Plant Data |
| InfoRecOrg | view | from | ||
| 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 |
Fields (90)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | VERID | Prod. Version | ||||
| 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 | ||||
| incov | INCOV | Inco. Version | ||||
| inco2_l | INCO2_L | Inco. Location1 | ||||
| inco3_l | INCO3_L | Inco. Location2 | ||||
| inco2_key | /SCMTMS/INC_LOC_1_KEY | Incoterm Location 1 | ||||
| inco3_key | /SCMTMS/INC_LOC_2_KEY | Incoterm Location 2 | ||||
| inco4_key | /SCMTMS/INC_DEV_PLACE_DEST_KEY | Dev. Destination | ||||
| aut_source | AUT_SOURCE | Auto. Sourcing | ||||
| dummy_eine_incl_eew_ps | EINE_INCL_EEW | Ext. Include | ||||
| iseopblocked | EOPBLOCKED | Busin. Purp. Cmpltd. | ||||
| fsh_dci_corr | FSH_DCI_CORRELATION | DCI correlation | ||||
| fsh_rlt | FSH_PDT_RLT | Replen. Lead Time | ||||
| fsh_mlt | FSH_PDT_MLT | Manuf. Lead Time | ||||
| fsh_plt | FSH_PDT_PLT | Packing Lead Time | ||||
| fsh_tlt | FSH_PDT_TLT | Transp. Lead Time | ||||
| mrpind | J_1IRMRPIND | MRPind | ||||
| sgt_ssrel | SGT_SSREL | Stock Seg. Rel. Ind. | ||||
| transport_chain | WRF_PSCD_TC_ID | Transportation Chain | ||||
| staging_time | WRF_PSCD_MST | Staging Time |
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, -- Prod. Version [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]
INCOV, -- Inco. Version [INCOV]
INCO2_L, -- Inco. Location1 [INCO2_L]
INCO3_L, -- Inco. Location2 [INCO3_L]
INCO2_KEY, -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY]
INCO3_KEY, -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY]
INCO4_KEY, -- Dev. Destination [/SCMTMS/INC_DEV_PLACE_DEST_KEY]
AUT_SOURCE, -- Auto. Sourcing [AUT_SOURCE]
DUMMY_EINE_INCL_EEW_PS, -- Ext. Include [EINE_INCL_EEW]
ISEOPBLOCKED, -- Busin. Purp. Cmpltd. [EOPBLOCKED]
FSH_DCI_CORR, -- DCI correlation [FSH_DCI_CORRELATION]
FSH_RLT, -- Replen. Lead Time [FSH_PDT_RLT]
FSH_MLT, -- Manuf. Lead Time [FSH_PDT_MLT]
FSH_PLT, -- Packing Lead Time [FSH_PDT_PLT]
FSH_TLT, -- Transp. Lead Time [FSH_PDT_TLT]
MRPIND, -- MRPind [J_1IRMRPIND]
SGT_SSREL, -- Stock Seg. Rel. Ind. [SGT_SSREL]
TRANSPORT_CHAIN, -- Transportation Chain [WRF_PSCD_TC_ID]
STAGING_TIME, -- Staging Time [WRF_PSCD_MST]
PRIMARY KEY (MANDT, INFNR, EKORG, ESOKZ, WERKS)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA