problem with credit card transaction data upload

[former_member420959]

helllo all,

I am trying to upload credit card transaction data from transaction prcc_vcf4. In the development it was successful without any errors

When iam trying to upload it in quality is giving lot of errors like.

1) unable to determine credit card category

2) Infotype '0001' for 20130617 does not exist for pers. no. 00000000

3) Infotype 0105 could not be found

4) No entry in table V_T702B for argument  VI OTHERS....

5) No entry in table T702O for argument  US

6) Trip currency  must match currency USD of total amount

etc....if its configuration problem can anyone tell where exactly to check

Thanks

ujwal

[former_member420959]

helllo all,

I am trying to upload credit card transaction data from transaction prcc_vcf4. In the development it was successful without any errors

When iam trying to upload it in quality is giving lot of errors like.

1) unable to determine credit card category

2) Infotype '0001' for 20130617 does not exist for pers. no. 00000000

3) Infotype 0105 could not be found

4) No entry in table V_T702B for argument  VI OTHERS....

5) No entry in table T702O for argument  US

6) Trip currency  must match currency USD of total amount

etc....if its configuration problem can anyone tell where exactly to check

Thanks

ujwal

[former_member188827]

check your file. I think a blank line is being appended in your internal table through file. After reading file into internal table, debug and check if any blank line is being appended. If so, delete the blank line from file or write code to delete blank line of internal table.

Regards

[former_member420959]

hi ,

i check the entries in the itab. but no blank lines are appended.

the same entries are populating into itab in development and quality

Thanks for reply

[former_member188827]

Do you see any entry in internal table with blank employee code?

Regards

[former_member420959]

do you know sap table where data for credit card number is stored for an employee

[former_member188827]

check infotype "0105" (Table PA0105) subtype "0011" in PA30.

Regards

[Former Member]

Out of curiosity, when you receive those files from your issuing bank are the credit card numbers encrypted or secured in any way?  How do you encrypt or secure them once you read the files into SAP?

[former_member420959]

hi eric i am usig the standard tcode prcc_vcf4 for upload. the credit card numbers are not encrypted in the file.

Actually the problem i found after debugging the tcode is:

all the account numbers are not fetching in quality but in development they are.

i found that they are getting exported from PCL1 cluster table which has only one record in quality but more than 200 in dev.

if you see the tcode program in line 1576 there is a method call in which there is a itab which is filled from this cluster by export.

I told the same to functional but they told all the account numbers are same in pa0105 table in both the systems. and asked for more details.

Please Help

Ujwal

[Former Member]

Hi Ujwal,

Just SE16 the PA0105 data in both systems and check the number of entries.

BR.

[former_member420959]

hi ankit,

yes there are same no of entries in pa0105 in both dev and qas.

I need to know where the itab gt_db_card_account is getting filled. in this particular itab all are not getting filled as mush as in dev.

Please can any one check the program and let me know.

Thanks

ujwa

[former_member420959]

hiii,

there is an import statement as below

  IMPORT cardholder   TO gt_cardholder

         card_account TO gt_db_card_account

         FROM DATABASE pcl1(tv) ID gs_vcf4_cluster_key.

where data is coming to itab in dev but no data is coming in qas.

I need worked on cluster tables and did not understand the data in pcl1 cluster table.

Can anyone explain what exaclty the statement means and and what tables to see in table cluster pcl1.

Please help

Ujwal

[Former Member]

Sorry Ujwal, I'm not very familiar with the t-code.  It looks like there are others who are better qualified to provide you help.

I was more curious how, if at all, the credit card numbers in the files are being secured.  I've had a number of companies who use this functionality contact me and express concern over the fact that the banks forward them files (via secure SFTP usually) with RAW card numbers.  The SAP customers would prefer the card numbers to be encrypted or tokenized within the files before the files are received in their networks.

Is this something you have considered at all?  Is it considered a priority to address security and PCI concerns?

[Former Member]

Hi,

Have a question for my knowledge - Can there be a possibility that Check tables data is diff in DEV, QAS and PRD? Seems the case here.

BR.

[Former Member]

Hello Ujwal,

I'm running into the same situation. I have maintained the entries correctly in Configuration.

Personnel No. Mainteained in PA0105

Infotype: 0011 maintained correctly with the Credit Card No.

Trip Currency = USD same as the credit card transaction "840 - USD"

V_T702B - maintained Others....to Expense Type "MISC". Checked the "Paid by Company" Indicator

When I try to debug, I don't know how it is trying to get the Personnel No. 00000000

Can you please share any details that could help resolve this issue? Were you able to import the credit card transactions into SAP?

Thanks

Chetan

[Former Member]

Hi chetan babu unni

I am getting a error like below,

Trip currency IDR must match currency AUD of total amount

Message no. 56603

what exactly i need to do under V_T005 table ?

please help me its urgent issue..

[Former Member]

Dear all, I've seen this problem encounted in a few forums, so thought I'd answer once for all.

When a Card / Card Holder record is activated, they will be included in the next load file with a type '3' and '4' record to denoted that it is a "Create" event.

This will write the card holder/card infomation to cluster table PCL1. When transactions (record type 5) are being processed as part of a file upload this table is checked against each card referenced in the transaction record to ensure it has been previously created.

So, long story short, if a file is loading with these errors changes are you've never loaded a file with a 3/4 record for this card.

This can be a problem when testing in DEV, TEST etc when using same/similar transaction files for testing.

In the case of cutover/system migration into Production (and for example migrating from a non-VCF4 format to VCF4) it is imperative that on the initial file VISA include all card-holders as create events (i.e. all cardholder are denoted as new even if the card has been active for some time) otherwise the checks when processing transactions will throw up these kind of errors.

Cheers,

Mike.