abap general

[Former Member]

SD FLOW

[Former Member]

SD FLOW

[Former Member]

HI,

SALES & DISTRIBUTION MODULE RELATED TABLES:

Cycle:

Inquiry->Quotation->Sales Order->Delivery(Picking, Packing, Post Goods

Issue and Shipment)->Billing-> Data to FI

TABLES and Important Fields:

VBAK: Sales Document(Header Data) (VBELN)

VBAP: Sales Document(Item Data) (VBELN,POSNR,MATNR,ARKTX,CHARG)

Enquiry, Quotation, Sales Order are differentiated based on Doc.

Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A,

for Quotation 'B' & for Order it is 'C'.)

LIKP: Delivery Table (Header Data)(VBELN,LFART,KUNNR,WADAT,INCO1)

LIPS: Delivery Table (Item Data)(VBELN,POSNR,WERKS,LGORT,MATNR,VGBEL)

(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)

VTTK: Shipment Table (Header Data)(TKNUM)

VTTP: Shipment Table (Item Data)( TKNUM,TPNUM,VBELN)

(VTTP-VBELN = LIKP-VBELN)

VTFA: Shipping Document Flow(TKNUM,VBELV,VBELN)

VTPA: Shipping Partners data(VBELN,PARVW,KUNNR,PERNR)

VTTS: Stages in Shipment(TKNUM,TSNUM,TSTYP)

VTSP: Transport Stage/Shipment Item Allocation(TKNUM,TSNUM,TPNUM)

VEKP: Handling Unit: Header(Packing)(VENUM,VSTEL)

VEPO: Handling Unit: Item (Packing)(VENUM,VEPOS,VBELN)

VBRK: Billing Table(Header Data)(VBELN,FKART,BELNR)

VBRP: Billing Table(Item Data)(VBELN,POSNR,FKIMG,NETWR,VGBEL,VGPOS)

(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)

Apart from these tables there are lot of other tables which starts with

‘V’, but we use the following tables frequently.

VBUK: All Sales Documents status & Admn. Data(Header)(VBELN,VBTYP)

VBTYP= ‘C’(Sales Order) VBTYP=’J’(Delivery) VBTYP=’M’(Invoice)

VBUP: Sales Documents status & Admn. Data(Item)(VBELN,POSNR)

VBEP: Sales Doc. Schedule Lines Data(VBELN,POSNR,EDATU,WMENG)

VBKD: To get sales related Business data like Payment terms etc.(VBELN,ZTERM)

VBFA: sales document flow data(VBELV,VBELN,POSNV,VBTYP)

VBPA: Partner functions Data(VBELN,PARVW,KUNNR,LIFNR)

VEDA: Contract Data(VBELN,VPOSN)

VEDAPO: Contract Data(VBELN,VPOSN)

KONA: Rebate Agreements (KNUMA,VKORG,VTWEG,SPART)

VBRL: SD Document: Invoice List(VBELN,POSNR,VBELN_VF,NETWR,KUNAG)

VKDFS: SD Index: Billing Indicator(FKTYP,VBELN,FKART,VKORG)

VBSK: Collective Processing for a Sales Document Header(SAMMG,SMART)

VBSS: Collective Processing: Sales Documents(SAMMG,VBELN,SORTF)

VRKPA: Sales Index: Bills by Partner Functions(VBELN,BELNR,KUNDE,PARVW)

VRPMA: SD Index: Billing Items per Material(MATNR,VBELN,BELNR,KUNNR)

TVLKT: Delivery Type: Texts(LFART,VTEXT)

KNA1: Customer Master-General(KUNNR,NAME1,LAND1)

KNB1: Customer Master(Company Code)(KUNNR,BUKRS,PERNR)

KNC1: Customer Master Data (Transaction Figures)(KUNNR,BUKRS,GJAHR)

KNVK: Customer Master Contact Partner(PARNR,KUNNR,NAME1)

KNVV: Customer Master sales data(KUNNR,VKORG,VTWEG,KDGRP)

KNBK: Customer Bank Details(KUNNR,BANKS,BANKL,BANKN)

KNVH: Customer Hierarchy (HITYP,KUNNR,VKORG,VTWEG,SPART)

KNVP: Customer Master Partner Functions(KUNNR,PARVW,KUNN2)

KNVS: Customer Shipment data(KUNNR,VSTEL,TRANS)

KNVI: Customer Tax data(KUNNR,ALAND,TATYP)

LFA1: Vendor Master-General (LIFNR,NAME1,ORT01)

LFB1: Vendor Master(Company Code)(LIFNR,BUKRS,PERNR)

LFC1: Vendor Master (Transaction Figures)(LIFNR,BUKRS,GJAHR)

MARA: Material Master-General (MATNR,MTART,MATKL)

MARC: Material Master-Plant data(MATNR,WERKS,EKGRP)

MARD: Material Master- St.Location Data(MATNR,WERKS,LGORT,LABST)

EBEW: Sales Order Stock Valuation(MATNR,VBELN,BWKEY,BWTAR)

TVKO: Sales Organizations(VKORG)

TVTW: Distribution Channel(VTWEG)

TSPA: Divisions(SPART)

TVKOV: Distribution Channels for S.Orgn(VKORG,VTWEG)

TVKOS: Divisions for S.Orgn(VKORG,SPART)

TVTA: Sales Areas(VKORG,VTWEG,SPART)

TVBUR: Sales Offices(VKBUR,ADRNR)

TVKBT: Sales Office Texts(VKBUR,SPRAS,BEZEI)

TVKBZ: Sales Office Assign.to Sales Area(VKORG,VTWEG,VKBUR)

TVKGR: Sales Group(VKGRP)

