EKPO_DISTR - Purchasing Document Item Distribution

Purchasing Document Item Distribution information is stored in SAP table EKPO_DISTR.
It is part of development package ME in software component MM-PUR. This development package consists of objects that can be grouped under "Purchasing".

Fields for table EKPO_DISTR

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
PURCHASINGDOCUMENT	Purchasing Document Number	X	EBELN	CHAR	20
PURCHASINGDOCUMENTITEM	Item Number of Purchasing Document	X	EBELP	NUMC	10
DISTRIBUTIONNUMBER	Distribution Number of Central Purchasing Document	X	MM_PURGDOC_DISTR_NUM	NUMC	8
REFERENCEDHDRDISTRNUMBER	Distribution Number of Central Purchasing Document		MM_PURGDOC_DISTR_NUM	NUMC	8
PURCHASINGDOCUMENTCATEGORY	Purchasing Document Category		BSTYP	CHAR	2
PURCHASINGDOCUMENTTYPE	Purchasing Document Type		ESART	CHAR	8
PURCHASINGORGANIZATION	Purchasing organization		EKORG	CHAR	8
COMPANYCODE	Company Code		BUKRS	CHAR	8
PLANT	Plant		EWERK	CHAR	8
LOGICALSYSTEM	Logical System		LOGSYSTEM	CHAR	20
DOCUMENTCURRENCY	Currency Key		WAERS	CUKY	10
PURCHASINGGROUP	Purchasing Group		BKGRP	CHAR	6
STORAGELOCATION	Storage location		LGORT_D	CHAR	8
PAYMENTTERMS	Terms of Payment Key		FARP_DZTERM	CHAR	8
CASHDISCOUNT1DAYS	Cash discount days 1		DZBD1T	DEC	2
CASHDISCOUNT2DAYS	Cash discount days 2		DZBD2T	DEC	2
NETPAYMENTDAYS	Net Payment Terms Period		DZBD3T	DEC	2
CASHDISCOUNT1PERCENT	Cash discount percentage 1		DZBD1P	DEC	3
CASHDISCOUNT2PERCENT	Cash Discount Percentage 2		DZBD2P	DEC	3
MATERIAL	Material Number		MATNR	CHAR	80
MATERIALGROUP	Material Group		MATKL	CHAR	18
PURCHASINGDOCUMENTDISTRPCT	Distribution Percentage in Central Purchasing Document		MM_PURGDOC_DISTR_PCT	DEC	4
TARGETQUANTITY	Target Quantity		KTMNG	QUAN	7
TARGETVALUE	Target Value for Header Area per Distribution		KTWRT	CURR	8
EXTCONTRACTFORPURG	Contract of External System		MM_PUR_HUB_KONNR	CHAR	20
EXTCONTRACTITEMFORPURG	Contract Item of External System		MM_PUR_HUB_KTPNR	NUMC	10
EXTCONTRACTITEMDISTRFORPURG	Distribution Number of Central Purchasing Document		MM_PURGDOC_DISTR_NUM	NUMC	8
EXTCONTRACTITEMDISTRSTATUS	Distribution Status		ME_DISTRIBUTION_STATUS	CHAR	4
RESPONSEMESSAGEGUID	Generic Data Element for GUID Fields (X16)		GUID16	RAW	16
ISDELETED	Link field for view query		BOOL	CHAR	6
ORDERQUANTITYUNIT	Purchase Order Unit of Measure		BSTME	UNIT	6
DISTRIBUTIONTYPE	Distribution Type for Central Purchase Contract Item		MM_PUR_CCTR_ITM_DIST_TYPE	CHAR	4
RESP_RECD_AT	Timestamp		MMPUR_UTC	CHAR	28
ITEMDISTRIBUTIONISRELEVANT	Link field for view query		BOOL	CHAR	6
ISITEMDISTRIBUTIONBLOCKED	Blocked indicator for Item distribution		MMPUR_ITEMDISTR_BLOCKED	CHAR	6
MANUALDELIVERYADDRESSID	Address Number		AD_ADDRNUM	CHAR	20
DELIVERYADDRESSTYPE	Source of the Delivery Address		MM_PURGDOC_DELIV_ADDR_TYPE	CHAR	4
DISTRIBUTIONLEVEL	Distribution Level in Central Purchasing Document		MM_PURGDOC_DISTR_NODE_TYPE	CHAR	4
PROCUREMENTHUBSOURCESYSTEM	Connected System ID		MMPUR_D_SOURCE_SYS	CHAR	20
.INCLUDE	EXT			EKPODISTR_INCL_EEW_PS	0
DUMMY_EKPODISTR_INCL_EEW_PS	Element for Extensibility of Purchasing Doc Distribution		EKPODISTR_INCL_EEW	CHAR	2
EXTERNALREFERENCEDOCUMENT	Document Number of External Reference Document		VGBEL_EX	CHAR	20
EXTERNALREFERENCEDOCUMENTITEM	Document Item Number of External Reference Document		VGPOS_EX	NUMC	10
EXTERNALREFDOCCATEGORY	Category of an external transaction or element		VGTYP_EX	CHAR	6
PURCHASINGINFORECORDUPDATECODE	Indicator: Update Info Record		SPINF	CHAR	2
PROCMTHUBPREDECESSORDOCUMENT	Predecessor Purchasing Document Number		MM_PUR_HUB_EBELN	CHAR	20
PROCMTHUBPREDECESSORDOCITEM	Predecessor Purchasing Document Item Number		MM_PUR_HUB_EBELP	NUMC	10
PROCMTHUBPREDECESSORDOCCAT	Predecessor Purchasing Document Category		MM_PUR_HUB_EBSTYP	CHAR	2
PROCMTHUBPURCHASEREQUISITION	Purchase Requisition Number		BANFN	CHAR	20
PROCMTHUBPURREQUISITIONITEM	Item number of purchase requisition		BNFPO	NUMC	10
SOURCELISTISUPDATED	Sourcelist Updated		MMPUR_SOURCELISTISUPDATED	CHAR	2
SOURCELISTRESTRICTION	Source List Restriction Indicator		SRCELISTRSTRCN	CHAR	4
SRCELISTRESPONSEMSGUUID	Generic Data Element for GUID Fields (X16)		GUID16	RAW	16
SOURCELISTCHANGECONFSTATUS	Source List Change Status		SRCELISTCHANGESTATUS	CHAR	4
PROCMTHUBCOMPANYCODEGROUPINGID	Grouping ID for Company Codes		MMPUR_D_CC_GROUPING_ID	CHAR	6
OUTLINEAGRMTITMISBLOCKED	Boolean Variable (X = True, - = False, Space = Unknown)		BOOLEAN	CHAR	2
PURGDOCITMBLKRSNCODE	Block Reason Code		MMPUR_BLK_RSN_CODE	CHAR	8
INCOTERMSCLASSIFICATION	Incoterms (Part 1)		INCO1	CHAR	6
INCOTERMSLOCATION1	Incoterms Location 1		INCO2_L	CHAR	140
SHIPPINGINSTRUCTION	Shipping Instructions		EVERS	CHAR	4
CNTRLPURCONTRDISTRTRGGRDTETIME	Distribution Trigger Timestamp		MMPUR_CCTR_DSTR_TRG_DTETME	DEC	11
.INCLUDE				MMPUR_CCTR_DISTR_DELIV_ADDR	0
PROCMTHUBSUBCONTRACTOR	Supplier to be Supplied/Who is to Receive Delivery		EMLIF	CHAR	20	*
PROCMTHUBSUPLRISSUBCONTRACTOR	Subcontracting Supplier		LBLKZ	CHAR	2
REFERENCEDELIVERYADDRESSID	Number of delivery address		ADRN2	CHAR	20	*
FORMOFADDRESS	Form-of-Address Key		AD_TITLE	CHAR	8	*
FORMOFADDRESSNAME	Title text		AD_TITLETX	CHAR	60
PROCMTHUBBUSINESSPARTNERNAME1	Name 1		AD_NAME1	CHAR	80
PROCMTHUBBUSINESSPARTNERNAME2	Name 2		AD_NAME2	CHAR	80
PROCMTHUBBUSINESSPARTNERNAME3	Name 3		AD_NAME3	CHAR	80
PROCMTHUBBUSINESSPARTNERNAME4	Name 4		AD_NAME4	CHAR	80
PROCMTHUBSTREETNAME	Street		AD_STREET	CHAR	120
PROCMTHUBHOUSENUMBER	House Number		AD_HSNM1	CHAR	20
PROCMTHUBPOSTALCODE	City postal code		AD_PSTCD1	CHAR	20
PROCMTHUBCITYNAME	City		AD_CITY1	CHAR	80
PROCMTHUBCOUNTRY	Country/Region Key		LAND1	CHAR	6	*
PROCMTHUBREGION	Region (State, Province, County)		REGIO	CHAR	6	*
.INCLUDE				MMPUR_S_CCTR_PRDCSSRDOC_INFO	0
PROCMTHUBPRDCSSRDOCUUID	Predecessor document UUID		MMPUR_PRDCSSRDOC_UUID	RAW	16
PROCMTHUBPRDCSSRDOCITEMUUID	Predecessor document item UUID		MMPUR_PRDCSSRDOC_ITEM_UUID	RAW	16
PROCMTHUBPRDCSSRDOCOBJTYPE	SAP Business Object Type		BO_OBJECT_TYPE	CHAR	60
PROCMTHUBPRDCSSRDOCOBJNODETYPE	SAP Business Object Node Type		BO_NODE_TYPE	CHAR	60