Where customer credit worthyness is stored?

[Former Member]

Hi friends,

can u plz tell me where (in which database table) cuistomer credit limit is stored and what credit worthyness he is used against his cr limit means credit bills which r pending for receivables?

Any answer is highly appreciated.

regards,

sd

[Former Member · Accepted solution]

Hi,

Go to FD32 tcode and enter your customer and you will be able to view the detaisl.

Table to view the Credit Limit:

Program name SAPMF02C

Screen number 0210

Program name SAPMF02C

Status 210V

Transparent tabl KNKK

Field name KLIMK

Data element KLIMK

DE supplement 0

Screen field KNKK-KLIMK

Table to view the used Credit Limit:

Program name SAPMF02C

Screen number 0210

Program name SAPMF02C

Status 210V

Struct. RF02L

Field name KLPRZ

Data element KLPRZ_F02L

DE supplement 0

Screen field RF02L-KLPRZ

Regards

[Former Member · Accepted solution]

Hi SAP2020,

thanks for ur answer, i will give appreciation.

one more question,

can u please tell me where the sales area for the customer is stored, means if we enter a customer in sales order, system checks whether the entered customer is eligible for the given sales area (in the initial screen of VA01) or not.

regards,

sd

[Former Member · Accepted solution]

Hi,

During your creation of customer master (through XD01 tcode) you provide the details like Company code, Sales Area.

So when you create the sales order, in the initial screnn once you type your customer and press enter, it lists all the sales area created for the customer.

Regards

[Former Member · Accepted solution]

Hi,

The sales area will be stored in TVTA ( for Exterprise structure)

For the customer master , it is stored in KNVV table.

Please check these two table

regards,

santosh

[Former Member · Accepted solution]

thank u sir

[Former Member]

Hi,

The credit limit for the customer are stored in

KNKK & KNKA

Please check these two tables and revert.

regards,

santosh