SAP Functional, Basis and ABAP Programming Reference Books
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 : 4.6x 

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 |

------------------------------------------------------------------------------------------ 


Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com