Purchase Order History

: 0SRM_TD_PO

This DataSource provides procurement data on document header, document item, and schedule line level, such as product, product category, supplier, requester, purchasing organization, and purchasing group.

The DataSource exhibits the following peculiarities:

Business partner field for customer
Business partner fields for customers (for example ITM_CUSTOMER_ID, ITM_CUST_SRC_SYS, ITM_CUST_NAME, ITM_CUST_NO_TYPE) are only filled in the case of a third-party purchase order. The Customer ID is always the Goods Recipient ID.

Purchase order with limit items
An individual line is generated for each limit type. Only the line with the limit type "Total Limit“ is assigned.
Contract references
Information on contract references are only extracted for the Standalone Scenario and the Extended Classic Scenario of SRM.

Technical Data

Application Component	Purchase order history (0SRM_PROC_PO)
Available as of Release	SRM 5.0
Shipment	NW 2004s BI Content Add-On 2
Content Versions	No content versions exist.
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`GUID`	GUID of document	`CRMD_ORDERADM_H`	`GUID`
`OBJECT_ID`	Document number	`CRMD_ORDERADM_H`	`OBJECT_ID`
`PROCESS_TYPE`	Business transaction type	`CRMD_ORDERADM_H`	`PROCESS_TYPE`
`POSTING_DATE`	Posting date	`CRMD_ORDERADM_H`	`POSTING_DATE`
`DESCRIPTION`	Description of document	`CRMD_ORDERADM_H`	`DESCRIPTION`
`CREATED_AT`	Creation date of document	`CRMD_ORDERADM_H`	`CREATED_AT`
`CHANGED_AT`	Change date of document	`CRMD_ORDERADM_H`	`CHANGED_AT`
`CREATED_BY`	User that created the document	`CRMD_ORDERADM_H`	`CREATED_BY`
`CHANGED_BY`	User that changed the document	`CRMD_ORDERADM_H`	`CHANGED_BY`
`ORDERER_ID`	Ordering party ID	`BUT000`	`PARTNER`
`VENDOR_ID`	Supplier ID	`BUT000`	`PARTNER`
`CO_CODE`	Company code in FI system	`BBP_PDHGP`	`CO_CODE`
`BBP_LOG_SYSTEM`	Logical system for SRM	`T000`	`LOGSYS`
`BE_LOG_SYSTEM`	Logical system of logistics backend	`BBP_PDBEH`	`BE_LOG_SYSTEM`
`LOGSYS_FI`	Logical system of the FI system	`BBP_PDHGP`	`LOGSYS_FI`
`TOTAL_VALUE_APPR`	Total value of the shopping cart at the time of approval (BI)	`BBP_PDHGP`	`TOTAL_VALUE_APPR`
`CURRENCY`	Currency of document	`BBP_PDHGP oder BBP_PDIGP`	`CURRENCY`
`VPER_START`	Time frame from	`BBP_PDIGP`	`VPER_START`
`VPER_END`	Time frame to	`BBP_PDIGP`	`VPER_END`
`PCINS`	Procurement card company	`BBP_PDHGP oder BBP_PDIGP`	`PCINS`
`PCNUM`	Procurement card number	`BBP_PDHGP oder BBP_PDIGP`	`PCNUM`
`INCOTERM_KEY`	Incoterm key	`BBP_PDHGP oder BBP_PDIGP`	`INCOTERM_KEY`
`INCOTERM_LOC`	Incoterm location	`BBP_PDHGP oder BBP_PDIGP`	`INCOTERM_LOC`
`CONF_IND`	Goods receipt indicator	`BBP_PDPSET`	`GR_IND`
`IR_IND`	Invoice receipt indicator	`BBP_PDPSET`	`IR_IND`
`CONF_NON_VAL`	Goods receipt non-valuated	`BBP_PDPSET`	`GR_NON_VAL`
`CONF_BASEDIV`	Indicator for goods receipt-based invoice verification	`BBP_PDPSET`	`GR_BASEDIV`
`ERS`	Evaluated receipt settlement	`BBP_PDPSET`	`ERS`
`DOC_COUNT`	Counter for number of documents	`calculated in the extractor`	`= 1: header line; = 0 : everything else`
`STAT_PROCESS`	Processing status	`CRM_JEST`	`STAT`
`ITM_DELIV_DATE`	Delivery date of the item	`BBP_PDIGP`	`DELIV_DATE`
`ITM_GUID`	GUID of item	`CRMD_ORDERADM_I`	`GUID`
`ITM_CREATED_AT`	Item created on	`CRMD_ORDERADM_I`	`CREATED_AT`
`ITM_CHANGED_AT`	Change date of item	`CRMD_ORDERADM_I`	`CHANGED_AT`
`ITM_CREATED_BY`	User that created the item	`CRMD_ORDERADM_I`	`CREATED_BY`
`ITM_CHANGED_BY`	User that changed the item	`CRMD_ORDERADM_I`	`CHANGED_BY`
`ITM_PRODUCT_GUID`	Product GUID	`CRMD_ORDERADM_I`	`PRODUCT`
`ITM_PRODUCT_ID`	Product ID	`CRMD_ORDERADM_I`	`ORDERED_PROD`
`ITM_PARTNER_PROD`	Product ID of partner	`CRMD_ORDERADM_I`	`PARTNER_PROD`
`ITM_DESCRIPTION`	Product description	`CRMD_ORDERADM_I`	`DESCRIPTION`
`ITM_NUMBER`	Item number	`CRMD_ORDERADM_I`	`NUMBER_INT`
`ITM_CAT_GUID`	Product category GUID	`BBP_PDIGP`	`BBP_PDIGP CATEGORY`
`ITM_CATEGORY_ID`	Product category ID	`BBP_PDIGP`	`CATEGORY_ID`
`ITM_SCHEMA_TYPE`	Standard schema type	`BBP_PDIGP`	`SCHEMA_TYPE`
`ITM_EXT_CAT_ID`	Unique key in the external category	`BBP_PDIGP`	`ITM_EX_CT_UN_ID`
`ITM_EXT_CAT_NAME`	Category name	`BBP_PDIGP`	`CT_CATEGORY_ID`
`ITM_MANU_PROD_IN`	Manufacturer part number	`BBP_PDIGP`	`MANU_PROD`
`ITM_MANU_PROD_EX`	External description of the manufacturer	`BBP_PDIGP`	`MFR_NO_EXT`
`ITM_CATALOGID`	ID of catalog from which the line is selected	`BBP_PDIGP`	`CATALOGID`
`ITM_PRODUCT_TYPE`	Product type	`BBP_PDIGP`	`PRODUCT_TYPE`
`ITM_QUANTITY`	Quantity in order unit	`BBP_PDIGP`	`QUANTITY`
`ITM_QUANTITY_BUM`	Quantity in basic unit of measure	`calculated in the extractor`
`ITM_CF_QUANTITY`	Reference quantity of confirmation in order unit	`for item: BBP_PDIGP; for schedule line: calculated in the extractor`	`for item: QUAN_CF; for schedule line: calculated in the extractor`
`ITM_CF_QUAN_BUM`	Reference quantity of confirmation in base unit	`calculated in the extractor`
`ITM_IV_QUANTITY`	Reference quantity of invoice in order unit	`for item: BBP_PDIGP; for schedule line: Im calculated in the extractor`	`for item: QUAN_IV; for schedule line: calculated in the extractor`
`ITM_IV_QUAN_BUM`	Reference quantity of invoice in base unit	`calculated in the extractor`
`ITM_UNIT`	Order unit	`BBP_PDIGP`	`UNIT`
`ITM_BASE_UNIT`	Base unit of measurement	`COMM_PR_UNIT`	`IS_BASE_UNIT`
`ITM_PRICE`	Net price	`BBP_PDIGP`	`PRICE`
`ITM_PRICE_UNIT`	Price unit	`BBP_PDIGP`	`PRICE_UNIT`
`ITM_VALUE`	Net value	`BBP_PDIGP`	`VALUE`
`ITM_CF_VALUE`	Reference item net value of confirmation in order currency	`for item: BBP_PDIGP; for schedule line: calculated in the extractor`	`for item: VAL_CF;for schedule line: calculated in the extractor`
`ITM_IV_VALUE`	Reference item net value of invoice in order currency	`for item: BBP_PDIGP; for schedule line: calculated in the extractor`	`for item: VAL_IV; for schedule line: calculated in the extractor`
`ITM_REQUEST_ID`	Requester ID	`BUT000`	`PARTNER`
`ITM_RECIPNT_ID`	Recipient ID	`BUT000`	`PARTNER`
`ITM_LOC_ID`	Location ID	`BUT000`	`PARTNER`
`ITM_WORKER_ID`	Service agent ID	`BUT000`	`PARTNER`
`ITM_WRKR_SRC_SYS`	Logical system from which the partner originates	`BUT000`	`SRV_PROV_SRC_SYS`
`ITM_WORKER_NAME`	Full name of service agent	`BUT000`	`SRV_PROV_FIRSTNAME / SRV_PROV_LASTNAME`
`ITM_WRK_NO_TYPE`	Internal service agent type (for example, GUID or pers. no.)	`BUT000`	`SRV_PROV_NO_TYPE`
`ITM_CUSTOMER_ID`	Customer ID	`BUT000 oder CRMD_PARTNER`	`PARTNER: Kunde intern; PARTNER_NO: Kunde extern`
`ITM_CUST_SRC_SYS`	Logical system from which the partner originates	`CRMD_PARTNER`	`PARTNER_SRC_SYS`
`ITM_CUST_NAME`	Customer name	`BUT000`	`MC_NAME1`
`ITM_CUST_NO_TYPE`	Internal customer number type (for example, GUID or pers. no.)	`CRMD_PARTNER`	`NO_TYPE`
`ITM_TYPE`	Item category	`CRMD_ORDERADM_I`	`ITM_TYPE`
`ITM_LIM_GUID`	GUID of limit	`BBP_PDLIM`	`SET_GUID`
`ITM_LIM_CTR`	Contract limit	`BBP_PDLIM`	`LIMIT`
`ITM_LIM_OTHER`	Other limit	`BBP_PDLIM`	`LIMIT`
`ITM_LIM_OVERALL`	Total limit	`BBP_PDLIM`	`LIMIT`
`ITM_UNLIMITED`	No limit indicator	`BBP_PDLIM`	`UNLIMITED`
`ITM_EXP_VALUE`	Expected value	`BBP_PDLIM`	`EXP_VALUE`
`ITM_TAX_CODE`	Sales tax code	`BBP_PDIGP`	`TAX_CODE`
`ITM_TAX_AMOUNT`	Tax amount	`BBP_PDTAX`	`TAX_AMOUNT`
`ITM_PROD_SRC_SYS`	Original logical system of the product	`CRMD_ORDERADM_I`	`PRODUCT_SRC_SYS`
`ITM_SYS_TYPE`	System type	`BBP_BACKEND_DEST`	`SYS_TYPE`
`ITM_SLD_SYS_NAME`	Name of a system in the System Landscape Directory (SLD)	`BBP_BACKEND_DEST`	`SLD_SYS_NAME`
`ITM_SC_NUMBER`	Reference shopping cart number	`CRMD_ORDERADM_H`	`GUID`
`ITM_SC_ITEM_NO`	Reference item number of shopping cart	`CRMD_ORDERADM_I`	`NUMBER_INT`
`ITM_DEL_IND`	Deletion indicator purchasing document (SRM)	`BBP_PDIGP`	`DEL_IND`
`ITM_FINAL_INV`	Final invoice indicator	`BBP_PDIGP`	`FINAL_INV`
`ITM_FINAL_ENTRY`	Indicator of last entry (goods/services) in purchase order	`BBP_PDIGP`	`FINAL_ENTRY`
`ITM_FIN_ENTRY_CF`	Indicator of last entry (goods/services) in confirmation
`ITM_CTR_NUMBER`	Reference contract number	`BBP_PDIGP`	`CTR_HDR_NUMBER`
`ITM_CTR_ITM_NO`	Reference item number of contract	`BBP_PDIGP`	`CTR_ITEM_NUMBER`
`ACCEPT_QUANTITY`	Accepted quantity	`BBP_PDCON`	`Summe aller QUANTITY-Werte`
`ACCEPT_QUAN_BUM`	Accepted quantity in basic unit of measure	`Im Extraktor ermittelt`
`ITM_SUBTYPE`	Characteristic value purchasing item (for example direct material/hierarchy)	`BBP_PDIGP`	`SUBTYPE`
`ITM_COUNT`	Counter for number of items	`calculated in the extractor`	`= 1 : item; = 0 : everything else`
`SCL_NO`	Schedule line number	`BBP_PDSDLN`	`SCHEDLIN_NO`
`SCL_CREATED_AT`	Creation date of schedule line	`BBP_PDSDLN`	`CREATED_AT`
`SCL_CHANGED_AT`	Change date of schedule line	`BBP_PDSDLN`	`CHANGED_AT`
`SCL_COUNT`	Counter for schedule lines	`calculated in the extractor`	`= 1 : schedule line; = 0 : everything else`
`ORG_RESP_ORG`	Responsible org. unit (purchasing)	`BBP_PDORG`	`PROC_ORG_RESP`
`ORG_PURCH_ORG`	Responsible purchasing organization	`BBP_PDORG`	`PROC_ORG`
`ORG_PURCH_GROUP`	Responsible purchasing group	`BBP_PDPRG`	`PROC_GROUP`
`UPDMOD`	BW delta procedure: Record mode	`calculated in the extractor`	`= ‘D’ : deletion record; = ‘ ‘ : After-Image`
`ITM_PARENT`	Globally Unique Identifier in 32-Character Display	`CRMD_ORDERADM_I`	`PARENT`
`FUNDS_RES`	Document number earmarked funds	`BBP_PDACC`	`FUNDS_RES`
`RES_ITEM`	Document item earmarked funds	`BBP_PDACC`	`RES_ITEM`
`ITM_REV_LEV`	Revision Level	`BBP_PDIGP`	`REV_LEV`
`PS_HIER_TEMPL`	Hierarchy Template	`BBP_PDHSS`	`PS_HIER_TEMPL`
`PS_HL_ITEM`	Higher-Level Item GUID	`BBP_PDISS`	`PS_HL_ITEM`
`PS_HANDLE_ITM`	Globally Unique identifier	`BBP_PDISS`	`PS_HANDLE_ITEM`
`PS_EXSNR`	External Sort Number	`BBP_PDISS`	`PS_EXSNR`
`PS_CTRL_KEY`	Item Process Type Control Key	`BBP_PDISS`	`PS_CTRL_KEY`
`EXLIN`	Configurable Line Item Number	`BBP_PDIGP`	`EXLIN`
`PS_IPT`	Public Sector Item Type	`BBP_PDISS`	`PS_IPT`

Extractor Logic

You can find a description of the extractor logic under DataSources.