Get the payment card type attached for sales order

[Former Member]

Hi,

How to get payment card type(CCINS) attached like 'VISA', 'AMEX' etc., that is attached to sales order(VBELN).

my requirement is I need to exclude sales orders where the payment is done thru credit cards means exclude prepaid orders.

Thanks

[Former Member]

any answer to this post is appreciated?

[brad_bohn]

I haven't worked with order-related cc data in a long time, so I don't remember if there's any order specific storage of CCINS. However, TVCTD stores the information for payment card config of the credit card number ranges. There is also the CCARD_CHECK* functions for specific number checking and VCNUM which is the credit card master and stores the type. How you access the VCNUM table depends on whether or not you're using the SAPCryptoLib.

[Former Member]

How to link this table with specific sales order number for payment card type attached to that sales order?

[brad_bohn]

I would suggest that you review the code, either by debugging or trace analysis, to determine relationships and data retrieval. This is how experienced devlopers do it.

[Former Member]

HI,

Use this relationship:

 

select single rplnr from vbak into v_rplnr where vbeln = <SO Number>.
if sy-subrc = 0.
select single ccins from fpltc into v_ccins where fplnr = v_rplnr.
endif.

Hope it helps..

Cheers,

Vikram