Show TOC

 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

  • 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.