| 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
Sample flat file for uploading table A305 - Customer/Material with release status :- 0BIPRICE 123SAPABAP
X
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:
SAP SD Books
SAP Sales and Distribution Tips
Best regards,
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|