Credit card authorization amount

[YogiKalra]

Hi,

Are there any tables in SAP that hold the credit card authorized amount in relation to the order? We need to pull these amounts in the open order report.

TIA

Yogesh

[YogiKalra]

Posting the answer I found by researching:

SAP stores this information in a table FPLTC for this authorized amount (field AUTWR) – it is linked to a billing plan number (field FPLNR). The connection between this BP and the sales order can be made in the table FPLA. The sales order value is in the order header table VBAK. The programmer can easily get both these amounts and put them in the report (either as individual amounts or only the difference by calculating it).