Powered By

Free XML Skins for Blogger

Powered by Blogger

Monday, November 9, 2009

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 |

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

No comments:

Archives