TVGRT: Sales Group Texts(VKGRP,SPRAS,BEZEI)

TVBVK: Sales Group to Sales office(VKBUR,VKGRP)

TVKWZ: Plants Assign.to S.Orgn(WERKS,VKORG)

T171T: Sales District Texts(BZIRK,BZTXT,SPRAS)

TVLA: Loading Points(LSTEL)

TVST: Shipping Points (VSTEL)

TVSWZ: Shipping Point to Plant(VSTEL,WERKS)

TVPT: Item Categories (PSTYV)

TINC: Customer Incoterms(INCO1)

T077D: Customer Account Group (KTOKD)

T001W: Plants (WERKS)

T001L: Storage Locations (LGORT)

T499S: Locations(WERKS,STAND,KTEXT)

TWLAD: To get address of Storage Location and Plant(LGORT,ADRNR)

TVAK: Sales Document (Order) Types (AUART)

TVAU: Sales Documents: Order Reasons (AUGRU)

TVFK: Billing Document Types (FKART)

TVLK: Delivery Types(LFART)

TVSB: Shipping Conditions (VSBED)

TTDS: Transportation Points(TPLST)

TVKT: Account Assignment Groups (KTGRD)

KONV: Condition Types pricing)(KNUMV,KSCHL,KWETR)

ADRC: To get Addresses of Partners(ADDRNUMBER,NAME1)

VBBE: Sales Requirements: Individual records(VBELN,POSNR,MATNR)

VBBS: Sales Requirement totals Record(MATNR,WERKS,LGORT,CHARG)

VBKA: Sales Activities Data(VBELN,KTAAR)

VBPV: Sales Document Product Proposal(VTWEG,MATNR,KUNNR,CHARG)

T682: Access Sequences (KOZGF)

T682T: Access Sequence Texts (KOZGF,VTXTM)

T683: Pricing Procedures (KALSM)

T683T: Pricing Procedures Texts(KALSM,KAPPL,SPRAS,VTEXT)

T685: Pricing Condition Types (KSCHL)

T685T: Condition Type Texts(KSCHL,SPRAS,KAPPL,VTEXT)

KONH: Conditions (Header)(KNUMH,KAPPL,KSCHL)

KONP: Conditions (Item)(KNUMH,KOPOS,KAPPL,KSCHL)

KONV: Conditions (Transaction Data)(KNUMV,KSCHL,KBERT,KWERT)

KOND: Conditions (KNUMD,ZUSKO,KSCHL)

rgds,

bharat.

[Former Member]

check the following thread.

https://forums.sdn.sap.com/click.jspa?searchID=-1&messageID=3000445

Reward points if useful.

[Former Member]

Hi,

SD FLOW

SD Flow Cycle and T Codes:

INQUIRY ( VA11)

|

QUOTATION (VA21)

|

PURCHASE ORDER (ME21)

|

ORDER CONFIRMATION (VA01)

|

PICKING LIST – (VL36)

|

PACKING LIST - (VL02, VL01)

|

SHIPPING – (VT01)

|

INVOICE – (VF21, VF01)

|

AR

Explantion with relavent tables:

Enquiry - Customer enquires about the Products services that were sold by a company - VA11

Quotation - Company Gives a Quotation for the products and Services to a Customer

Sales Order - Customer gives a Purchase order to the company agaionst which a Sales order will be raised to Customer in SAP.

VBAK: Sales Document(Header Data) (VBELN)

VBAP: Sales Document(Item Data) (VBELN,POSNR,MATNR,ARKTX,CHARG)

Enquiry, Quotation, Sales Order are differentiated based on Doc.

Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A,

for Quotation 'B' & for Order it is 'C'.)

Delivery(Picking, Packing, Post Goods Issue and Shipment)->

Company sends the material after picking it from Godown and Packing it in a Handling Unit(box) and Issues the goods

LIKP: Delivery Table (Header Data)(VBELN,LFART,KUNNR,WADAT,INCO1)

LIPS: Delivery Table (Item Data)(VBELN,POSNR,WERKS,LGORT,MATNR,VGBEL)

(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)

Billing - Also company bills to the customer for those deliveries

And in FI against this billing Accounting doc is created.

VBRK: Billing Table(Header Data)(VBELN,FKART,BELNR)

VBRP: Billing Table(Item Data)(VBELN,POSNR,FKIMG,NETWR,VGBEL,VGPOS)

(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)

Apart from these tables there are lot of other tables which starts with

‘V’, but we use the following tables frequently.

Links for sd:

http://www.sapgenie.com/abap/tables_sd.htm

Please check this SD online documents.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAARCSD/CAARCSD.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_SD.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCBMTWFMSD/BCBMTWFMSD.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLISPLN/LOLISPLN.pdf

Also please check this SD links as well.

http://help.sap.com/saphelp_47x200/helpdata/en/92/df293581dc1f79e10000009b38f889/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/dd/55f33e545a11d1a7020000e829fd11/frameset.htm

http://www.sap-basis-abap.com/sapsd.htm

http://www.sap-img.com/sap-sd.htm

http://www.sapgenie.com/abap/tables_sd.htm

http://searchsap.techtarget.com/featuredTopic/0,290042,sid21_gci961718,00.html

http://www.sapbrain.com/TUTORIALS/FUNCTIONAL/SD_tutorial.html

All help ebooks are in PDF format here

http://www.easymarketplace.de/online-pdfs.php

[Former Member]

hi,

check this link......

For SD:

http://www.sap-img.com/sap-sd/important-tables-for-sap-sd.htm

regds,

paras

[Former Member]

hai anil

SD flow

enquiery [va11]

quatations [va22]

sales order [va01]

billing/delevery [vl01]

invoice [vf01]

vendor payment.