PDC File Format for Goods Receipt in SAP Retail Store 

Definition

Content that the file containing PDC data requires if it is to be used in physical inventory processing in SAP Retail Store.

Use

If you want to further process data that you entered using a handheld terminal (PDC unit), you must store this data in a file that has the format described here. In physical inventory processing in SAP Retail Store, you can enter the name of this file. The function then imports the file and evaluates the data it contains.

In goods receipt processing, a uniform file format is used for both the download (transfer of data to the PDC unit) and upload (transfer of data from the PDC unit to SAP Retail Store).

Structure

Line 1 (header information):

  1. Reference document number

Format: 10-character
The field is used to identify and assign the purchase order or delivery.

  1. Date of entry
  2. Format: 8-character, YYYYMMDD (e.g. 19981130 for November 30, 1998)
    This field is for documentation purposes only

  3. Reference document ID

Format: 4-character
The field is used to identify the reference document for the purchase order or delivery.

  1. Vendor number

Format: 10-character
This field is for documentation purposes only

  1. Vendor name

Format: 35-character
This field is for documentation purposes only

  1. Goods receipt/issue slip number

Format: 10-character
This field is for documentation purposes only

  1. User ID of the person who entered the data

Format: 12-character
This field is for documentation purposes only

  1. File name

Format: 40-character
This field is for documentation purposes only

Lines 2 and over (goods receipt items):

  1. Item number

Format: 4-character
This field is for documentation purposes only

  1. EAN/UPC code
  2. Format: 18-character
    Required entry field

  3. Article text

Format: 40-character
This field is for documentation purposes only

  1. Order quantity
  2. Format: 14-character, 10 places before the decimal point, 3 places after, separated by a period e.g. 0123456789.100
    Required entry field, if not contained in the EAN/UPC code

  3. Order unit

Format: 3-character
This field is for documentation purposes only

  1. Entry quantity
  2. Format: 14-character, 10 places before the decimal point, 3 places after, separated by a period (e.g. 0123456789.100)
    Required entry field, if not contained in the EAN/UPC code

  3. Shelf life expiration date
  4. Format: 8-character, YYYYMMDD (e.g. 19981130 for November 30, 1998)
    Required entry field if the shelf life expiration date indicator (field 8) contains the value 1 or 2, or if it is not contained in the EAN/UPC code. The value is required for posting in the SAP System.

  5. Shelf life expiration date indicator (for field 7)

Format: 1-character
The field is used to control field 7:

If the content of the field = 1, the shelf life expiration date must be entered in field 7.
If the content of the field = 2, the shelf life must be entered in field 7.

  1. Return item indicator

Format: 1-character
Controls whether the entered item is a return item.

  1. Additional text

Format: 50-character
The field is used to enter additional information on the item.

  1. "Delivery completed" indicator

Format: 1-character
Controls whether an item has been delivered in full.

Final line

ASCII character string EOF

Integration

For general information on PDC files in SAP Retail Store, see Linking to PDC Units in SAP Retail Store.