PurgOrder

Proxy for Purchase Order (EKKO filtered) | view: PURGORDROW | TRAN | Extraction: Not supported | Component: Purchasing

Tables used: EKKO

🔑 Keys (1)
💰 Amounts (6)
∑ Quantities
📅 Dates (20)
☰ Categorical (51)
Other (80)
🔗 Relations (34)

Column Name	Description
EBELN	Purchasing Document Number

Column Name	Description
💲 Currency Key (WAERS):
KTWRT	Target Value for Header Area per Distribution
RLWRT	Total value at time of release
DPAMT	Down Payment Amount in Document Currency
OTB_VALUE	Required Budget
OTB_RES_VALUE	Reserved Budget for OTB-Relevant Purchasing Document
OTB_SPEC_VALUE	Special Release Budget

Column Name	Description

Column Name	Description
AEDAT	Creation Date of Purchasing Document
BEDAT	Purchasing Document Date
KDATB	Start of Validity Period
KDATE	End of Validity Period
BWBDT	Closing Date for Applications
ANGDT	Deadline for Submission of Bid/Quotation
BNDDT	Binding Period for Quotation
GWLDT	Warranty Date
IHRAN	Quotation Submission Date
DPDAT	Due Date for Down Payment
RELEASE_DATE	Release Date of Contract
QTN_ERLST_SUBMSN_DATE	The date as of which Quotations can be submitted
/DMBE/PAYMENTDEEMED	Deemed Payment Date
ZBAS_DATE	Base Date
ZSTART_DAT	Annexing start date
ZLIMIT_DAT	Annexing limit date (purchasing)
HASHCAL_BDAT	"The general acountant method" New base date.
DESP_DAT	Date
PARE_DAT	Date
EQ_EINDT	Delivery Date Header: All Items Have Same Delivery Date

Column Name	Description
BSTYP	Purchasing Document Category	Show values
BSAKZ	Control indicator for purchasing document type	Show values
STATU	Status of Purchasing Document	Show values
KUFIX	Indicator for Fixed Exchange Rate	Show values
AUTLF	Complete Delivery Stipulated for Each Purchase Order	Show values
WEAKT	Indicator: Goods Receipt Message	Show values
DISTRIBUTIONTYPE	Distribution Type for Purchasing Document	Show values
STAKO	Document with time-dependent conditions	Show values
FRGRL	Release Not Yet Completely Effected	Show values
LPHIS	Indicator for scheduling agreement release documentation	Show values
KORNR	Correction of miscellaneous provisions	Show values
MEMORY	Purchase order not yet complete	Show values
PROCSTAT	Purchasing document processing state	Show values
PROCESS_INDICATOR	Process Indicator for Purchase Order	Show values
CR_STAT	Change Request Status	Show values
MEMORYTYPE	Category of Incompleteness	Show values
RETTP	Retention Indicator	Show values
HIERARCHY_EXISTS	Part of a Contract Hierarchy	Show values
THRESHOLD_EXISTS	Threshold Value for Exchange Rates Exists	Show values
INTRA_REL	Relevant for Intrastat Reporting	Show values
INTRA_EXCL	Exclude from Intrastat Reporting	Show values
TOTAL_STATUS_PCS	Product Compliance Supplier Check Status (All Items)	Show values
TOTAL_STATUS_PMA	Product Marketability Status (All Items)	Show values
TOTAL_STATUS_DG	Dangerous Goods Status (All Items)	Show values
TOTAL_STATUS_SDS	Safety Data Sheet Status (All Items)	Show values
FOLLOWON_DOC_CAT	Follow-On Purchasing Document Category	Show values
ISEOPBLOCKED	Business Purpose Completed	Show values
ISAGED	Document is aged	Show values
FSH_OS_STG_CHANGE	Order Scheduling Strategy Fields Changed Manually	Show values
ZADATTYP	Annexing Date Type	Show values
ZINDANX	indicator for annexed order type	Show values
KNOWN_INDEX	Known Index indicator in /ILE/T_ANNEXING_CALCULATION Func	Show values
POHF_TYPE	Document for Seasonal Purchase Order Processing	Show values
FIXPO	Firm Deal Indicator	Show values
EKGRP_ALLOW	Take Account of Purch. Group	Show values
WERKS_ALLOW	Take Account of Plants	Show values
CONTRACT_ALLOW	Take Account of Contracts	Show values
PSTYP_ALLOW	Take Account of Item Categories	Show values
FIXPO_ALLOW	Take Account of Fixed-Date Purchases Indicator	Show values
KEY_ID_ALLOW	Consider Budget	Show values
AUREL_ALLOW	Take Account of Alloc. Table Relevance	Show values
DELPER_ALLOW	Take Account of Dlvy Period	Show values
EINDT_ALLOW	Take Account of Delivery Date	Show values
LTSNR_ALLOW	Include Vendor Subrange	Show values
OTB_LEVEL	OTB Check Level	Show values
OTB_STATUS	OTB Check Status	Show values
OTB_REASON	Reason Indicator for OTB Check Status	Show values
CHECK_TYPE	Type of OTB Check	Show values
CON_OTB_REQ	OTB-Relevant Contract	Show values
CON_PREBOOK_LEV	OTB Indicator Level for Contracts	Show values
CON_DISTR_LEV	Distribution Using Target Value or Item Data	Show values

