Show TOC

Extractor for Purchase Orders Locate this document in the navigation structure

DataSource Transactional Data DataSource Transactional Data: 0ICH_PO_INT_1

 

The goal of the extractor is to provide SAP Supply Network Collaboration (SAP SNC) relevant data of purchase orders which can be used for further analysis. You can use the extractor in the scenarios where a customer is not running a SAP ERP system.

Note Note

The last three characters XXX of the entries in the fields for Table Of Origin represent the system client that is used to extract the data.

End of the note.

Technical Data

Application Component

SAP Supply Network Collaboration (SAP SNC) 7.01 (0ICH)

Available as of Release

SAP SNC 7.01

Shipment

SAP NetWeaver 7.0 BI Content Add-On 5

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

MANDT

Client

/1OM/ORDR1HDR

CLIENT

PONO

Purchase Order Number

/1OM/ORDR7MP3

ORDNO

POITMNO

Purchase Order Item Number

/1OM/ORDR7MP3

ITMNO

POSDLNNO

Purchase Order Schedule Line Number

/1OM/ORDR7MP3

SDLNO

LOCNOFR

Supplier Location

/1OM/ORDR2IT3

LOCIDFR

LOCNOTO

Customer Location

/1OM/ORDR2IT3

LOCIDTO

LOCNOGR

Goods Recipient Location

/1OM/REWOOEIL

GR_GUID

PRTNOTO

Customer

/1OM/REWO1PRT

PRTID

PRTNOFR

Supplier

/1OM/REWO1PRT

PRTID

PRTNOGR

Goods Recipient

/1OM/REWO2PRA

PRTID

MATNR

Product

/1OM/ORDR2IT3

MATID

QTY

Total Quantity

/1OM/ORDROESL

QTY

QTYUNIT

Quantity Unit

/1OM/ORDROESL

UOM

CONFQTY

Confirmed Quantity

/1OM/ORDROESL

CONFDUEQTY

CONFUNIT

Confirmed Quantity Unit

/1OM/ORDROESL

CONFDUEQTY_UNIT

ASNQTY

ASN Quantity

/1OM/ORDROESL

RECQTY

ASNUNIT

ASN Unit

/1OM/ORDROESL

RECQTY_UNIT

UNITPRICE

Unit Price

/1OM/ORDROEIT

PRICE

UNITPRICECURR

Unit Price Currency

/1OM/ORDROEIT

CURRENCY

TOTPRICE

Total Price

/1OM/ORDROEIT

PRICE

TOTPRICECURR

Total Price Currency

/1OM/ORDROEIT

CURRENCY

DELVDATE

Delivery Date

/1OM/ORDR4SDL

TSTFRTOT

SHPDATE

Ship Date

/1OM/ORDR4SDL

TSTFRFRT

AVLDATE

Availability Date

/1OM/ORDR4SDL

TSTTOTOT

SUPPCONFDATE

Supplier Confirmed Delivery Date

/1OM/ORDR4SDLDXXX

TSTFRTOT

ACT_DLV_QTY

Actual Delivered Quantity

/1OM/ORDR4OESLXXX

RECQTY

ACT_DLV_QTY_UNIT

Unit of Measure

/1OM/ORDR4OESLXXX

RECQTY_UNIT

CREDATE

Creation Date

/1OM/ORDR1HDR

TSTFRFRT

CHGDATE

Change Date

/1OM/ORDR1HDR

TSTFRTOT

CHGUSR

Change User

/1OM/ORDR1HDR

CHGUSR

CHGPRT

Change Partner

/1OM/ORDR1HDR

CHGUSR