Uploading to the ACLOB table.

SUGGESTED

Hi,

I was wondering of anyone has experience of uploading to the ACLOB table.  We want to utilise the comments section in GESBPC and GESBPR for uploading Special Instructions on GESBPR and uploading Historical Sales Ledger / Credit Control comments to GESBPC.

I can see that these attach themselves via the ACLOB table, and then differentiated by CO_BPC and CO_BPR in the CODBLB_0 field.

Has anyone ever used this approach or something similair in terms of templates etc?

Version 12 - Patch 18

Many Thanks

  • 0
    SUGGESTED

    Hi Craig, Text (so Clob) are managed in the standard template by using field prefixe with * + number. For instance BPC import template allows you to enter Order text using the field *71 and *72. The invoice text can be imported using *81 and *82.

    Are you trying to upload the standard Clob text ? If yes, just use the standard import template. 

    Here is the extract of the Online help about the BPC import template:
    "

    Import of plain texts into the customer file (BPCUSTOMER table)

    A "command text" and an "invoice text" may be imported into the template, using the global variable GIMP (by defining the areas *71...).

    • GIMP(71..78) is used to import a text that will be printed on the acknowledgments sent to the customer. It is possible to import a text of 8*100 characters i.e. 800 characters.
    • GIMP(81..88) is used to import a text that will be printed on the invoices sent to the customer.

    "

  • 0 in reply to Julien Patureau

    Julien,

    Thats great, many thanks for the reply, I shall give that a go and let you know the results.

    Many Thanks