MMPUR_EXT_EKKO - Purchase Document Header
Purchase Document Header information is stored in SAP table MMPUR_EXT_EKKO.
It is part of development package APPL_PROC_HUB_CPO in software component MM-PUR-HUB. This development package consists of objects that can be grouped under "S4HANA Procurement Hub : Central Purchase Order".
It is part of development package APPL_PROC_HUB_CPO in software component MM-PUR-HUB. This development package consists of objects that can be grouped under "S4HANA Procurement Hub : Central Purchase Order".
Fields for table MMPUR_EXT_EKKO
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| EBELN | Purchasing Document Number | X | EBELN | CHAR | 20 | |
| EXTSOURCESYSTEM | Connected System ID | X | MMPUR_D_SOURCE_SYS | CHAR | 20 | |
| .INCLUDE | EKKODATA | 0 | ||||
| BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| BSTYP | Purchasing Document Category | EBSTYP | CHAR | 2 | ||
| BSART | Purchasing Document Type | ESART | CHAR | 8 | T161 | |
| BSAKZ | Control indicator for purchasing document type | BSAKZ | CHAR | 2 | ||
| LOEKZ | Deletion Indicator in Purchasing Document | ELOEK | CHAR | 2 | ||
| STATU | Status of Purchasing Document | ESTAK | CHAR | 2 | ||
| AEDAT | Creation Date of Purchasing Document | MMPUR_ERDAT | DATS | 16 | ||
| ERNAM | User of person who created a purchasing document | MMPUR_ERNAM | CHAR | 24 | ||
| LASTCHANGEDATETIME | Change Time Stamp | CHANGEDATETIME | DEC | 11 | ||
| PINCR | Item Number Interval | PINCR | NUMC | 10 | ||
| LPONR | Last Item Number | LPONR | NUMC | 10 | EKPO | |
| LIFNR | Vendor's account number | ELIFN | CHAR | 20 | LFA1 | |
| SPRAS | Language Key | SPRAS | LANG | 2 | T002 | |
| EKORG | Purchasing organization | EKORG | CHAR | 8 | T024E | |
| EKGRP | Purchasing Group | BKGRP | CHAR | 6 | T024 | |
| WAERS | Currency Key | WAERS | CUKY | 10 | TCURC | |
| WKURS | Exchange Rate | WKURS | DEC | 5 | ||
| KUFIX | Indicator for Fixed Exchange Rate | KUFIX | CHAR | 2 | ||
| BEDAT | Purchasing Document Date | EBDAT | DATS | 16 | ||
| KDATB | Start of Validity Period | KDATB | DATS | 16 | ||
| KDATE | End of Validity Period | KDATE | DATS | 16 | ||
| BWBDT | Closing Date for Applications | BWBDT | DATS | 16 | ||
| ANGDT | Deadline for Submission of Bid/Quotation | ANGAB | DATS | 16 | ||
| BNDDT | Binding Period for Quotation | EBNDT | DATS | 16 | ||
| GWLDT | Warranty Date | MM_GWLDT | DATS | 16 | ||
| AUSNR | Bid invitation number | AUSCH | CHAR | 20 | EKKO | |
| ANGNR | Quotation Number | ANGNR | CHAR | 20 | ||
| IHRAN | Quotation Submission Date | IHRAN | DATS | 16 | ||
| IHREZ | Your Reference | IHREZ | CHAR | 24 | ||
| VERKF | Responsible Salesperson at Supplier's Office | EVERK | CHAR | 60 | ||
| TELF1 | Supplier's Telephone Number | TELF0 | CHAR | 32 | ||
| LLIEF | Goods Supplier | LLIEF | CHAR | 20 | LFA1 | |
| KUNNR | Customer Number | KUNNR | CHAR | 20 | KNA1 | |
| ACTIVE_ID | Active Purchasing Document | EBELN_AD | CHAR | 20 | * | |
| KONNR | Number of principal purchase agreement | KONNR | CHAR | 20 | EKKO | |
| ABGRU | Field Not Used | ABDUM | CHAR | 4 | ||
| AUTLF | Complete Delivery Stipulated for Each Purchase Order | KMPLF | CHAR | 2 | ||
| WEAKT | Indicator: Goods Receipt Message | WEAKT | CHAR | 2 | ||
| RESWK | Supplying (issuing) plant in case of stock transport order | RESWK | CHAR | 8 | * | |
| LBLIF | Field not used | LBLIF | CHAR | 20 | LFA1 | |
| INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 6 | TINC | |
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 56 | ||
| KTWRT | Target Value for Header Area per Distribution | KTWRT | CURR | 8 | ||
| DISTRIBUTIONTYPE | Distribution Type for Purchasing Document | MMPUR_DISTR_TYPE | CHAR | 2 | ||
| SUBMI | Collective Number | SUBMI | CHAR | 20 | ||
| KNUMV | Number of the Document Condition | KNUMV | CHAR | 20 | ||
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 12 | T683 | |
| STAFO | Update Group for statistics update | STAFO | CHAR | 12 | * | |
| LIFRE | Different Invoicing Party | LIFRE | CHAR | 20 | LFA1 | |
| EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 20 | EIKP | |
| UNSEZ | Our Reference | UNSEZ | CHAR | 24 | ||
| LOGSY | Logical System | LOGSYSTEM | CHAR | 20 | * | |
| UPINC | Item Number Interval for Subitems | UPINC | NUMC | 10 | ||
| STAKO | Document with time-dependent conditions | STAKO | CHAR | 2 | ||
| FRGGR | Release group | FRGGR | CHAR | 4 | T16FG | |
| FRGSX | Release Strategy | FRGSX | CHAR | 4 | T16FS | |
| FRGKE | Release Indicator: Purchasing Document | FRGKE | CHAR | 2 | T16FB | |
| FRGZU | Release State | FRGZU | CHAR | 16 | ||
| FRGRL | Release Not Yet Completely Effected | FRGRL | CHAR | 2 | ||
| LANDS | Country/Region for Tax Report | LAND1_STML | CHAR | 6 | T005 | |
| LPHIS | Indicator for scheduling agreement release documentation | LPHIS | CHAR | 2 | ||
| ADRNR | Address Number | AD_ADDRNUM | CHAR | 20 | * | |
| STCEG_L | Country/Region of Sales Tax ID Number | STCEG_L | CHAR | 6 | * | |
| STCEG | VAT Registration Number | STCEG | CHAR | 40 | ||
| ABSGR | Reason for Cancellation | ABSGR | NUMC | 4 | T165R | |
| ADDNR | Document number for additional | ADDI_BELNR | CHAR | 20 | ||
| KORNR | Correction of miscellaneous provisions | KORNR | CHAR | 2 | ||
| MEMORY | Purchase order not yet complete | MEMER | CHAR | 2 | ||
| PROCSTAT | Purchasing document processing state | MEPROCSTATE | CHAR | 4 | ||
| PROCESS_INDICATOR | Process Indicator for Purchase Order | MMPUR_PROCESS_INDICATOR | CHAR | 6 | ||
| RLWRT | Total value at time of release | RLWRT | CURR | 8 | ||
| CR_STAT | Change Request Status | CR_STAT | CHAR | 4 | ||
| REVNO | Version number in Purchasing | REVNO | CHAR | 16 | ||
| SCMPROC | SCM Process That Created the Purchase Order | SCMPROC | CHAR | 2 | ||
| REASON_CODE | Goods Receipt Reason Code | /SAPPSPRO/_GR_REASON_CODE | CHAR | 8 | ||
| MEMORYTYPE | Category of Incompleteness | MEMORYTYPE | CHAR | 2 | ||
| RETTP | Retention Indicator | RETTP | CHAR | 2 | ||
| RETPC | Retention in Percent | RETPZ | DEC | 3 | ||
| DPTYP | Down Payment Indicator | ME_DPTYP | CHAR | 8 | ||
| DPPCT | Down Payment Percentage | ME_DPPCNT | DEC | 3 | ||
| DPAMT | Down Payment Amount in Document Currency | ME_DPAMNT | CURR | 6 | ||
| DPDAT | Due Date for Down Payment | ME_DPDDAT | DATS | 16 | ||
| MSR_ID | Process Identification Number | MSR_PROCESS_ID | CHAR | 20 | ||
| HIERARCHY_EXISTS | Part of a Contract Hierarchy | HIERARCHY_EXISTS | CHAR | 2 | ||
| GROUPING_ID | Grouping ID for Company Codes | MMPUR_D_CC_GROUPING_ID | CHAR | 6 | * | |
| PARENT_ID | ID of the Parent Document | MMPUR_PARENT_DOCUMENT_ID | CHAR | 20 | * | |
| THRESHOLD_EXISTS | Threshold Value for Exchange Rates Exists | EX_RATE_THRESHOLD | CHAR | 2 | ||
| LEGAL_CONTRACT | Legal Contract Number | LEGAL_CONTRACT_ID | CHAR | 80 | ||
| DESCRIPTION | Contract Name | CONTRACT_DESCRIPTION | CHAR | 80 | ||
| RELEASE_DATE | Release Date of Contract | RELEASE_DATE | DATS | 16 | ||
| VSART | Shipping Type | VERSART | CHAR | 4 | * | |
| HANDOVERLOC | Location for a physical handover of goods | HANDOVER_LOC | CHAR | 20 | ||
| SHIPCOND | Shipping Conditions | VSBED | CHAR | 4 | * | |
| .INCLUDE | INCO_L | 0 | ||||
| INCOV | Incoterms Version | INCOV | CHAR | 8 | TINCV | |
| INCO2_L | Incoterms Location 1 | INCO2_L | CHAR | 140 | ||
| INCO3_L | Incoterms Location 2 | INCO3_L | CHAR | 140 | ||
| .INCLUDE | TMINCO_LOC | 0 | ||||
| INCO2_KEY | Incoterm Location 1 - Place of Destination | /SCMTMS/INC_LOC_1_KEY | RAW | 16 | ||
| INCO3_KEY | Incoterm Location 2 - Place of Delivery | /SCMTMS/INC_LOC_2_KEY | RAW | 16 | ||
| INCO4_KEY | Incoterm - Deviating Place of Destination | /SCMTMS/INC_DEV_PLACE_DEST_KEY | RAW | 16 | ||
| GRWCU | Currency of statistical values for foreign trade | GRWCU | CUKY | 10 | * | |
| .INCLUDE | INTRA_REL_EXCL | 0 | ||||
| INTRA_REL | Relevant for Intrastat Reporting | INTRA_REL | CHAR | 2 | ||
| INTRA_EXCL | Exclude from Intrastat Reporting | INTRA_EXCL | CHAR | 2 | ||
| .INCLUDE | MMPUR_S_PRODCOMP_HEADER_STATUS | 0 | ||||
| TOTAL_STATUS_PCS | Product Compliance Supplier Check Status (All Items) | MMPUR_PC_TOTAL_STATUS_PCS | CHAR | 2 | ||
| TOTAL_STATUS_PMA | Product Marketability Status (All Items) | MMPUR_PC_TOTAL_STATUS_PMA | CHAR | 2 | ||
| TOTAL_STATUS_DG | Dangerous Goods Status (All Items) | MMPUR_PC_TOTAL_STATUS_DG | CHAR | 2 | ||
| TOTAL_STATUS_SDS | Safety Data Sheet Status (All Items) | MMPUR_PC_TOTAL_STATUS_SDS | CHAR | 2 | ||
| QTN_ERLST_SUBMSN_DATE | The date as of which Quotations can be submitted | QTN_ERLST_SUBMSN_DATE | DATS | 16 | ||
| FOLLOWON_DOC_CAT | Follow-On Purchasing Document Category | FOLLOWONDOCCAT | CHAR | 2 | ||
| FOLLOWON_DOC_TYPE | Follow-On Purchasing Document Type | FOLLOWONDOCTYPE | CHAR | 8 | * | |
| .INCLUDE | EXT | EKKO_INCL_EEW_PS | 0 | |||
| DUMMY_EKKO_INCL_EEW_PS | Data Element for Extensibility of Purchasing Document Header | EKKO_INCL_EEW | CHAR | 2 | ||
| .INCLUDE | MMPUR_EXTREFERENCE | 0 | ||||
| EXTERNALSYSTEM | ID of External Reference System | MMPUR_EXTREFERENCESYSTEMID | CHAR | 120 | ||
| EXTERNALREFERENCEID | External Reference ID | MMPUR_EXTERNALREFERENCEID | CHAR | 140 | ||
| EXT_REV_TMSTMP | Timestamp for Revision of External Calls | MM_EXT_REV_TMSTMP | DEC | 11 | ||
| ISEOPBLOCKED | Business Purpose Completed | EOPBLOCKED | CHAR | 2 | ||
| ISAGED | Document is aged | MMPUR_ISAGED | CHAR | 2 | ||
| .INCLU--AP | /ISDFPS/EKKODATA | 0 | ||||
| .INCLUDE | /ISDFPS/ST_FDP_REL | 0 | ||||
| FORCE_ID | Internal Key for Force Element | /ISDFPS/FORCE_ID | CHAR | 64 | ||
| FORCE_CNT | Internal (Version) Counter | /ISDFPS/FORCE_CNT | NUMC | 12 | ||
| RELOC_ID | Relocation ID | /ISDFPS/RELOC_ID | CHAR | 20 | /ISDFPS/REL | |
| RELOC_SEQ_ID | Relocation Step ID | /ISDFPS/RELOC_SEQ_ID | CHAR | 8 | /ISDFPS/RELSEQ | |
| SOURCE_LOGSYS | Logical system | LOGSYS | CHAR | 20 | * | |
| .INCLU--AP | FSH_EKKODATA_DATA | 0 | ||||
| FSH_TRANSACTION | Transaction Number | FSH_TRANSACTION | CHAR | 20 | ||
| FSH_ITEM_GROUP | Item Group | FSH_ITEM_GROUP | NUMC | 10 | ||
| FSH_VAS_LAST_ITEM | Last VAS Item Number | FSH_VAS_LAST_ITEM | NUMC | 10 | ||
| FSH_OS_STG_CHANGE | Order Scheduling Strategy Fields Changed Manually | FSH_OS_STG_CHANGE | CHAR | 2 | ||
| .INCLU--AP | TMS_EKKODATA | 0 | ||||
| TMS_REF_UUID | Reference UUID of Transportation Management | TMS_REF_UUID | CHAR | 44 | ||
| .INCLUDE | MMPUR_CALCFIELDS_CPO_EKKO | 0 | ||||
| PURCHASEORDERNETAMOUNT | Net Value in Document Currency | NETWR | CURR | 8 | ||
| NUMBEROFOVERDUEPURORDERS | Number of Overdue Purchase Orders | NUMBEROFOVERDUEPURORDERS | INT4 | 4 | ||
| NUMBEROFOVERDUEPURORDITM | Number of Overdue Purchase Orders Items | NUMBEROFOVERDUEPURORDITM | INT4 | 4 | ||
| PURCHASEORDERSTATUS | Purchasing Document Status | MMPUR_DOC_STATUS | CHAR | 4 | ||
| PURCHASEORDERSTATUSNAME | Purchase order status name | PURCHASEORDERSTATUSNAME | CHAR | 520 | ||
| APPROVERUSER | Approver | SWX_APPROV | CHAR | 24 | * | |
| APPROVERNAME | Approver Name | MM_APPROVER_NAME | CHAR | 80 | ||
| PURCHASINGPROCESSINGSTATUS | Purchasing document processing state | MEPROCSTATE | CHAR | 4 | ||
| SCHEDULELINEDELIVERYDATE | Item delivery date | EINDT | DATS | 16 | ||
| PURORDOUTPUTCTRLTYPE | Purchase Order Output Status Flag | PURCHASEORDEROUTPUTFLAG | CHAR | 2 | ||
| PURCHASEORDEROUTPUTSTATUS | Purchase Order Output Status Flag | PURCHASEORDEROUTPUTFLAG | CHAR | 2 | ||
| PURCHASEORDEROUTPUTSTATUSNAME | Purchase Order Output Status name | PURCHASEORDEROUTPUTSTATUSNAME | CHAR | 120 | ||
| PURCHASEORDEROUTPUTDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| WEIGHTEDRELEVANCE | Weighted Relevance | VDM_WEIGHTEDRELEVANCE | DEC | 15 | ||
| .INCLUDE | MMPUR_ADDNL_FIELDS_CPO_EKKO | 0 | ||||
| USERDESCRIPTION | Full Name of Person | AD_NAMTEXT | CHAR | 160 | ||
| EXTRACTIONDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| ISNOTEAVAILABLE | Boolean Variables (X=true, space=false) | BOOLEAN_FLG | CHAR | 2 | ||
| ISATTACHMENTAVAILABLE | Boolean Variables (X=true, space=false) | BOOLEAN_FLG | CHAR | 2 | ||
| FOLLOWONDOCEXISTS | Boolean Variables (X=true, space=false) | BOOLEAN_FLG | CHAR | 2 | ||
| BE_NAVIGATION_TARGET | Target navigation type | MMPUR_BE_NAVIGATION_TARGET | CHAR | 4 | ||
| .INCLUDE | EXT_EKKO_INCL_EEW_PS | 0 | ||||
| DUMMY_EXT_EKKO_INCL_EEW_PS | Data Element for Extensibility of Purchasing Document Header | EKKO_INCL_EEW | CHAR | 2 | ||
| .INCLUDE | EXTN_EKKO_INCL_EEW_PS | 0 | ||||
| DUMMY_EXTN_EKKO_INCL_EEW_PS | Data Element for Extensibility of Purchasing Document Header | EKKO_INCL_EEW | CHAR | 2 | ||
| COUNTRY_CODE | Country/Region Key | LAND1 | CHAR | 6 |