SD question

[Former Member]

what is the difference between vbak and xvbak.

what is the main transaction that is populating this tables.

what is meaning for the following sentence consider the bracket as the sentence

not as an alternate meaning

<u>

" For each customer linked to the Credit Account (including the Credit Account)

where ..........."</u>

In this what is meaning for Credit Account which is inside and outside the bracket.

Many Thx & Regards

kiran

[former_member188685]

Hi Kiran,

VBAK is the database table

but where as XVBAK is the internal table which is to hold the values at runtime.

VA01/VA02/VA03 transactions...

Regards

Vijay

[Former Member]

hi see this tables kiran......

Scheduling agreement with external service agent:KNKK,KNMT,KNKA,VBEP

Contract : KNKK,KNMT,KNKA,s116.

scheduling agreement:KNKK,KNMT,KNKA,VBEP

shipping VTTK,VTTP,VTTS,VTPA

delivery LIKP,LIPS

inquiry:KNA1,KNB1,KNVV,KNVS

quotation:KNB1,KNA1,KNVV,VBAK

order:VBAK,VBAP,VBUK,VBUP,VBEP,VBPA.

item proposal:

purchase order:EKKO,EKPO,EINA,EINE

review the points if it is usefull

[Former Member]

VBAK is a DB table and XVBAK is the work area which is populated in order to update/ retrieve VBAK from VA01/VA02/VA03.

Credit account: Each customer can be assigned to a credit account KNKK-KNKLI which can be checked in FD32. Depends on how it is configured. it can be one to one or many to one as partner functions also can be set to the credit account. So you can check table KNKK for all the customers linked to the credit account as well as the Credit account(customer) linked to another credit account .

[Former Member]

hi Kshamatha Eda,

i think u r close to what i required from your sentence.

Can you please elborate this?<u> customers linked to the credit account as well as the Credit account(customer) linked to another credit account</u>

or other wise can you please see this 2 points and reply me

1)If there is a value in KNKK-SSOBL, the customer has non-cash security instruments posted in the general ledger using a special GL indicator. Each line item must be checked to determine whether the security instrument is still valid (expiration date in the future). Currency conversion may also be required.

For each customer linked to the Credit Account (including the Credit Account) where KUNNR does not begin with ‘00T’, select all open line items where BSID-HKONT = the alternate reconciliation account (TBD) for customer security postings

2)If any customer accounts linked to the Credit Account have a KUNNR that starts with ‘00T’, the customer may have a security fund balance that should be used to reduce total exposure used for the credit limit check.

Select all security fund contracts for all linked ‘00T’ customer accounts from table VDARL using product type (VDARL-GSART = S01) and the main borrower customer (VDARL-HDN_KUNNR). [ in this who is main customer-whether the customer iam getting from subroutine call but explain me full 2 point also]

====================================

please give me how to write the code for this. 2.

==================================

hi all how to give my points for the answers i got.

Regards

kiran

Vijay Babu Dudla

Posts: 8,863

Questions: 15

Registered: 3/29/05

Forum points: 10,916

Solved problem (10)

Very helpful answer (6)

Helpful answer (2)

Re: SD question

Posted: Nov 14, 2006 3:57 PM in response to: kiran kumar Reply E-mail this post

Hi Kiran,

VBAK is the database table

but where as XVBAK is the internal table which is to hold the values at runtime.

VA01/VA02/VA03 transactions...

Regards

Vijay

Srikanth Murako...

Posts: 61

Questions: 2

Registered: 10/10/06

Forum points: 32

Solved problem (10)

Very helpful answer (6)

Helpful answer (2)

Re: SD question

Posted: Nov 14, 2006 4:01 PM in response to: kiran kumar Reply E-mail this post

hi see this tables kiran......

Scheduling agreement with external service agent:KNKK,KNMT,KNKA,VBEP

Contract : KNKK,KNMT,KNKA,s116.

scheduling agreement:KNKK,KNMT,KNKA,VBEP

shipping VTTK,VTTP,VTTS,VTPA

delivery LIKP,LIPS

inquiry:KNA1,KNB1,KNVV,KNVS

quotation:KNB1,KNA1,KNVV,VBAK

order:VBAK,VBAP,VBUK,VBUP,VBEP,VBPA.

item proposal:

purchase order:EKKO,EKPO,EINA,EINE

[Former Member]

i am really not sure about the requirement as this depends on how the system is set by or how and why the data was populated for a company. But here is what i think do check with your SD/FI functional person

1) If the knkk-ssobl is there then check KNB4 for payment history to check for non cash with date > sy-datum for validity.

each customer -> credit account which is itself a customer number(knkk-knkli)

2) VDARL-HDN_KUNNR could be the CREDIT ACCOUNT from KNKK as this is the main customer account to which the customers are linked

to.

regarding points when you log on to SDN and follow ur question you can see on the left hand side if the ans is helpful, very helpful or solved. You can check against each persons ans.