topic Re: Regarding SD Tables in Application Development and Automation Discussions

Regarding SD Tables

Former Member — Tue, 06 Jun 2006 06:15:36 GMT

HI Friends,

I Know

VBAK

VBAP

LIKP

LIPS

VBRK and

VBRP Tables

But what is the use of

VBFA(Sales document Flow)

VBUK(Header Status)

VBUP(Item Status)

can any body give some examples, do u have any sample code, pls mail to my id vijayalaxmi_madiwala@yahoo.co.uk.

points for sure for good examples....

Thanks in ADvance

Vijaya

Re: Regarding SD Tables

Former Member — Tue, 06 Jun 2006 06:18:50 GMT

just go through this link there are lots of sd related reports example...

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

Re: Regarding SD Tables

Former Member — Tue, 06 Jun 2006 06:22:17 GMT

Hai Vijaya Lakshmi

hai go through the following Link theat will help you

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

KONV Conditions for Transaction Data

KONP Conditions for Items

LIKP Delivery Header Data

LIPS Delivery: Item data

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

VBBE Sales Requirements: Individual Records

VBEH Schedule line history

VBEP Sales Document: Schedule Line Data

VBFA Sales Document Flow

VBLB Sales document: Release order data

VBLK SD Document: Delivery Note Header

VBPA Sales Document: Partner

VBRK Billing: Header Data

VBRP Billing: Item Data

VBUK Sales Document: Header Status and Administrative Data

VBUP Sales Document: Item Status

VEKP Handling Unit - Header Table

VEPO Packing: Handling Unit Item (Contents)

VEPVG Delivery Due Index

Thanks & regards

Sreeni

Re: Regarding SD Tables

Former Member — Tue, 06 Jun 2006 06:25:37 GMT

Hi,

I have mailed you the documents..

Please check and confirm..

Regards,

Tanveer.

<b>Please mark helpful answers</b>

Re: Regarding SD Tables

Former Member — Tue, 06 Jun 2006 06:30:46 GMT

Hi,

VBFA is a sales document flow table where in you can get the invoice no, delivery no, picking no, good issue no by passing an sales order no.

For eg: in VBFA if you pass an order no say eg: 1000011 in the VBELV field you will get the records based on the status of the document. So there are two fields VBTYP_N and VBTYP_V which will tell you whether the document no in the field VBELN is a delivery, invoice or an inquiry etc.

VBUK and VBUP are two tables which gives the status of an particular sales order document no.

Pass the sales order no: 1000011 in VBELN. There are fields like RFGSK, RFSTK, WBSTK,ABSTK and GBSTK which will give you the status of the document like how far it has been processed.

Please mail me if you need some code regarding this.

Lakshminarayanan

Mark all helpful answers for points.

Re: Regarding SD Tables

Former Member — Mon, 12 Jun 2006 15:43:26 GMT

VBUK and VBUP tables are for header and Item status respectively, for e-g Credit status, Delivery status, Billing status etc.

VBFA as said is for the document flow, like it shows us the subsequent and the previous documents and their status.

For e-g, Sales order flow shows us subsequent documents created like Delivery, Invoice and Preceeding documents like quotaion etc. This is mainly useful when cancelling certain documents or the view the status of the subsequent and preceeding docs. Like when we want to delete a sales order, system does not allow us to do so unless the subsequent docs are cancelled or deleted.

Hope this helps

Chandra

Re: Regarding SD Tables

Former Member — Tue, 24 Jul 2007 12:23:27 GMT

Hi,

Sales and Distribution:

Table Description

Customers KNA1 General Data

KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct)

KNB4 Customer Payment History

KNB5 Customer Master – Dunning info

KNBK Customer Master Bank Data

KNKA Customer Master Credit Mgmt.

KNKK Customer Master Credit Control Area Data (credit limits)

KNVV Sales Area Data (terms, order probability)

KNVI Customer Master Tax Indicator

KNVP Partner Function key

KNVD Output type

KNVS Customer Master Ship Data

KLPA Customer/Vendor Link

Sales Documents VBAKUK VBAK + VBUK

VBUK Header Status and Administrative Data

VBAK Sales Document - Header Data

VBKD Sales Document - Business Data

VBUP Item Status

VBAP Sales Document - Item Data

VBPA Partners

VBFA Document Flow

VBEP Sales Document Schedule Line

VBBE Sales Requirements: Individual Records

SD Delivery DocumeLIPS Delivery Document item data, includes referencing PO

LIKP Delivery Document Header data

Billing Document VBRK Billing Document Header

VBRP Billing Document Item

SD Shipping Unit VEKP Shipping Unit Item (Content)

VEPO Shipping Unit Header

Thanks

Hussain