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