SAP Query

[Former Member]

Hi Gurus,

I have to create a SAP query, using VBRK and VBRP tables. I need to add company code (1000,1050) posting period and fiscal year to the same report.

I tried

VBRK-GJAHR ( for Fiscal Year)

VBRK - POPER ( for Posting Periods)

VBRK - BUKRS (for company code)

But i am not getting the output data ( No Data Found).

Can you please let me know how to proceed.

Will assign good points.

Thanks for your help

[Former Member]

answered

[Former Member]

Hi Guru

I tired with the below input fileds:

Selection Field

VKRK-VKORG

VBRK-ERDAT

List Fields

VBRK-VBELN

VBRK-TAXK1

VBRK-ERDAT

VBRK-KUNAG

VBRP-NETWR

VBRP-MATNR

VBRP-ARKTX

VBRP-TAXM1

VBRP-MWSB

The report should contain the following fileds

Customer Code

Customer Name

Billing Document No

Billing Document Date

Tax code in customer master

Material Code

Material Description

Tax code in material master

Document net value

Currency

Tax amount

Posting Date

Fiscal Year

Company code

Billing Type ( Credit memo/Invoice)

When i execute with my input fields the following are missing

Company Code not text, Posting Date, Fiscal Year, Billing Type and Customer Code not text.

What i should do the get the output as per the request.

I will assign good points.

[Former Member]

The report should contain the following fileds

Customer Code

Customer Name

Billing Document No

Billing Document Date

Tax code in customer master

Material Code

Material Description

Tax code in material master

Document net value

Currency

Tax amount

Posting Date

Fiscal Year

Company code

Billing Type ( Credit memo/Invoice)

Thanks

[Former Member]

Hi Prasanth,

I think you need to add more tables to draw this report.

Ex:- KNA1, MARA..etc.

Could you tell me the input fields & output fileds of a query

Best Regards

Ashish Jain

[Former Member]

Hi Prashant,

what data exatly you want to download from sap query.

Best Regards

Ashsih Jain