Content Repository configuration

Content repository configuration for database table as storage.

Prerequisites :

Authorization for SICF, OAAD, OANR, OAC0 , OAC2,

1. Solutions :

Create Number Range

a) A number range must be created for SAP Archive Link.

Transaction code: OANR

b) For this process, additional authorisation is required for S_NUMBER = 03 ARCHIVELNK.

In ‘Intervals’, create number range 01 from 0000000001 to 9999999999 without the external number flag.

This is likely to already exist.

c) Assign Documents Class

Document type HRICOLFOTO must exist with document class JPG. Transaction code: OAC2 Table TOAVE

d) Document type settings

Document type HRICOLFOTO must be linked to object type PREL and Infotype 0002. Transaction code: SM31 Table V_T585O (View)

e) Set all three columns here to minuses and don't put a flag in the check box.

f) Content Repository

Create a content repository with storage type FILE archive.

g) Transaction code OAC0

IMG: Basis Components --> Basis Services --> SAP Archive Link --> Basic Settings --> Maintain content repositories Swap from display to amend. Select a current entry and ‘copy’ or just hit ‘create’. Then select . Then fill in the details as below:

h) Choose a two character name – can use Zx (where x is a number) if you wish to use the customer namespace

i) Choose the relevant description

j) Set DocArea to be ‘Archive Link’

k) Storage type – set to R/3 Database

l) Protocol – leave blank

m) Choose Version no. 0046 (or the latest one that is available)

n) Contents table – set this to SDOKCONT1

o) Basic Path – c:\ (this should be set to where the photos are all held)

p) Archive Path – c:\ (this is the area from where the photos are retrieved)

q) Output Device – can leave blank

r) Enter the path name where the photos are to be loaded from. Note this is for loading only. When the photos are linked into the sap system (see later), actually, SAP takes a ‘copy’ and stores it elsewhere. The path may only need to be entered to ‘Arch.path’, but entering to all three doesn’t seem to hurt.

s) Maintain the required Basis Service

Transaction code: SICF Here you activate the Content Server Interface.

t) First you need to create a user profile – with sufficient authorisations to carry out the processes which are done by the system in the background. Ideally this should be a background user for a notional/dummy user. You can use your own user ID after which SAP will warn you that this is a dialogue user account. If you do use your own user ID, change it as soon as you have tested the config. Once you have finished the project, the chances are that your user account will be deleted from the system which will subsequently stop this service from working.

u) We don’t have content server in our landscape so , we want storage for content server in database table. For this we have to create an externel aliases of content server service. We can follow sap note # 685521

v) Run tcode SICF and execute with service hierarchy.

w) Click on external aliases and create an aliases for content sever service

•  Select "default_host".

•  Select Create.

•  External alias: /sap/bc/contentserver

•  Description: HTTP Content Server interface

•  Fill anonymous logon data.

•  Select the target element /default_host/sap/bc/contentserver.

•  Save your entries.

x) Double-click on “content server” in the left hand tree structure. You can find it under default_host --> sap --> bc --> content server

y) Once you have done this click on the refresh icon and make sure that the service is activated. If it is activated, the writing should be in bold (as opposed to greyed out)

Check which content repository (Archive) is linked to document type HRICOLFOTO in object type PREL

z) Transaction code: OAC3 Table TOAOM_C

aa) Set the ‘Content Repository’ field to the one you set up in the step above. Note the Ret.per. field is the retention period for the photo in MONTHS. (so the default is 833 years and 3 months!)

Link photo to personnel number

bb) Transaction code OAAD Click on the Create – Store and Assign button. Enter Business Object PREL and Document Type HRICOLFOTO. Click on create(F8). Enter the Personnel Number of the employee you want to link the photo to. Choose also the infotype that you wish the photo to be displayed on (not sure how relevant this is. It works if you use 0002 but should also work if left blank. Suspect is only relevant if you wanted to store different photos for different infotypes) Click on Continue. Enter the path and filename of the photo. The dropdown will allow you to navigate to the appropriate directory. SAP will notify that the Stored document is created successfully and you end up with something like:

cc) If you get an error 401 to do with missing authorisations, then try and redo the above step. It often only happens the first time you try and load the photo.

Displaying Photos

dd) You can display your linked photo’s straight away if you want, from any Infotype, by selecting the employee in Display or Maintain Data and selecting Menu item ‘Extras’, display all facsimilies: However, this will open a new application (eg ‘Paint’) and load the picture into it. This is a bit cumbersome. It’s much more likely that you really want the picture to appear ‘nicely’ in the header of the appropriate infotype.

#ContentRepositoryconfiguration #SAPContentRepositoryconfiguration #Contentrepositoryconfigurationfordatabasetabl #sapContentrepository