Purchase Orders (SAP Library - E-Procurement (<= SRM 4.0))

Purchase Orders

Technical name: 0BBP_TD_PO_1

Technical Data

Type of DataSource	Transaction data (movement data)
Application Component	Procurement process – single documents (0BBP_PROC)
Available from OLTP Release	EBP 1.0 (SAP BBP 2.0B)
Available from Plug-In Release	–
RemoteCube-compatible	No

Use

This DataSource provides order data on header level and document item level, such as product, product category, vendor, requester, purchasing organization, and purchasing group, as well as account assignment information.

Delta Update

The DataSource supports the delta update method ‘AIMD’ (after images with deletion indicator via delta queue).

Fields of Origin in the Extract Structure

Field in Extract Structure	Description of Field in the Extract Structure	Table of Origin	Field in Table of Origin
ITM_SLD_SYS_NAME	Name of a system in the System Landscape Directory (SLD)	BBP_BACKEND_DEST	SLD_SYS_NAME
ITM_SYS_TYPE	System type	BBP_BACKEND_DEST	SYS_TYPE
ACC_ACTIVITY	Activity number	BBP_PDACC	ACTIVITY
ACC_ASSET_NO	Asset main number	BBP_PDACC	ASSET_NO
ACC_BUS_AREA	Business area	BBP_PDACC	BUS_AREA
ACC_CAT	Account assignment category in Enterprise Buyer	BBP_PDACC	ACC_CAT
ACC_CO_AREA	Controlling area	BBP_PDACC	CO_AREA
ACC_COST_CTR	Cost center	BBP_PDACC	COST_CTR
ACC_DISTR_PERC	Distribution percentage in the case of multiple account assignment	BBP_PDACC	DISTR_PERC
ACC_G_L_ACCT	G/L account number	BBP_PDACC	G_L_ACCT
ACC_GUID	Globally unique identifier in 32 char. representation	BBP_PDACC	GUID
ACC_NETWORK	Network number for account assignment	BBP_PDACC	NETWORK
ACC_NO	Sequential number of account assignment in purchasing document (EBP)	BBP_PDACC	ACC_NO
ACC_ORDER_NO	Order number	BBP_PDACC	ORDER_NO
ACC_PROFIT_CTR	Profit center	BBP_PDACC	PROFIT_CTR
ACC_STR	Generic account assignment	BBP_PDACC	ACC_STR
ACC_SUB_NUMBER	Asset subnumber	BBP_PDACC	SUB_NUMBER
ACC_WBS_ELEM_E	Work breakdown structure element	BBP_PDACC	WBS_ELEM_E
CMMT_ITEM	Commitment item	BBP_PDACC	CMMT_ITEM
FUNC_AREA	Functional area	BBP_PDACC	FUNC_AREA
FUND	Fund	BBP_PDACC	FUND
FUNDS_CTR	Funds center	BBP_PDACC	FUNDS_CTR
SCHED_LINE	Schedule line number	BBP_PDACC	SCHED_LINE
SD_DOC	Sales document number	BBP_PDACC	SD_DOC
SDOC_ITEM	Sales document item	BBP_PDACC	SDOC_ITEM
BE_LOG_SYSTEM	Logical system of logistics backend	BBP_PDBEH or BBP_PDBEI	BE_LOG_SYSTEM
ACCEPT_QUANTITY	Accepted quantity	BBP_PDCON	QUANTITY
CURRENCY	Currency key	BBP_PDHGP	CURRENCY
CO_CODE	Company code in FI system	BBP_PDHGP	CO_CODE
LOGSYS_FI	Logical system of the FI system	BBP_PDHGP	LOGSYS_FI
VPER_END	Time frame to	BBP_PDHGP	VPER_END
VPER_START	Time frame from	BBP_PDHGP	VPER_START
PCINS	Procurement card company	BBP_PDHGP	PCINS
PCNUM	Procurement card number	BBP_PDHGP	PCNUM
ITM_CTR_ITM_NO	Item number in document	BBP_PDIGP	CTR_ITEM_NUMBER or LIM_REF_I_ID
ITM_CTR_ITMGUID	Contract item GUID 32 char.	BBP_PDIGP	CTR_GUID or LIM_REF_I_GUID
ITM_CTR_NUMBER	Contract number	BBP_PDIGP	CTR_HDR_NUMBER or LIM_REF_H_ID
ITM_CATALOGID	Catalog ID from which the line is selected	BBP_PDIGP	CATALOGID
ITM_CAT_GUID	Globally unique identifier in 32 char. representation	BBP_PDIGP	CATEGORY
ITM_CATEGORY_ID	Category ID	BBP_PDIGP	CATEGORY_ID
ITM_CT_CAT_ID	Category name	BBP_PDIGP	CT_CATEGORY_ID
ITM_DEL_IND	Deletion indicator purchasing document (EBP)	BBP_PDIGP	DEL_IND
ITM_DELIV_DATE	Delivery date of the item	BBP_PDIGP	DELIV_DATE
ITM_EX_CT_UN_ID	Unique key in the external category	BBP_PDIGP	ITM_EX_CT_UN_ID
ITM_FINAL_ENTRY	Final entry indicator (goods/services)	BBP_PDIGP	FINAL_ENTRY
ITM_FINAL_INV	Final invoice indicator	BBP_PDIGP	FINAL_INV
ITM_MANU_PROD	Manufacturer part number	BBP_PDIGP	MANU_PROD
ITM_MFR_NO_EXT	External description of the manufacturer	BBP_PDIGP	MFR_NO_EXT
ITM_PRICE	Net price	BBP_PDIGP	PRICE
ITM_PRICE_UNIT	Price unit	BBP_PDIGP	PRICE_UNIT
ITM_PRODUCT_TYPE	Product type	BBP_PDIGP	PRODUCT_TYPE
ITM_QUANTITY	Quantity in order unit	BBP_PDIGP	QUANTITY
ITM_SCHEMA_TYPE	Standard schema type	BBP_PDIGP	SCHEMA_TYPE
ITM_SUBTYPE	Characteristic value purchasing item (for example direct mat./hierarchy)	BBP_PDIGP	SUBTYPE
ITM_UNIT	Purchase order unit of measure	BBP_PDIGP	UNIT
ITM_VALUE	Net value	BBP_PDIGP	VALUE
ITM_CTR_GUID	Contract header GUID 32 char.	BBP_PDIGP or BBP_PDLIM	CTR_HDR_GUID or LIM_REF_H_GUID
ITM_LIM_K	Contract limit	BBP_PDLIM	LIMIT
ITM_LIM_S	Other limit	BBP_PDLIM	LIMIT
ITM_UNLIMITED	No limit indicator	BBP_PDLIM	UNLIMITED
ITM_EXP_VALUE	Expected value	BBP_PDLIM	EXP_VALUE
ITM_LIM_G	Total limit	BBP_PDLIM	LIMIT
ORG_PURCH_GROUP	Responsible purchasing group	BBP_PDORG	PROC_GROUP
ORG_PURCH_ORG	Responsible purchasing organization	BBP_PDORG	PROC_ORG
ORG_RESP_ORG	Responsible org. unit (purchasing)	BBP_PDORG	PROC_ORG_RESP
CONF_BASEDIV	GR-based invoice verification indicator	BBP_PDPSET	GR_BASEDIV
CONF_IND	Goods receipt indicator	BBP_PDPSET	GR_IND
CONF_NON_VAL	Goods receipt non-valuated	BBP_PDPSET	GR_NON_VAL
ERS	Evaluated receipt settlement	BBP_PDPSET	ERS
IR_IND	Invoice receipt indicator	BBP_PDPSET	IR_IND
ITM_TAX_CODE	Tax code	BBP_PDTAX	TAX_CODE
ITM_TAX_AMOUNT	Tax amount	BBP_PDTAX	TAX_AMOUNT
STAT_PROCESS	Individual status of an object	CRM_JEST	STAT
ITM_SC_H_GUID	GUID of a CRM Order Object	CRMD_ORDERADM_H	GUID via SCR_GUID from BBP_PDHGP
ITM_SC_H_OBJ_ID	Number of shopping cart	CRMD_ORDERADM_H	OBJECT_ID
CREATED_AT	Creation date of document	CRMD_ORDERADM_H	CREATED_AT
CREATED_BY	User that created the order	CRMD_ORDERADM_H	CREATED_BY
CHANGED_AT	Change date of document	CRMD_ORDERADM_H	CHANGED_AT
CHANGED_BY	Order last changed by	CRMD_ORDERADM_H	CHANGED_BY
DESCRIPTION	Description of a transaction	CRMD_ORDERADM_H	DESCRIPTION
DESCRIPTION_UC	Transaction description (capital letters)	CRMD_ORDERADM_H	DESCRIPTION_UC
GUID	PO GUID 32 char.	CRMD_ORDERADM_H	GUID
PO_DATE	Order date	CRMD_ORDERADM_H	POSTING_DATE
PO_NUMBER	Purchase order number	CRMD_ORDERADM_H	OBJECT_ID
PROCESS_TYPE	Business transaction type	CRMD_ORDERADM_H	PROCESS_TYPE
ITM_SC_ITEM_NO	Item number in PO document	CRMD_ORDERADM_I	NUMBER_INT
ITM_SC_ITM_GUID	Globally unique identifier in 32 char. representation	CRMD_ORDERADM_I	GUID via SCR_GUID from BBP_PDIGP
ITM_PRODUCT_GUID	Product GUID in 32 char. representation	CRMD_ORDERADM_I	PRODUCT_GUID
ITM_PARTNER_PROD	Product number of business partner	CRMD_ORDERADM_I	PARTNER_PROD
ITM_PROD_SRC_SYS	Logical system from which the product originates	CRMD_ORDERADM_I	PROD_SRC_SYS
ITM_CREATED_AT	Creation date of document	CRMD_ORDERADM_I	CREATED_AT
ITM_CREATED_BY	User that created the order	CRMD_ORDERADM_I	CREATED_BY
ITM_CHANGED_AT	Change date of document	CRMD_ORDERADM_I	CHANGED_AT
ITM_CHANGED_BY	Order last changed by	CRMD_ORDERADM_I	CHANGED_BY
ITM_DESCRIPT_UC	Product short text in capital letters for F4 help	CRMD_ORDERADM_I	ITM_DESCRIPT_UC
ITM_DESCRIPTION	Product description	CRMD_ORDERADM_I	ITM_DESCRIPTION
ITM_GUID	PO Item GUID 32 char.	CRMD_ORDERADM_I	GUID
ITM_NUMBER	Item number in document	CRMD_ORDERADM_I	NUMBER_INT
ITM_PARENT	Globally unique identifier in 32 char. representation	CRMD_ORDERADM_I	PARENT
ITM_PRODUCT_ID	Entered product name	CRMD_ORDERADM_I	PRODUCT_ID
ITM_TYPE	Item category	CRMD_ORDERADM_I	ITM_TYPE
BUP_ORDERER_GUID	Company GUID 32 char.	CRMD_PARTNER	PARTNER_GUID (PARTNER_FCT ‘01’)
BUP_ORDERER_ID	Business partner number	CRMD_PARTNER	PARTNER_NO (PARTNER_FCT ‘01’)
BUP_RECIPNT_GUID	Goods recipient GUID 32 char.	CRMD_PARTNER	PARTNER_GUID (PARTNER_FCT ‘20’)
BUP_RECIPNT_ID	Business partner number	CRMD_PARTNER	PARTNER_NO (PARTNER_FCT ‘20’)
BUP_REQUEST_GUID	Requester GUID 32 char.	CRMD_PARTNER	PARTNER_GUID (PARTNER_FCT ‘16’)
BUP_REQUEST_ID	Business partner number	CRMD_PARTNER	PARTNER_NO (PARTNER_FCT ‘16’)
BUP_VENDOR_GUID	Vendor GUID 32 char.	CRMD_PARTNER	PARTNER_GUID (PARTNER_FCT ‘19’)
BUP_VENDOR_ID	Business partner number	CRMD_PARTNER	PARTNER_NO (PARTNER_FCT ‘19’)
ITM_COUNT	Counter for number of items	Determined in extractor
PO_COUNT	Counter for number of order headers	Determined in extractor
BBP_LOG_SYSTEM	Logical system EBP	Determined in extractor from T000	LOGSYS
UPDMOD	BW delta method: update mode	Set	‘D’ – delete ‚ ‚ - after image
GRANT_NBR	Grant	BBP_PDACC	GM_GRANT_NBR
ITM_CUSTOMER_ID	Customer number	BUTP000 or CRMD_PARTNER (1. if internal customer, 2. if external customer)	PARTNER or PARTNER_NO (1. if internal customer, 2. if external customer)
ITM_CUST_GUID	Customer GUID	CRMD_PARTNER or empty (1. if customer internal, 2. if customer external)	PARTNER_NO or empty (1. if internal customer, 2. if external customer)
ITM_CUST_SRC_SYS	Logical system (customer)	CRMD_PARTNER	PARTNER_SRC_SYS
ITM_CUST_NAME	Name 1/last name	BUT000	MC_NAME1
ITM_WORKER_ID	Service provider number	CRMD_PARTNER	PARTNER_NO
ITM_WORKER_NAME	Full name	BUT000	MC_NAME1, MC_NAME2
ITM_WRKR_SRC_SYS	Logical system from which the partner originates	CRMD_PARTNER	PARTNER_SRC_SYS
ITM_LOC_ID	Plant number	CRMD_PARTNER	PARTNER_NO

Features of the Extractor

The extraction of an order document is structured in such a way that the relevant characteristic and key figure information is extracted into a data record for header and item level.

The system differentiates between limit purchase orders with and without limit contract and purchase orders with items. Information on limit contracts is stored on item level.