Extractor for Inventory

DataSource Transactional Data: 0ICH_INV_INT_1

The goal of the extractor is to provide SAP Supply Network Collaboration (SAP SNC) relevant inventory data, 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.

Technical Data

Application Component	SAP Supply Network Collaboration (SAP SNC) 7.0 (0ICH)
Available as of Release	SAP SNC 7.0
Shipment	SAP NetWeaver 7.0 BI Content Add-On 4
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
LOCNO	Location Number	TSDM	Stored in TDSM tables. Table names are variable.
MATNR	Material Number	TSDM	Stored in TDSM tables. Table names are variable.
REF_PRTNO	Partner	TSDM	Stored in TDSM tables. Table names are variable.
SUPPLIER	Supplier	TSDM	Stored in TDSM tables. Table names are variable.
PROMO	Promotion Number	TSDM	Stored in TDSM tables. Table names are variable.
LOCNOFR	Location Number	TSDM	Stored in TDSM tables. Table names are variable.
BATCHID	Batch ID	TSDM	Stored in TDSM tables. Table names are variable.
LOCID	Location ID	TSDM	Stored in TDSM tables. Table names are variable.
MATID	Material ID	TSDM	Stored in TDSM tables. Table names are variable.
REF_LOCID	Reference Location ID	TSDM	Stored in TDSM tables. Table names are variable.
REF_PRTID	Reference Partner ID	TSDM	Stored in TDSM tables. Table names are variable.
PROMID	Promotion ID	TSDM	Stored in TDSM tables. Table names are variable.
BATCHID	Batch Number	TSDM	Stored in TDSM tables. Table names are variable.
DATAPROVPRTID	Data Provider Partner ID	TSDM	Stored in TDSM tables. Table names are variable.
DATAPROVPRT	Data Provider Partner	TSDM	Stored in TDSM tables. Table names are variable.
LOCFRID	Location From GUID	TSDM	Stored in TDSM tables. Table names are variable.
REFLOC	Reference Location	TSDM	Stored in TDSM tables. Table names are variable.
STOCK_USAGE	Stock Usage	TSDM	Stored in TDSM tables. Table names are variable.
CAT	Stock Category	TSDM	Stored in TDSM tables. Table names are variable.
QUANTITY	Quantity	TSDM	Stored in TDSM tables. Table names are variable.
UNIT	Unit of Measure	TSDM	Stored in TDSM tables. Table names are variable.
UPARTNER	Changing Partner	TSDM	Stored in TDSM tables. Table names are variable.
UUSER	Changing User	TSDM	Stored in TDSM tables. Table names are variable.
UDATE	Change Date	TSDM	Stored in TDSM tables. Table names are variable.
UTIME	Change Time	TSDM	Stored in TDSM tables. Table names are variable.
CDATE	Creation Date	TSDM	Stored in TDSM tables. Table names are variable.
CTIME	Creation timestamp	TSDM	Stored in TDSM tables. Table names are variable.
CTST	Change time stamp	TSDM	Stored in TDSM tables. Table names are variable.