cancel
Showing results for 
Search instead for 
Did you mean: 

Shipping amount and remit to address on receivable invoice

Former Member
0 Kudos

Hello experts,

I'm developing a report that will display receivable invoice details, and as of now I've been able to map most of the fields needed. However I'm struggling with some fields, these fields are:

Shipping amount                      VTTK-TNDR_ACTP or VFKP-NETWR + VFKP-MWSBP   ??

Remit to Address information     I don't know where to find this

Tax Date                                  BSET-TXDAT (I have to tie the billing doc back to the acct. doc to get this value) ??

Unit Price                                 VBRP-NETWR / VBRP-FKIMG ?? (This is at the line item level)

Subtotal                                   VBRP-NETWR ?? (my only issue here is that this amount includes everything but the sales taxes, so not sure if it is an                                                                                actual subtotal)

I have looked around and done my research and I have come across some fields that might or might not be the correct fields, I have noted them in RED on top. I'll appreciate if you guys could point me into the right direction.

Thanks!

Carlos

Accepted Solutions (1)

Accepted Solutions (1)

former_member184701
Active Contributor
0 Kudos

shipping amount - talk to user

remit to address - look at table VBPA - that must be your sales partner VBPA-KUNNR (focus on VBPA-PARVW role)

tax date - probably matches invoice date VBRK-FKDAT or shipment date VTTK-ERDAT

unit price - may be KONV, KONP with field KBETR and for subtotals...

good luck

Answers (3)

Answers (3)

Jelena
Active Contributor
0 Kudos

PPIO beat me to it, but I was going to suggest the same - ask the business users. If you still have an FI person they might know too. We've been without an SD person for over a year, so I feel your pain.

'Remit to' address is usually the address where the customers need to send their payments. For some of our companies we store it as a standard text (SO10), for others it's the Sales Org address or Lockbox address. It could also be a wire account #, etc. Ask AR department, they should know.

former_member184701
Active Contributor
0 Kudos

Carlos,

if you have trouble talking to your SD functional guy

talk to the relevant user asking him/her to explain where you can see all required information on screens and how to calculate amounts, say, subtotals. Work with user on some existing documents understanding the requirements.

Sometimes user's finger is very useful

Former Member
0 Kudos

Anyone?

Jelena
Active Contributor
0 Kudos

Carlos, the definition for these fields may vary for every company, so posting this on SCN naturally might not generate lots of replies.

If you're an ABAPer then this should actually be explained in the functional spec by an SD specialist.

Again, just by the field name I wouldn't know how it's defined in your organization, so just my best guess:

Shipping amount - no idea (would it be different from the invoice amount?)

Remit-to - SOrg or Company address? Ask your FI person.

Tax Date - technically there is no such date in billing document. Taxes are determined based on the date specified in the configuration (in most cases it's Pricing date)

Unit price - this may vary greatly. In a simplest case just divide VBRP-NETWR by quantity

Subtotal - take a look at VBRP-KZWI1...6 fields. An SD person should know this.

Former Member
0 Kudos

Thanks for your response Jelena,

I understand the ambiguity of my question, but wanted to try anyways since our SD specialist left the company a couple of weeks ago and we haven't been able to find his replacement yet. So right now I'm developing this report with an incomplete functional spec....it's not the ideal situation but it happens.

Thanks again,

Carlos