EKKO
Purchasing Document Header
EKKO is an SAP database table in S/4HANA. Purchasing Document Header. It contains 192 fields. 132 CDS views read from this table.
CDS Views using this table (132)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Arun_Conf_Lines | view | from | Supply Assignment confirmations | |
| arun_i_so_reqmt | view | left_outer | Sales Order selection in Normal mode | |
| ARUN_I_SO_REQMT_PREV | view | left_outer | Sales Order selection from Preview table | |
| Arun_I_Sto_1 | view | inner | STO Item level Data selection | |
| Arun_Purchord_Aggr | view | from | Supply Assignment PO aggregate | |
| Arun_Reqsrt_Mm | view | from | Requirement sorting - MM | |
| Arun_Spo_Reqmt | view | inner | Subcontracting PO Requirement | |
| ARUN_SSD_BG | view | left_outer | Get supply specific SO online | |
| ARUN_SSD_PREV | view | left_outer | Get supply specific SO preview | |
| Arun_Sto_Req1 | view | inner | STO Requirement - Initial join | |
| ARUN_STO_REQMT_SL | view | inner | STO selection at Date level | |
| ARUN_SUP_SP_SO | view | left_outer | Get supply specific SO online | |
| ARun_ValAddedSrvcMMServices | view | inner | ||
| ARun_ValAddedSrvcSTOItmBsc | view | from | ||
| ARUNI_CONF_LINE | view | from | Confirmations selection at date level | |
| aruni_po_line | view | from | PO selection at date level | |
| aruni_sto_line | view | from | PO selection at date level | |
| ARUNI_STO_LINE_STK | view | from | STO as stock | |
| Atpc_Cds_Eket_1 | view | left_outer | Helper CDS View on EKET Table for ATP | |
| Atpc_Cds_Ekub_D | view | from | CDS View used as replacement of atp_ekub | |
| Atpc_Cds_Sto_10 | view | left_outer | Helper CDS view for STOs in ATP BOP | |
| E_PurchaseContract | view | from | EXTENSION | Extension view for Purchase Contract Header |
| E_PurchasingDocument | view | from | EXTENSION | Extension view for Purchasing Document |
| F3_Mmim_Po_Vh | view | from | Help-View Purchase Orders (EKKO) | |
| FAC_AUDIT_Z3_MATERIAL_ITEM | view | left_outer | Material items | |
| FAC_PURCHASE_ORDER | view | from | Purchase Order | |
| Fclm_Mm_Ekko | view | from | Purchasing Document | |
| Fclm_Mmpd_Dcost | view | from | Delivery Cost of MM Items | |
| Fclm_Mmpo_Grplev | view | from | MM Planning Group and Level | |
| FMLV_EKBEBZ_UCT_UNION | view | inner | History per Purchasing Document w. External CURTP | |
| FMLV_EKBEBZH_UCT_UNION | view | inner | History per Purchasing Document w. External CURTP | |
| FNDEI_EKKO_BLOCKINGINFO | view | from | Filter View for table EKKO | |
| FNDEI_EKKO_FILTER | view | from | Filter View for table EKKO | |
| fsh_ddl_tpo_1 | view | left_outer | TPO Level 1 | |
| I_ARunMntrItemSTO | view | inner | BASIC | Basic View for Stock Transport Orders in ARun Monitor Runs |
| I_ARunOvwSTOItem | view | inner | BASIC | Basic View for Stock Transport Order Item |
| I_ARunPrioritySTOBasic | view | inner | BASIC | Base View for ARun Priority in STOs |
| I_ARunSTOItem | view | from | BASIC | ARun relevant Stock Transport Item |
| I_DemandDrivenPurDocHeader | view | from | BASIC | Demand Driven Purchasing Document Header |
| I_ElectronicDocPurchasingDoc | view | from | BASIC | Electronic Document: Purchasing Document |
| I_FldLogsPurchasingDocItem | view | inner | BASIC | Field Logistics Purchase Orders |
| I_FldLogsRefPurchasingDoc | view | from | BASIC | FL - Ref Purchasing Doc value help |
| I_FreightContractItemVH | view | from | BASIC | Value help for Freight Contract Item |
| I_FreightContractVH | view | from | BASIC | Value Help for Freight Contract |
| I_MRPOutlineAgreement | view | from | BASIC | Basic Outline Agreement SOS |
| I_NominationDocNumberVH | view | inner | BASIC | Nomination Document Number |
| I_PPS_POInfoProcessFlow | view | from | BASIC | Purchase order Document Information |
| I_PPS_PurchaseOrderInformation | view | from | BASIC | Purchase order Document Information |
| I_PPS_PurchasingDocumentStatus | view | from | BASIC | Status of Purchase Order |
| I_PPS_PurchasingHistory | view | inner | BASIC | History Per Purchasing Document |
| I_PPS_PurContrWrkflwObjIdfr | view_entity | from | BASIC | PPS Purchase Doc workflow objectID |
| I_PPS_PurgDocVH | view | from | BASIC | Search help for purchase documents |
| I_PPS_PurgDocWrkflwObjIdfr | view_entity | from | BASIC | PPS Purchase Doc workflow objectID |
| I_PPS_PurgOrdDocWrkflwObjIdfr | view_entity | from | BASIC | PPS Purchasing Order Doc Wrkflw ObjectID |
| I_PurchasingDocument | view | from | BASIC | Purchasing Document |
| I_PurContrVersRelevance | view | from | BASIC | Purchase Contract Version Relevance Flag |
| I_PurDocHeader | view | from | BASIC | Purchasing Document Header |
| I_ScheduleAgreementExists | view | from | BASIC | View for MRPCov to check if SchedAgmnt for a Material exists |
| I_SupDmndAllDocConfBsc | view | from | BASIC | Basic View for Supplier Confirmations |
| I_SupDmndAllDocPOBsc | view | from | BASIC | Basic View for Purchase Order |
| I_SupDmndAllDocRetsSup | view | from | BASIC | View for Returns from PO/STO |
| I_SupDmndAllDocSTOItmBsc | view | from | BASIC | Basic View for Stock Transport Order |
| I_SupDmndOvwItemPO | view | from | BASIC | Basic View for Purchase Orders |
| I_SupDmndOvwItemSTO | view | from | BASIC | Basic View for STO Item |
| I_TripPurchaseContractVH | view | from | BASIC | Value Help for Purchase Contract |
| I_TripPurchaseDocItemVH | view | from | BASIC | Purchase Document Items |
| m_v_ct_itm_status | view | left_outer | CDS View for Pur.Contract Item Status | |
| M_V_EKKO_EOP | view | from | Relevant fields with for setting the EOP-Flag in POs | |
| m_v_m2s_pd_hdr | view | from | View for Purchasing Document Header | |
| m_v_m2s_pd_itm | view | inner | View for Purchasing Document Item | |
| m_v_outline_agreement_sos | view | from | MM-PUR: CDS View for SOS | |
| M_V_Outline_Agreement_Sos_B | view | from | MM-PUR: Basic CDS View for SOS | |
| m_v_pd_itm_status | view | left_outer | CDS View for Pur. Document Item Status | |
| M_V_PHL_EKBE | view | inner | CDS View for PO History Light | |
| m_v_po_hdr_status | view | from | CDS View for PO Header Status | |
| m_v_po_itm_status | view | left_outer | CDS View for Purchase Order Item Status | |
| M_V_POH_EKBE_MA | view | inner | CDS View for PO History Multi Accounting | |
| M_V_POH_EKBZ | view | inner | CDS View for PO History Delivery Costs | |
| M_V_POH_EKBZ_MA | view | inner | CDS View for PO History Del. Costs - MAA | |
| m_v_sa_itm_status | view | left_outer | CDS View for Sched. Agr. Item Status | |
| Mmim_MatDocDocFlow | view | inner | Material Documents Document Flow | |
| MMPURORDHISTDELCOST_SDM | view | inner | SDM View for EKBZ_MA | |
| MMPURORDHISTDELCOSTH_SDM | view | inner | SDM View for EKBZH_MA | |
| MMPURORDHISTMATCOST_SDM | view | inner | SDM View for EKBE_MA | |
| MMPURORDHISTMATCOSTH_SDM | view | inner | SDM View for EKBEH_MA | |
| mmpurpo_ctr_itm_from_limit | view_entity | from | CtrItms as ref.for POItms type enh lmt | |
| N_PurchaseOrder | view | from | Aux. View for Purchase Order Enterprise Search | |
| P_CmmdtyPrcFixationExerPurg | view | inner | BASIC | Cmmdty Prc Fixation Exercise Purchasing |
| P_CmmdtyPrcFixationExerPurgNew | view_entity | inner | COMPOSITE | Cmmdty Prc Fix Exercise Purchasing New |
| P_CmmdtyPrcFixationOptionPurg | view | inner | BASIC | Cmmdty Price Fixation Option Purchasing |
| P_CmmdtyPrcFixationOptnPurgNew | view_entity | inner | COMPOSITE | Cmmdty Price Fix Option Purchasing New |
| P_PrcFixationOptionBsHndlgPurg | view | inner | BASIC | Cmmdt Prc Fix Option Basis Handling Purg |
| P_PrcFixationOptionCnvrsnPurg | view | inner | BASIC | Cmmdt Prc Fix Option Conversion Purg |
| P_PrcFixationOptnCnvrsnPurgNew | view_entity | inner | COMPOSITE | Cmmdt Prc Fix Option Conversion Purg New |
| P_PrcSttgMethExecutionAnalysis | view | left_outer | BASIC | |
| P_PrFixationOptnBsHndlgPurgNew | view_entity | inner | COMPOSITE | Cmmdt Prc Fix Opt Basis Hndlg Purg New |
| P_RFQBidderProposal | view | from | BASIC | |
| P_SupDmndAllDocSTODate | view | from | BASIC | |
| P_SupDmndOvwSTODateBasic | view | from | BASIC | |
| P_SuplrInvcItmQtyVariancePred | view | inner | BASIC | |
| P_SuplrInvcItmQtyVarianceTrain | view | inner | BASIC | |
| P_SUPPLIERINVOICEREFPO | view | inner | BASIC | |
| P_VarConfignPurchasingDocument | view | from | BASIC | |
| pph_e_Mdbs_1 | view | left_outer | ||
| PPH_E_MDBS_SL | view | left_outer | ||
| pph_e_Mdla_1 | view | left_outer | ||
| PPS_V_EKKO_EXT | view | from | PPS: View on EKKO+PPS_EKKO_EXT | |
| PurgDoc | view | from | ||
| R_PurchasingDocument | view | from | BASIC | Purchasing Document |
| R_PurgDocPricingSimulation | view | from | BASIC | Purchasing Document Pricing Simulation |
| rfm_mm_seasons_basic_view | view | from | RFM Stock Transport Seasons Basic View | |
| rfm_scc_stocktransfer_basic_V | view | from | Get Stock Transfer order details | |
| rrp_e_GiPo | view | inner | RRP: Select Purchase Orders as Goods Issues | |
| rrp_e_GrOc | view | inner | RRP: Retrieve Open Order Confirmation Quantities | |
| rrp_e_GrPo | view | inner | RRP: Select Purchase Orders as Goods Receipts | |
| SHSM_EKKO | view | from | CDS View for EKKO search help | |
| SHSM_EKPO | view | inner | CDS View for EKPO search help | |
| SHSM_M_MEKKC | view | left_outer | CDS View replacing M_MEKKC in search help MEKKC | |
| SHSM_MMIV_ODATA_MEKKL | view | from | Selection method for search help ODATA_MEKKL | |
| V_Mmim_Ddl_Om_Bypo | view | inner | Output Management group Items by PO | |
| V_Mmim_Ddl_Om_Or_Grmail | view | inner | Output Management GR Mail | |
| V_Mmim_DDL_Om_Param | view | left_outer | Goods Movement Parameters | |
| V_WB2_EKKO_EKPO_1 | view | from | Business Volume from Purchase Order | |
| V_WB2_EKKO_EKPO_2 | view | from | Business Volume Purchase Orders - EKKN | |
| V_WB2_MKPF_MSEG_1 | view | inner | Business Volume from Goods Receipt | |
| V_WB2_MKPF_MSEG_2 | view | inner | Business Volume from Goods Receipt -EKKN | |
| V_WB2_RBKP_RSEG_1 | view | inner | Business Volume from Supplier Invoice | |
| V_WB2_RBKP_RSEG_2 | view | inner | Business Volume from Supplier Invoice (online and batch) | |
| V_WB2_RBKP_RSEG_3 | view | inner | Business Volume Supplier Invoice -RBCO | |
| V_Wrft_Tl_Sched_Cds | view | from | Container Timeline-Scheduling-Report for Reactive PO-WB | |
| view_po_head_p | view | from | Header Related Data of a Purchase Order | |
| view_po_lts | view | inner | Supplier Subrange of a Purchase Order Item |
Fields (192)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | ebeln | EBELN | Purchasing Doc. | |||
| bukrs | BUKRS | Company Code | ||||
| bstyp | EBSTYP | Doc. Category | ||||
| bsart | ESART | Document Type | ||||
| bsakz | BSAKZ | Control | ||||
| loekz | ELOEK | Del. Indicator | ||||
| statu | ESTAK | Status | ||||
| aedat | MMPUR_ERDAT | Created On | ||||
| ernam | MMPUR_ERNAM | Created By | ||||
| lastchangedatetime | CHANGEDATETIME | Last Changed | ||||
| pincr | PINCR | Item Interval | ||||
| lponr | LPONR | Last Item | ||||
| lifnr | ELIFN | Supplier | ||||
| spras | SPRAS | Language | ||||
| zterm | DZTERM | Pyt Terms | ||||
| zbd1t | DZBDET | Payment in | ||||
| zbd2t | DZBDET | Payment in | ||||
| zbd3t | DZBDET | Payment in | ||||
| zbd1p | DZBD1P | CD Percentage 1 | ||||
| zbd2p | DZBD2P | CD Percentage 2 | ||||
| ekorg | EKORG | Purchasing Org. | ||||
| ekgrp | BKGRP | Purch. Group | ||||
| waers | WAERS | Currency | ||||
| wkurs | WKURS | Exchange Rate | ||||
| kufix | KUFIX | Fixed Exch.Rate | ||||
| bedat | EBDAT | Document Date | ||||
| kdatb | KDATB | Validity Start | ||||
| kdate | KDATE | Validity End | ||||
| bwbdt | BWBDT | Application By | ||||
| angdt | ANGAB | Quot. Deadline | ||||
| bnddt | EBNDT | Binding Period | ||||
| gwldt | MM_GWLDT | Warranty | ||||
| ausnr | AUSCH | Bid invitation | ||||
| angnr | ANGNR | Quotation | ||||
| ihran | IHRAN | Quotation Date | ||||
| ihrez | IHREZ | Your Reference | ||||
| verkf | EVERK | Salesperson | ||||
| telf1 | TELF0 | Telephone | ||||
| llief | LLIEF | Goods Supplier | ||||
| kunnr | KUNNR | Customer | ||||
| active_id | EBELN_AD | Active Purchase Doc | ||||
| konnr | KONNR | Agreement | ||||
| abgru | ABDUM | Field Not Used | ||||
| autlf | KMPLF | Complete Deliv. | ||||
| weakt | WEAKT | GR Message | ||||
| reswk | RESWK | Supplying Plant | ||||
| lblif | LBLIF | Rec. Supplier | ||||
| inco1 | INCO1 | Incoterms | ||||
| inco2 | INCO2 | Incoterms 2 | ||||
| ktwrt | KTWRT | Target Value | ||||
| distributiontype | MMPUR_DISTR_TYPE | Distribution Type | ||||
| submi | SUBMI | Collective No. | ||||
| knumv | KNUMV | Doc. Condition | ||||
| kalsm | KALSM_D | Procedure | ||||
| stafo | STAFO | Update Group | ||||
| lifre | LIFRE | Invoicing Party | ||||
| exnum | EXNUM | Foreign Trade DataNr | ||||
| unsez | UNSEZ | Our Reference | ||||
| logsy | LOGSYSTEM | Logical System | ||||
| upinc | UPINC | Subitem Interv. | ||||
| stako | STAKO | Tm.-dep. conds. | ||||
| frggr | FRGGR | Release group | ||||
| frgsx | FRGSX | Rel. Strategy | ||||
| frgke | FRGKE | Release ind. | ||||
| frgzu | FRGZU | Release State | ||||
| frgrl | FRGRL | Subj.to Release | ||||
| lands | LAND1_STML | Reporting C/R | ||||
| lphis | LPHIS | Release Docu. | ||||
| adrnr | AD_ADDRNUM | Address Number | ||||
| stceg_l | STCEG_L | CtryRgnSlsTxNo. | ||||
| stceg | STCEG | VAT Reg. No. | ||||
| absgr | ABSGR | Reas. for Canc. | ||||
| addnr | ADDI_BELNR | Document number | ||||
| kornr | KORNR | Corr. misc. pr. | ||||
| memory | MEMER | Incomplete | ||||
| procstat | MEPROCSTATE | Proc. State | ||||
| process_indicator | MMPUR_PROCESS_INDICATOR | Process Indicator | ||||
| rlwrt | RLWRT | Tot. val. rel. | ||||
| cr_stat | CR_STAT | Change Request Stat. | ||||
| revno | REVNO | Version | ||||
| scmproc | SCMPROC | SCMPROC | ||||
| reason_code | /SAPPSPRO/_GR_REASON_CODE | Reason Code | ||||
| memorytype | MEMORYTYPE | Incompl. Cat. | ||||
| rettp | RETTP | Retention | ||||
| retpc | RETPZ | Retention % | ||||
| dptyp | ME_DPTYP | Down Payment | ||||
| dppct | ME_DPPCNT | Down Payment % | ||||
| dpamt | ME_DPAMNT | Down Payment Amt | ||||
| dpdat | ME_DPDDAT | Due Date for DP | ||||
| msr_id | MSR_PROCESS_ID | Process ID No. | ||||
| hierarchy_exists | HIERARCHY_EXISTS | Contract Hierarchy | ||||
| grouping_id | MMPUR_D_CC_GROUPING_ID | Grouping ID | ||||
| parent_id | MMPUR_PARENT_DOCUMENT_ID | Parent Document ID | ||||
| threshold_exists | EX_RATE_THRESHOLD | Thresh. Val. Exists | ||||
| legal_contract | LEGAL_CONTRACT_ID | Legal Contract No. | ||||
| description | CONTRACT_DESCRIPTION | Contract Name | ||||
| release_date | RELEASE_DATE | Released On | ||||
| vsart | VERSART | Shipping Type | ||||
| handoverloc | HANDOVER_LOC | Handover Location | ||||
| shipcond | VSBED | Shipping Conditions | ||||
| has_catalog_relevant_items | MMPUR_DOC_IS_CATALOG_RELEVANT | Ctlg Item Rlvt Doc | ||||
| 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 | ||||
| grwcu | GRWCU | Currency | ||||
| intra_rel | INTRA_REL | Intrastat rel. | ||||
| intra_excl | INTRA_EXCL | exclude Intra | ||||
| total_status_pcs | MMPUR_PC_TOTAL_STATUS_PCS | Supplier Check Sts | ||||
| total_status_pma | MMPUR_PC_TOTAL_STATUS_PMA | Prod. Marktablty Sts | ||||
| total_status_dg | MMPUR_PC_TOTAL_STATUS_DG | Dangerous Goods Sts | ||||
| total_status_sds | MMPUR_PC_TOTAL_STATUS_SDS | Sfty Data Sheet Sts | ||||
| qtn_erlst_submsn_date | QTN_ERLST_SUBMSN_DATE | Start Date | ||||
| followon_doc_cat | FOLLOWONDOCCAT | Follow-On Document Category | ||||
| followon_doc_type | FOLLOWONDOCTYPE | Follow-On Document Type | ||||
| dummy_ekko_incl_eew_ps | EKKO_INCL_EEW | Ext. Include | ||||
| externalsystem | MMPUR_EXTREFERENCESYSTEMID | Ext. Ref. System | ||||
| externalreferenceid | MMPUR_EXTERNALREFERENCEID | Ext. Reference ID | ||||
| ext_rev_tmstmp | MM_EXT_REV_TMSTMP | External Revision | ||||
| iseopblocked | EOPBLOCKED | Busin. Purp. Cmpltd. | ||||
| isaged | MMPUR_ISAGED | Document aged | ||||
| force_id | /ISDFPS/FORCE_ID | GUID 32 | ||||
| force_cnt | /ISDFPS/FORCE_CNT | Counter | ||||
| reloc_id | /ISDFPS/RELOC_ID | Relocation ID | ||||
| reloc_seq_id | /ISDFPS/RELOC_SEQ_ID | Relocation Step | ||||
| source_logsys | LOGSYS | Logical system | ||||
| fsh_transaction | FSH_TRANSACTION | Transaction Number | ||||
| fsh_item_group | FSH_ITEM_GROUP | Item Group | ||||
| fsh_vas_last_item | FSH_VAS_LAST_ITEM | Last VAS Item Number | ||||
| fsh_os_stg_change | FSH_OS_STG_CHANGE | Changed Manually | ||||
| tms_ref_uuid | TMS_REF_UUID | GUID of SAP TM | ||||
| zapcgk | /ILE/TAPCGK | Annexing Package | ||||
| apcgk_extend | /ILE/TAPCGK_EXT | Ann.Package Extend | ||||
| zbas_date | /ILE/TBASDATE | Base Date | ||||
| zadattyp | /ILE/TADATTYP | Annexing Date Type | ||||
| zstart_dat | /ILE/TASDAT | Annexing start date | ||||
| z_dev | /ILE/TMPERC | deviation percen. | ||||
| zindanx | /ILE/TMANIND | Annexed ind. | ||||
| zlimit_dat | /ILE/TALDAT | Limit date | ||||
| numerator | /ILE/NUMERATOR | IL Ann Numerator | ||||
| hashcal_bdat | /ILE/HASHCAL_BDAT | New base date | ||||
| hashcal | /ILE/MTG_CHASHCAL | Accountant gen.mth | ||||
| negative | /ILE/NEGATIVE_ANNEXING | No negative annexing | ||||
| hashcal_exists | EKORG | Purchasing Org. | ||||
| known_index | /ILE/KNOWN_INDEX_ANX | Known Index Indic. | ||||
| postat | ADSPC_POSTAT | S1POSTAT Check | ||||
| vzskz | VZSKZ | Interest Indic. | ||||
| fsh_snst_status | FSH_SNST_STATUS | Snap. Status | ||||
| proce | PFM_01NUMPROCEDIMENTO | Procedure number | ||||
| conc | PFM_01CONCURSO | Adjust./contest | ||||
| cont | PFM_01CONTRATO | Contract Type | ||||
| comp | PFM_01COMPETENCIA | Legal competence | ||||
| outr | PFM_01OUTROS | Miscellaneous | ||||
| desp | PFM_01DESPACHO | Despatch | ||||
| desp_dat | DATUM | Date | ||||
| desp_cargo | PFM_01CARGO | Job | ||||
| pare | PFM_01PARECER | Assessment | ||||
| pare_dat | DATUM | Date | ||||
| pare_cargo | PFM_01CARGO | Job | ||||
| pfm_contract | PFM_CONTRACT | Contract | ||||
| pohf_type | WRF_POHF_TYPE | Document Category | ||||
| eq_eindt | WRF_POHF_EQ_EINDT | Same Delivery Date | ||||
| eq_werks | WRF_POHF_EQ_EWERK | Same Plant | ||||
| fixpo | WRF_POHF_FIXPO | Firm Deal ID | ||||
| ekgrp_allow | WRF_POHF_EKGRP_ALLOW | Take Acc. of PrchGrp | ||||
| werks_allow | WRF_POHF_WERKS_ALLOW | Take Acc. of Plant | ||||
| contract_allow | WRF_POHF_CONTRACT_ALLOW | Take Acc.of Contract | ||||
| pstyp_allow | WRF_POHF_PSTYP_ALLOW | Take Acc. of ItmCat. | ||||
| fixpo_allow | WRF_POHF_FIXPO_ALLOW | Fixed-Date Purchases | ||||
| key_id_allow | WRF_POHF_KEY_ID_ALLOW | Consider Budget | ||||
| aurel_allow | WRF_POHF_AUREL_ALLOW | Alloc.Table Rel. | ||||
| delper_allow | WRF_POHF_DELPER_ALLOW | Take Acc. of DELPER | ||||
| eindt_allow | WRF_POHF_EINDT_ALLOW | Take Acc. of DlvyDt. | ||||
| ltsnr_allow | WRF_POHF_LTSNR_ALLOW | Include Vendor Subr. | ||||
| otb_level | WRF_POTB_CHECK_LEVEL | Check Level | ||||
| otb_cond_type | WRF_POTB_COND_TYPE | Condition Type | ||||
| key_id | WRF_BUDG_KEY_ID | Budget Number | ||||
| otb_value | WRF_POTB_VALUE | Required Budget | ||||
| otb_curr | WRF_POTB_CURRENCY | OTB Currency | ||||
| otb_res_value | WRF_POTB_RES_VALUE | Reserved Budget | ||||
| otb_spec_value | WRF_POTB_SPECIAL_VALUE | Special Release | ||||
| spr_rsn_profile | WRF_POTB_SPR_RSN_PROFILE | OTB Reason Profile | ||||
| budg_type | WRF_BUDG_TYPE | Budget Type | ||||
| otb_status | WRF_POTB_STATUS | OTB Status | ||||
| otb_reason | WRF_POTB_STATUS_REASON | Reason | ||||
| check_type | WRF_BUDG_OTB_CHECK | Type of OTB Check | ||||
| con_otb_req | WRF_POTB_CON_REQ | OTB-Rel. Contract | ||||
| con_prebook_lev | WRF_POTB_PREBOOK_LEVEL | Contr. Indicator Lvl | ||||
| con_distr_lev | WRF_POTB_DISTRIB_LEVEL | Distrib.Targ.Val/Itm |
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 Document Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKKO (
MANDT, -- Client [MANDT]
EBELN, -- Purchasing Doc. [EBELN]
BUKRS, -- Company Code [BUKRS]
BSTYP, -- Doc. Category [EBSTYP]
BSART, -- Document Type [ESART]
BSAKZ, -- Control [BSAKZ]
LOEKZ, -- Del. Indicator [ELOEK]
STATU, -- Status [ESTAK]
AEDAT, -- Created On [MMPUR_ERDAT]
ERNAM, -- Created By [MMPUR_ERNAM]
LASTCHANGEDATETIME, -- Last Changed [CHANGEDATETIME]
PINCR, -- Item Interval [PINCR]
LPONR, -- Last Item [LPONR]
LIFNR, -- Supplier [ELIFN]
SPRAS, -- Language [SPRAS]
ZTERM, -- Pyt Terms [DZTERM]
ZBD1T, -- Payment in [DZBDET]
ZBD2T, -- Payment in [DZBDET]
ZBD3T, -- Payment in [DZBDET]
ZBD1P, -- CD Percentage 1 [DZBD1P]
ZBD2P, -- CD Percentage 2 [DZBD2P]
EKORG, -- Purchasing Org. [EKORG]
EKGRP, -- Purch. Group [BKGRP]
WAERS, -- Currency [WAERS]
WKURS, -- Exchange Rate [WKURS]
KUFIX, -- Fixed Exch.Rate [KUFIX]
BEDAT, -- Document Date [EBDAT]
KDATB, -- Validity Start [KDATB]
KDATE, -- Validity End [KDATE]
BWBDT, -- Application By [BWBDT]
ANGDT, -- Quot. Deadline [ANGAB]
BNDDT, -- Binding Period [EBNDT]
GWLDT, -- Warranty [MM_GWLDT]
AUSNR, -- Bid invitation [AUSCH]
ANGNR, -- Quotation [ANGNR]
IHRAN, -- Quotation Date [IHRAN]
IHREZ, -- Your Reference [IHREZ]
VERKF, -- Salesperson [EVERK]
TELF1, -- Telephone [TELF0]
LLIEF, -- Goods Supplier [LLIEF]
KUNNR, -- Customer [KUNNR]
ACTIVE_ID, -- Active Purchase Doc [EBELN_AD]
KONNR, -- Agreement [KONNR]
ABGRU, -- Field Not Used [ABDUM]
AUTLF, -- Complete Deliv. [KMPLF]
WEAKT, -- GR Message [WEAKT]
RESWK, -- Supplying Plant [RESWK]
LBLIF, -- Rec. Supplier [LBLIF]
INCO1, -- Incoterms [INCO1]
INCO2, -- Incoterms 2 [INCO2]
KTWRT, -- Target Value [KTWRT]
DISTRIBUTIONTYPE, -- Distribution Type [MMPUR_DISTR_TYPE]
SUBMI, -- Collective No. [SUBMI]
KNUMV, -- Doc. Condition [KNUMV]
KALSM, -- Procedure [KALSM_D]
STAFO, -- Update Group [STAFO]
LIFRE, -- Invoicing Party [LIFRE]
EXNUM, -- Foreign Trade DataNr [EXNUM]
UNSEZ, -- Our Reference [UNSEZ]
LOGSY, -- Logical System [LOGSYSTEM]
UPINC, -- Subitem Interv. [UPINC]
STAKO, -- Tm.-dep. conds. [STAKO]
FRGGR, -- Release group [FRGGR]
FRGSX, -- Rel. Strategy [FRGSX]
FRGKE, -- Release ind. [FRGKE]
FRGZU, -- Release State [FRGZU]
FRGRL, -- Subj.to Release [FRGRL]
LANDS, -- Reporting C/R [LAND1_STML]
LPHIS, -- Release Docu. [LPHIS]
ADRNR, -- Address Number [AD_ADDRNUM]
STCEG_L, -- CtryRgnSlsTxNo. [STCEG_L]
STCEG, -- VAT Reg. No. [STCEG]
ABSGR, -- Reas. for Canc. [ABSGR]
ADDNR, -- Document number [ADDI_BELNR]
KORNR, -- Corr. misc. pr. [KORNR]
MEMORY, -- Incomplete [MEMER]
PROCSTAT, -- Proc. State [MEPROCSTATE]
PROCESS_INDICATOR, -- Process Indicator [MMPUR_PROCESS_INDICATOR]
RLWRT, -- Tot. val. rel. [RLWRT]
CR_STAT, -- Change Request Stat. [CR_STAT]
REVNO, -- Version [REVNO]
SCMPROC, -- SCMPROC [SCMPROC]
REASON_CODE, -- Reason Code [/SAPPSPRO/_GR_REASON_CODE]
MEMORYTYPE, -- Incompl. Cat. [MEMORYTYPE]
RETTP, -- Retention [RETTP]
RETPC, -- Retention % [RETPZ]
DPTYP, -- Down Payment [ME_DPTYP]
DPPCT, -- Down Payment % [ME_DPPCNT]
DPAMT, -- Down Payment Amt [ME_DPAMNT]
DPDAT, -- Due Date for DP [ME_DPDDAT]
MSR_ID, -- Process ID No. [MSR_PROCESS_ID]
HIERARCHY_EXISTS, -- Contract Hierarchy [HIERARCHY_EXISTS]
GROUPING_ID, -- Grouping ID [MMPUR_D_CC_GROUPING_ID]
PARENT_ID, -- Parent Document ID [MMPUR_PARENT_DOCUMENT_ID]
THRESHOLD_EXISTS, -- Thresh. Val. Exists [EX_RATE_THRESHOLD]
LEGAL_CONTRACT, -- Legal Contract No. [LEGAL_CONTRACT_ID]
DESCRIPTION, -- Contract Name [CONTRACT_DESCRIPTION]
RELEASE_DATE, -- Released On [RELEASE_DATE]
VSART, -- Shipping Type [VERSART]
HANDOVERLOC, -- Handover Location [HANDOVER_LOC]
SHIPCOND, -- Shipping Conditions [VSBED]
HAS_CATALOG_RELEVANT_ITEMS, -- Ctlg Item Rlvt Doc [MMPUR_DOC_IS_CATALOG_RELEVANT]
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]
GRWCU, -- Currency [GRWCU]
INTRA_REL, -- Intrastat rel. [INTRA_REL]
INTRA_EXCL, -- exclude Intra [INTRA_EXCL]
TOTAL_STATUS_PCS, -- Supplier Check Sts [MMPUR_PC_TOTAL_STATUS_PCS]
TOTAL_STATUS_PMA, -- Prod. Marktablty Sts [MMPUR_PC_TOTAL_STATUS_PMA]
TOTAL_STATUS_DG, -- Dangerous Goods Sts [MMPUR_PC_TOTAL_STATUS_DG]
TOTAL_STATUS_SDS, -- Sfty Data Sheet Sts [MMPUR_PC_TOTAL_STATUS_SDS]
QTN_ERLST_SUBMSN_DATE, -- Start Date [QTN_ERLST_SUBMSN_DATE]
FOLLOWON_DOC_CAT, -- Follow-On Document Category [FOLLOWONDOCCAT]
FOLLOWON_DOC_TYPE, -- Follow-On Document Type [FOLLOWONDOCTYPE]
DUMMY_EKKO_INCL_EEW_PS, -- Ext. Include [EKKO_INCL_EEW]
EXTERNALSYSTEM, -- Ext. Ref. System [MMPUR_EXTREFERENCESYSTEMID]
EXTERNALREFERENCEID, -- Ext. Reference ID [MMPUR_EXTERNALREFERENCEID]
EXT_REV_TMSTMP, -- External Revision [MM_EXT_REV_TMSTMP]
ISEOPBLOCKED, -- Busin. Purp. Cmpltd. [EOPBLOCKED]
ISAGED, -- Document aged [MMPUR_ISAGED]
FORCE_ID, -- GUID 32 [/ISDFPS/FORCE_ID]
FORCE_CNT, -- Counter [/ISDFPS/FORCE_CNT]
RELOC_ID, -- Relocation ID [/ISDFPS/RELOC_ID]
RELOC_SEQ_ID, -- Relocation Step [/ISDFPS/RELOC_SEQ_ID]
SOURCE_LOGSYS, -- Logical system [LOGSYS]
FSH_TRANSACTION, -- Transaction Number [FSH_TRANSACTION]
FSH_ITEM_GROUP, -- Item Group [FSH_ITEM_GROUP]
FSH_VAS_LAST_ITEM, -- Last VAS Item Number [FSH_VAS_LAST_ITEM]
FSH_OS_STG_CHANGE, -- Changed Manually [FSH_OS_STG_CHANGE]
TMS_REF_UUID, -- GUID of SAP TM [TMS_REF_UUID]
ZAPCGK, -- Annexing Package [/ILE/TAPCGK]
APCGK_EXTEND, -- Ann.Package Extend [/ILE/TAPCGK_EXT]
ZBAS_DATE, -- Base Date [/ILE/TBASDATE]
ZADATTYP, -- Annexing Date Type [/ILE/TADATTYP]
ZSTART_DAT, -- Annexing start date [/ILE/TASDAT]
Z_DEV, -- deviation percen. [/ILE/TMPERC]
ZINDANX, -- Annexed ind. [/ILE/TMANIND]
ZLIMIT_DAT, -- Limit date [/ILE/TALDAT]
NUMERATOR, -- IL Ann Numerator [/ILE/NUMERATOR]
HASHCAL_BDAT, -- New base date [/ILE/HASHCAL_BDAT]
HASHCAL, -- Accountant gen.mth [/ILE/MTG_CHASHCAL]
NEGATIVE, -- No negative annexing [/ILE/NEGATIVE_ANNEXING]
HASHCAL_EXISTS, -- Purchasing Org. [EKORG]
KNOWN_INDEX, -- Known Index Indic. [/ILE/KNOWN_INDEX_ANX]
POSTAT, -- S1POSTAT Check [ADSPC_POSTAT]
VZSKZ, -- Interest Indic. [VZSKZ]
FSH_SNST_STATUS, -- Snap. Status [FSH_SNST_STATUS]
PROCE, -- Procedure number [PFM_01NUMPROCEDIMENTO]
CONC, -- Adjust./contest [PFM_01CONCURSO]
CONT, -- Contract Type [PFM_01CONTRATO]
COMP, -- Legal competence [PFM_01COMPETENCIA]
OUTR, -- Miscellaneous [PFM_01OUTROS]
DESP, -- Despatch [PFM_01DESPACHO]
DESP_DAT, -- Date [DATUM]
DESP_CARGO, -- Job [PFM_01CARGO]
PARE, -- Assessment [PFM_01PARECER]
PARE_DAT, -- Date [DATUM]
PARE_CARGO, -- Job [PFM_01CARGO]
PFM_CONTRACT, -- Contract [PFM_CONTRACT]
POHF_TYPE, -- Document Category [WRF_POHF_TYPE]
EQ_EINDT, -- Same Delivery Date [WRF_POHF_EQ_EINDT]
EQ_WERKS, -- Same Plant [WRF_POHF_EQ_EWERK]
FIXPO, -- Firm Deal ID [WRF_POHF_FIXPO]
EKGRP_ALLOW, -- Take Acc. of PrchGrp [WRF_POHF_EKGRP_ALLOW]
WERKS_ALLOW, -- Take Acc. of Plant [WRF_POHF_WERKS_ALLOW]
CONTRACT_ALLOW, -- Take Acc.of Contract [WRF_POHF_CONTRACT_ALLOW]
PSTYP_ALLOW, -- Take Acc. of ItmCat. [WRF_POHF_PSTYP_ALLOW]
FIXPO_ALLOW, -- Fixed-Date Purchases [WRF_POHF_FIXPO_ALLOW]
KEY_ID_ALLOW, -- Consider Budget [WRF_POHF_KEY_ID_ALLOW]
AUREL_ALLOW, -- Alloc.Table Rel. [WRF_POHF_AUREL_ALLOW]
DELPER_ALLOW, -- Take Acc. of DELPER [WRF_POHF_DELPER_ALLOW]
EINDT_ALLOW, -- Take Acc. of DlvyDt. [WRF_POHF_EINDT_ALLOW]
LTSNR_ALLOW, -- Include Vendor Subr. [WRF_POHF_LTSNR_ALLOW]
OTB_LEVEL, -- Check Level [WRF_POTB_CHECK_LEVEL]
OTB_COND_TYPE, -- Condition Type [WRF_POTB_COND_TYPE]
KEY_ID, -- Budget Number [WRF_BUDG_KEY_ID]
OTB_VALUE, -- Required Budget [WRF_POTB_VALUE]
OTB_CURR, -- OTB Currency [WRF_POTB_CURRENCY]
OTB_RES_VALUE, -- Reserved Budget [WRF_POTB_RES_VALUE]
OTB_SPEC_VALUE, -- Special Release [WRF_POTB_SPECIAL_VALUE]
SPR_RSN_PROFILE, -- OTB Reason Profile [WRF_POTB_SPR_RSN_PROFILE]
BUDG_TYPE, -- Budget Type [WRF_BUDG_TYPE]
OTB_STATUS, -- OTB Status [WRF_POTB_STATUS]
OTB_REASON, -- Reason [WRF_POTB_STATUS_REASON]
CHECK_TYPE, -- Type of OTB Check [WRF_BUDG_OTB_CHECK]
CON_OTB_REQ, -- OTB-Rel. Contract [WRF_POTB_CON_REQ]
CON_PREBOOK_LEV, -- Contr. Indicator Lvl [WRF_POTB_PREBOOK_LEVEL]
CON_DISTR_LEV, -- Distrib.Targ.Val/Itm [WRF_POTB_DISTRIB_LEVEL]
PRIMARY KEY (MANDT, EBELN)
);
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