Column Name	Description	Domain name
LOEKZ	Deletion Indicator in Purchasing Document	ELOEK
ERNAM	User of person who created a purchasing document	USNAM
LASTCHANGEDATETIME	Change Time Stamp	TZNTSTMPL
PINCR	Item Number Interval	PINCR
ZTERM	Terms of payment key	ZTERM
ZBD1T	Cash (Prompt Payment) Discount Days	ZBDXT
ZBD2T	Cash (Prompt Payment) Discount Days	ZBDXT
ZBD3T	Cash (Prompt Payment) Discount Days	ZBDXT
ZBD1P	Cash discount percentage 1	PRZ23
ZBD2P	Cash Discount Percentage 2	PRZ23
WKURS	Exchange Rate	KURSP
ANGNR	Quotation Number	ANGNR
IHREZ	Your Reference	TEXT12
VERKF	Responsible Salesperson at Supplier's Office	TEXT30
TELF1	Supplier's Telephone Number	TEXT16
ACTIVE_ID	Active Purchasing Document	EBELN
ABGRU	Field Not Used	CHAR2
INCO2	Incoterms (Part 2)	INCO2
SUBMI	Collective Number	CHAR10
KNUMV	Number of the Document Condition	KNUMV
STAFO	Update Group for statistics update	STAFO
UNSEZ	Our Reference	TEXT12
LOGSY	Logical System	LOGSYS
UPINC	Item Number Interval for Subitems	PINCR
FRGZU	Release State	FRGZU
ADRNR	Address Number	AD_ADDRNUM
STCEG_L	Country/Region of Sales Tax ID Number	LAND1
STCEG	VAT Registration Number	STCEG
ADDNR	Document number for additional	ADDI_BELNR
REVNO	Version number in Purchasing	REVNO
SCMPROC	SCM Process That Created the Purchase Order	CHAR1
REASON_CODE	Goods Receipt Reason Code	/SAPPSPRO/_GR_REASON_CODE
RETPC	Retention in Percent	PRZ32
DPTYP	Down Payment Indicator	ME_DPTYPE_DOMAIN
DPPCT	Down Payment Percentage	PRZ32
MSR_ID	Process Identification Number	MSR_PROCESS_ID
GROUPING_ID	Grouping ID for Company Codes	MMPUR_D_CC_GROUPING_ID
PARENT_ID	ID of the Parent Document	EBELN
LEGAL_CONTRACT	Legal Contract Number	CHAR040
DESCRIPTION	Contract Name	TEXT40
VSART	Shipping Type	VERSART
HANDOVERLOC	Location for a physical handover of goods	HANDOVER_LOC
SHIPCOND	Shipping Conditions	VSBED
INCO2_L	Incoterms Location 1	INCO_L
INCO3_L	Incoterms Location 2	INCO_L
INCO2_KEY	Incoterm Location 1 - Place of Destination	/SCMTMS/LOCUUID
INCO3_KEY	Incoterm Location 2 - Place of Delivery	/SCMTMS/LOCUUID
INCO4_KEY	Incoterm - Deviating Place of Destination	/SCMTMS/LOCUUID
FOLLOWON_DOC_TYPE	Follow-On Purchasing Document Type	BSART
DUMMY_EKKO_INCL_EEW_PS	Data Element for Extensibility of Purchasing Document Header	EKKO_INCL_EEW
EXTERNALSYSTEM	ID of External Reference System	SLD_BSKEY
EXTERNALREFERENCEID	External Reference ID	MMPUR_EXTREFID
EXT_REV_TMSTMP	Timestamp for Revision of External Calls	TZNTSTMPL
FORCE_ID	Internal Key for Force Element	SYSUUID_C
FORCE_CNT	Internal (Version) Counter	NUMC6
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_ITEM
TMS_REF_UUID	Reference UUID of Transportation Management	SYSUUID_22
/DMBE/DEALNUMBER	Deal Number	/DMBE/DM_SMART_ID
/DMBE/EVGIDRENEWAL	Evergreen Renewal Period	/DMBE/DM_EVERGREEN_ID
/DMBE/EVGIDCANCEL	Evergreen Cancellation Period	/DMBE/DM_EVERGREEN_ID
APCGK_EXTEND	Extended key for annexing package	NUMC10
Z_DEV	deviation percentage	/ILE/TDEC3_3
NUMERATOR	IL Annexing Numerator	CHAR20
HASHCAL	Accountant general method	/ILE/MTG_CHASHCAL
NEGATIVE	Do not allow negative annexing	/ILE/NEGATIVE_ANNEXING
HASHCAL_EXISTS	Purchasing organization	EKORG
POSTAT	Flag for the S1POSTAT message	ADSPC_FLAG
VZSKZ	Interest Indicator	VZSKZ
FSH_SNST_STATUS	Snapshot Status	FSH_SNST_STATUS
DESP	Despatch	TEXT100
PARE	Assessment	TEXT100
PFM_CONTRACT	PTFM: Contract in Purchasing process	PS_POSNR
EQ_WERKS	Plant Header: All Items Have Same Receiving Plant	WERKS
OTB_COND_TYPE	OTB Condition Type	KSCHL
KEY_ID	Unique Number of Budget	WRF_BUDG_KEY_ID
SPR_RSN_PROFILE	Reason Profile for OTB Special Release	WRF_POTB_SPR_RSN_PROFILE
BUDG_TYPE	Budget Type	WRF_BUDG_TYPE

