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 |

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

Related Topics:
Create/Modify Billing Document Type
Steps for creating new or changing existing Billing Doc Type

SAP SD Books
SAP Sales and Distribution, Certification, Interview Questions Reference Books

SAP Sales and Distribution Tips
SAP SD - Sales/Distribution Tips

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

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.