CHARGED_ITEM_FILES

Description


The CHARGED_ITEM_FILES table contains information about the files of charged items, chargeable items, and refill items generated by the rater and bulkloader instances of the SAP CC system during the charging and refilling operations. The back-end database does not include these resulting items because they are stored in data files.

Note

For compatibility reasons, the name of this table remains unchanged even if the files contain other items than charged items.

Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


The CHARGED_ITEM_FILES table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
FILE_NAME          
CREATION_DATE          
INSTANCE_TYPE          
IN_ERROR          
ADD_INFO          

Column Details


FILE_NAME

Definition The name of the file without extension
Type VARCHAR(256), NOT NULL

CREATION_DATE

Definition The date when the file was created
Type TIMESTAMP, NOT NULL

INSTANCE_TYPE

Definition The type of the system instance, which created the file
Format

The possible values are:

  • 0: Rater
  • 1: Bulkloader

Type DECIMAL(1), NOT NULL

IN_ERROR

Definition Specifies if the file is in error
Type DECIMAL(1), NOT NULL
Default 0

ADD_INFO

Definition Additional Information
Type VARCHAR(256), NULL