Skip to Content
author's profile photo Former Member
Former Member

sales values t-code

I have a query on 0sd_c03 where I am getting data from 2lis_11_vaitm,13_vditm

Now I have created restricted KF’s like incoming order values restricted with credit/debit posting value with D,Doc category with O & KF net values in stat curr

How can I check the values for these with R/3

I want to compare the values in BW & R/3 are correct or not

One more RKF like Returns value restricted with credit/debit posting value with D,Doc category with O & KF net values in stat curr

Billling value restricted with credit/debit posting value with D,Doc category with I & KF net values in stat curr

Where I can find the credit/debit posting values in R/3wen I check in table vbak with doc category oof O then it is showingme no entries avaible but in bw my RKF are restricted KF’s are showing values ,pls guide me where I can check this values

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 30, 2007 at 06:21 AM

    Hi,

    You can do this.

    Just check the debit credit indicator which you are using for restricion is mapped to which field from the extractor(R/3 field).get it's technical name.It is possible that

    description is different in R/3 from BW so it is not possible without knowing the technical name.

    VAITM and VDITM are item level extractors and will be bringing data from VBAP and VBRP tables.

    But the indicators can be present in the header tables also VBAK -header orders and VBRK-header item.

    So if you can give which extractor the filed is coming and the technical name of the field also the key figure you are using for restrcion is coming from which extractor( it's not clear).Then will be able to help you

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi , if you are cheking for a particular customer you can go to transaction:

      list of sales orders: VA05

      List of billing documents:VF05

      you need not go to the tabel to verify your sales and billing value.

      if you want individual document level data go to va03/vf03.

      hope thi shelps

      Ashwin

  • author's profile photo Former Member
    Former Member
    Posted on Mar 30, 2007 at 09:33 AM

    Hi

    You can check this in sales related tables like VBRK VBRP and also look at the trasactions VA0*

    Hope it helps

    Thanks

    Teja

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 10:18 AM

    Hi,

    We have bulk T-codes in R/3 side if it is sales and distribution sales value

    T.codes: Create,Change, Display & Report.

    VA01-Sales order creation

    VA02-Dispaly

    VA03-Change

    *Outright Sales*

    VA01,VA02,VA03,VA05

    VL01N,VL02N,VL03N,VL05N

    VF01,VF02,VF03,VF05

    VA02 (Maintain Line Item for Rejection)

    VL09 & (VL02N-Delete)

    VF11

    *Sales\Returns Sales*

    VA01,VA02,VA03,VA05

    VL01N,VL02N,VL03N,VL05N

    VF01,VF02,VF03,VF05

    VA02 (Maintain Line Item for Rejection)

    VL09 & (VL02N-Delete)

    VF11

    check all t-codes in R/3 it is useful to any business.

    i think it is help to you......if it is useful to assifg points to me

    Regards,

    Lakshmi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 01:39 PM

    HI

    Try to find with the following TCodes

    VA05

    VA03

    in SE16 try to see the data for VBAK abd VBAP tables

    SD Tables

    VBRK: Sales Document : Header Data

    VBAP : Sales Document : Item Data

    LIKP- Delivery Order Header

    LIPS- Delivery Order Line Items

    VEKP- Shipping Unit Header

    VEPO- Shipping Unit Line Items

    EIKP- Foreign Trade: Header

    EIPO- Foreign Trade: Line Items

    VBRK- Billing Header

    VBRP- Billing Line Items

    VBUK- Sale Document Status Header

    VBUP- Sale Document Status Line Items

    VBFA- Document Flow

    VBPA- Sale Document Partner

    KONV- Pricing Condition

    PVINX Index of New Sales Documents for Product Proposal

    T176T Sales Documents: Customer Order Types: Texts

    T661T Difference Tolerances for External and Internal Conditions

    TERRF Erroneous Data for First Data Transfer

    TVDC Delivery Times:Categories

    TVDCT Delivery Times: Texts

    TVRMAVK Repair Procedure: Actions

    TVRMAVT Repair Procedure: Action Texts

    TVSTAT Display/Maintain Status in Sales Overview

    TVVFS Variant Matching Procedure: Procedures

    TVVFT Variant Determination Procedure: Texts

    TVVFZ Variant Matching Procedure: Time Control

    VAKGU Sales Index: Quotation Validity

    VAKPA Sales Index: Orders by Partner Function

    VAPMA Sales Index: Order Items by Material

    VBAG Sales Document: Release Data by Schedule Line in Sch.Agrmt.

    VBAK Sales Document: Header Data

    VBAP Sales Document: Item Data

    VBEH Schedule line history

    VBEP Sales Document: Schedule Line Data

    VBKD Sales Document: Business Data

    VBKFZ Cumulative Quantity Corrections

    VBLB Sales document: Release order data

    VBMUE Sales Document: Characteristic Overview

    VBMUET Sales Document: Characteristic Overview Description

    VBMUEZ Sales Document: Characteristic Overview Assignments

    VBPK Sales Document: Product Proposal Header

    VBPV Sales Document: Product Proposal

    VBREF SD Object Link to Item References

    VBSN Change status relating to scheduling agreements

    VBSP SD Document Item for Models of Material Structures

    VBUV Sales Document: Incompletion Log

    VCRSELA Cross Selling Analysis

    VCRSELA_RES Cross Selling Analysis: Results

    VEDA Contract Data

    VEPVG Delivery Due Index

    VKDFS SD Index: Billing Initiator

    VLPKM Scheduling agreements by customer material

    Regards,

    Chandra

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.