on 04-22-2014 3:54 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Anyone?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.