Wednesday, 27 January 2010
SAP Community Network Wiki - ABAP Development - Vendor Master Upload Program
"Vendor Master Upload Program"
Purchasing Tables = Vendor
Segment | Description |
SKA1 | G/L master (chart of accounts area) |
SKAT | G/L account master (chart of accts. area: description) |
SKB1 | G/L account master (company code master) |
SKAS | G/L account master (chart of accounts: key word directory) |
The FI_ACCRECV archiving object consists of the following segments:
Segment | Description |
KNA1 | Customer master (general part) |
KNBK | Customer master (bank details) |
KNAS | Customer master (VAT registration number general section) |
KNAT | Customer master (tax groups) |
KNKA | Customer master credit management: central data |
KNKK | Customer master credit management: control area |
KLPA | Customer/vendor linking |
KNZA | Permitted alternative payer |
KNB1 | Customer master (company code) |
KNB5 | Customer master (dunning data) |
KNB4 | Customer payment history |
KNVA | Customer master loading points |
KNEX | Customer master: export control file |
KNVI | Customer master tax indicator |
KNVL | Customer master licenses |
KNVK | Customer master contact partner |
KNVS | Customer master shipping data |
KNVV | Customer master sales data |
KNVD | Customer master record sales request form |
KNVP | Customer master partner functions |
KNMT | Customer material info record data table |
The FI_ACCPAYB archiving object consists of the following segments:
Segment | Description |
LFA1 | Vendor master (general section) |
LFB1 | Vendor master (company code) |
LFB5 | Vendor master (dunning data) |
LFAS | Vendor master (Vat registration number general section) |
LFAT | Vendor master (tax groups) |
KLPA | Customer/vendor linking |
LFBK | Vendor master (bank details) |
LFZA | Permitted alternative payees |
LFM1 | Vendor master (purchasing organization) |
WYT1 | Vendor sub-range |
WYT1T | Vendor sub-range: description |
LFLR | Vendor master record: supply regions |
LFM2 | Vendor master record: purchasing data |
WYT3 | Partner functions |
EINA | Purchasing information record - general data |
EINE | Purchasing information record (purchasing organization data) |
LFEI | Vendor master - preference for import and export |
KNVK | Vendor master - contact person |
Friday, 22 January 2010
Upload Text file to Header or Item Text in Purchase Order
Right click on header text. There you see load local file. Click on that, select txt file location and load it.
OR
Right click on header text. There you see load local file. Click on that, select txt file location and load it.
http://help.sap.com/saphelp_sm32/helpdata/en/d6/0db7f3494511d182b70000e829fbfe/content.htm
Saturday, 19 December 2009
Sunday, 6 December 2009
REQUIREMENTS FOR CONDITIONS
Saturday, 5 December 2009
Friday, 4 December 2009
Sending P.O. By Mail To Vendor
You need to do some configuration for this.
- Goto NACE .
- Select EF and click on OUTPUT TYPES.
- Then select Output Type NEU and click on processing routines .
- In that you have to add a new entry - medium 5 .
- Then you need to assign a program, form routine and form.
- You can use the standard program i.e. SAPFM06P, FORM routine is always ENTRY_NEU and standard MEDRUCK.
- Then in PARTNER FUNCTION you need to add a new entry : medium - 5 and function - VN .
- For subject of the mail goto Mail Title and Texts. In title give PO No. &EKKO-EBELN& .
- Under General data -> Replacement of text symbols give programm as SAPMM06E and Form Routine as
TEXT_SYMBOL_REPLACE .
- Now the subject will be PO No. 1800004202.
- You need to maintain your email id in tcode SU01 and also the vendor's email id.
- Now while creating a new purchase order , change the medium to External Send .
- Then goto Communication Method and select CS01 . ALSO make sure that the Cover Page Text has value PO No. &EKKO-EBELN& .
- Goto tcode ME9F .
- Execute.
- Select the checkbox and click on Output Message.
- You will get a message MAII 00000000000001 generated .
If the BASIS guys have made the necessary configuration for sending mail then the mail will go .
You can see the status in tcode SOST.
If you want to use a z-programm and z-form then you need add the functions used in standard programm SAPFM06P for generating mail in your z-programm.