Master Data Relations \| to Other Relations ↓	Join Conditions
Reason for Cancellation Client Reason for Cancellation	`PURGORDER.MANDT == T165R.MANDT` `PURGORDER.ABSGR == T165R.ABSGR`
Purchasing Document Type Purchasing Document Type Purchasing Document Category Client	`PURGORDER.BSART == T161.BSART` `PURGORDER.BSTYP == T161.BSTYP` `PURGORDER.MANDT == T161.MANDT`
Company Code Client Company Code	`PURGORDER.MANDT == T001.MANDT` `PURGORDER.BUKRS == T001.BUKRS`
Purchasing Group Purchasing Group Client	`PURGORDER.EKGRP == T024.EKGRP` `PURGORDER.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`PURGORDER.EKORG == T024E.EKORG` `PURGORDER.MANDT == T024E.MANDT`
Release group Release group Client	`PURGORDER.FRGGR == T16FG.FRGGR` `PURGORDER.MANDT == T16FG.MANDT`
Release Indicator: Purchasing Document Client Release Indicator: Purchasing Document	`PURGORDER.MANDT == T16FB.MANDT` `PURGORDER.FRGKE == T16FB.FRGKE`
Release Strategy Release group Release Strategy Client	`PURGORDER.FRGGR == T16FS.FRGGR` `PURGORDER.FRGSX == T16FS.FRGSX` `PURGORDER.MANDT == T16FS.MANDT`
Incoterms (Part 1) Incoterms (Part 1) Client	`PURGORDER.INCO1 == TINC.INCO1` `PURGORDER.MANDT == TINC.MANDT`
Incoterms Version Incoterms Version Client	`PURGORDER.INCOV == TINCV.INCOV` `PURGORDER.MANDT == TINCV.MANDT`
Procedure (Pricing, Output Control, Acct. Det., Costing,...) ? Procedure (Pricing, Output Control, Acct. Det., Costing,...) ? Client	`PURGORDER.[column in domain "KAPPL"] == T683.KAPPL` `PURGORDER.KALSM == T683.KALSM` `PURGORDER.[column in domain "KVEWE"] == T683.KVEWE` `PURGORDER.MANDT == T683.MANDT`
Customer Number Client Customer Number	`PURGORDER.MANDT == KNA1.MANDT` `PURGORDER.KUNNR == KNA1.KUNNR`
Country/Region for Tax Report Client Country/Region for Tax Report	`PURGORDER.MANDT == T005.MANDT` `PURGORDER.LANDS == T005.LAND1`
Field not used Field not used Client	`PURGORDER.LBLIF == LFA1.LIFNR` `PURGORDER.MANDT == LFA1.MANDT`
Vendor's account number Vendor's account number Client	`PURGORDER.LIFNR == LFA1.LIFNR` `PURGORDER.MANDT == LFA1.MANDT`
Different Invoicing Party Different Invoicing Party Client	`PURGORDER.LIFRE == LFA1.LIFNR` `PURGORDER.MANDT == LFA1.MANDT`
Goods Supplier Client Goods Supplier	`PURGORDER.MANDT == LFA1.MANDT` `PURGORDER.LLIEF == LFA1.LIFNR`
Relocation ID Client Relocation ID	`PURGORDER.MANDT == /ISDFPS/REL.MANDT` `PURGORDER.RELOC_ID == /ISDFPS/REL.RELOC_ID`
Relocation Step ID Client Relocation Step ID	`PURGORDER.MANDT == /ISDFPS/RELSEQ.MANDT` `PURGORDER.RELOC_SEQ_ID == /ISDFPS/RELSEQ.RELOC_SEQ_ID`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order	`PURGORDER.MANDT == T001W.MANDT` `PURGORDER.RESWK == T001W.WERKS`
Language Key	`PURGORDER.SPRAS == T002.SPRAS`
Currency Key Currency Key Client	`PURGORDER.WAERS == TCURC.WAERS` `PURGORDER.MANDT == TCURC.MANDT`
Annexing package key Client Extended key for annexing package Annexing package key	`PURGORDER.MANDT == /ILE/TV01.MANDT` `PURGORDER.APCGK_EXTEND == /ILE/TV01.APCGK_EXTEND` `PURGORDER.ZAPCGK == /ILE/TV01.APCGK`

Other Relations \| to Master Data Relations ↑	Join Conditions
Legal competence Client Legal competence	`PURGORDER.MANDT == PFM_01TP14.MANDT` `PURGORDER.COMP == PFM_01TP14.COMP`
Adjustment/contest Adjustment/contest Client	`PURGORDER.CONC == PFM_01TP12.CONC` `PURGORDER.MANDT == PFM_01TP12.MANDT`
Contract Contract Client	`PURGORDER.CONT == PFM_01TP13.CONT` `PURGORDER.MANDT == PFM_01TP13.MANDT`
Job Job Client	`PURGORDER.DESP_CARGO == PFM_01TP16.CARGO` `PURGORDER.MANDT == PFM_01TP16.MANDT`
Miscellaneous Client Miscellaneous	`PURGORDER.MANDT == PFM_01TP15.MANDT` `PURGORDER.OUTR == PFM_01TP15.OUTR`
Job Job Client	`PURGORDER.PARE_CARGO == PFM_01TP16.CARGO` `PURGORDER.MANDT == PFM_01TP16.MANDT`