Extracting Data from an External System (SAP Library

Extracting Data from an External System

Use

Billing data from an external system must be prepared in a sequential file which must fulfill the following requirements:

Sequential file structure

Record	Data
1. 1st main record (Billing data)	Indicator A in first position
	Structure as of 2nd position analogue communication structure KOMFKGN
1st - nth secondary record (Pricing element)	Indicator B in first position
	Structure as of 2nd position analogue communication structure KOMFKKO
	The client in the secondary record (MANDT) must correspond to the client in the main record (MANDT)
	The document condition number in the secondary record (KNUMV) must correspond to the document number of the reference document in the main record (VGBEL)
	The condition item number (KPOSN) must correspond to the item number of the reference business transaction item in the main record (VGPOS)

Sorting main records in the sequential file according to:

Object	Field name
Sales organization	VKORG
Distribution channel	VTWEG
Sold-to party	KUNAG
Document number of the reference document	VGBEL
Item number of the reference item	VGPOS

This graphic is explained in the accompanying text

Processing errors

You can carry out a check run with sample report RVAFSS00 to display faulty records in the sequential file before final billing. All errors are displayed in an error log. After correcting the faulty records in the sequential file, you must restart the billing procedure. The system ignores records which have already been billed and creates billing documents for records which have been corrected. Optionally, a list of new billing documents is presented with the error log.