Sales Orders with credit card information

[Former Member]

Hi everybody

I wanted to know if it is possible to find if the sales order has a credit card number on it?

When i go to the Sales order screen, the table-field for credit card# is CCDATA-CCNUM

Now CCDATA is a structure, so if i have a Sales Order number and I want to check if there exists a credit card number on that Sales Order, how should it be found ?

Basically I am trying to modify the billing due list program to list on those Sales Documents which dont have a credit card number on them.

So from the Delivery document, I drill to the Sales Order number & now I dont know which parameter to check which would guarentee the presence of a credit card number for paying the amount on the Sales Order.

Kindly if someone could guide me let me know ASAP

Thanks

Vinit

[former_member202002 · Accepted solution]

Vinit,

The field you are looking for is VBAK-RPLNR. This is the Payment Card Billing Plan number. This field will only ever have a value in it if there is credit card information on the Sales Order.

Field VBAK-RPLNR links to fields FPLA-FPLNR, FPLT-FPLNR and FPLTC-FPLNR. Table FPLTC contains the actual payment card details on the order (or Invoice).

There is a similar field on the Invoice header - VBRK-RPLNR.

Eric Bushman

[Paymetric|https://www.paymetric.com]