Skip to Content

Sales and Distribution – Upload Condition Pricing

RV14BTCI – Batch Input for Uploading Condition Pricing

After executing the program, you have to use SM35 to process the update program.

Envirionment :

Require flat file :-

ROW 1 BGR00 
ROW 2 BKOND1 
ROW 3 BKOND2 – no scale 
ROW 4 BKOND2 – no scale 
ROW 5 BKOND3 – with scale 
ROW 6 BKOND2 – no scale

Sample flat file for uploading table A305 – Customer/Material with release status :-

0BIPRICE 123SAPABAP X 
1VK15 A305V PR00 
2ALL 990000123456SAP8204142100 2002043020020401 50USD    100PC 
2ALL 990000123456SAP8217168100 2002043020020401 50USD    100PC 
3 100PC 2
3 200PC 1 
2ALL 990000123456SAP8220133910

There a total of 4 flat file format :-

BGR00 – Session Header Record

——————————————————————————————

| Field name | Description          | Report header        | Cat.      | Length | Dec.   |

——————————————————————————————

| STYPE      | Record type          | 0 | CHAR      | 000001 | 000000 |

| GROUP      | Group name           | BI Session Name      | CHAR      | 000012 | 000000 |

| MANDT      | Client | Your client no       | CLNT      | 000003 | 000000 |

| USNAM      | User ID | Queue user ID        | CHAR      | 000012 | 000000 |

| START      | Lock until:          | Queue start date     | DATS      | 000010 | 000000 |

| XKEEP      | Keep indicator       | X – don’t delete SESS| CHAR      | 000001 | 000000 |

| NODATA     | No batch input | / | CHAR      | 000001 | 000000 |

——————————————————————————————

BKOND1 – Header Record

——————————————————————————————

| Field name | Description          | Report header        | Cat.      | Length | Dec.   |

——————————————————————————————

| STYPE      | Record type          | 1 | CHAR      | 000001 | 000000 |

| TCODE      | Transaction code     | TCode = VK15         | CHAR      | 000020 | 000000 |

| KVEWE      | Usage | U | CHAR      | 000001 | 000000 |

| KOTABNR    | Table | Table e.g. 305       | CHAR      | 000003 | 000000 |

| KAPPL      | Application          | App e.g V           | CHAR      | 000002 | 000000 |

| KSCHL      | Condition type | CTyp e.g PR00        | CHAR      | 000004 | 000000 |

——————————————————————————————

BKOND2 – Main Data Record

——————————————————————————————

| Field name | Description          | Report header        | Cat.      | Length | Dec.   |

——————————————————————————————

| STYPE      | Record type          | 2 | CHAR      | 000001 | 000000 |

| VAKEY      | VarKey | VarKey | CHAR      | 000100 | 000000 |

| DATBI      | Valid to             | Valid to             | DATS      | 000010 | 000000 |

| DATAB      | Valid on             | Valid on             | DATS      | 000010 | 000000 |

| KBETR      | Amount | Amount | CHAR      | 000015 | 000000 |

| KONWA      | R/2 table            | R2tab | CHAR      | 000005 | 000000 |

| KPEIN      | R/2 table            | R2tab | CHAR      | 000005 | 000000 |

| KMEIN | | | CHAR      | 000003 | 000000 |

| MWSK1      | Tax code | Tx | CHAR      | 000002 | 000000 |

| KONMS      | Scale UoM            | UoM | UNIT      | 000003 | 000000 |

| MXWRT      | Amount | Amount | CHAR      | 000015 | 000000 |

| GKWRT      | Amount | Amount | CHAR      | 000015 | 000000 |

| STFKZ      | Scale type           | S | CHAR      | 000001 | 000000 |

| KZNEP      | Exclusion            | CndEx | CHAR      | 000001 | 000000 |

| LOEVM_KO   | Deletion indic.      | D | CHAR      | 000001 | 000000 |

| SKONWA     | R/2 table            | R2tab | CHAR      | 000005 | 000000 |

——————————————————————————————

BKOND3 – Scale Data Record

——————————————————————————————

| Field name | Description          | Report header        | Cat.      | Length | Dec.   |

——————————————————————————————

| STYPE      | Record type          | 3 | CHAR      | 000001 | 000000 |

| KSTBM      | Quantity | Quantity | CHAR      | 000018 | 000000 |

| KONMS      | Scale UoM            | UoM | UNIT      | 000003 | 000000 |

| KBETR      | Amount | Amount | CHAR      | 000015 | 000000 |

——————————————————————————————


Be the first to leave a comment
You must be Logged on to comment or reply to a post.