Skip to Content
SAP Cloud for Customer add-ins

Cloud Data Sources - Field Types & Settings for Data Source Fields

Tags:

There are much more to be covered in Cloud Data Sources, if you wish to see the initial document created, please, check Creating Custom Data Sources - Analytics - Cloud for Customer.

In this document, I will cover the data types for Cloud Data Sources and data upload.

  1. Settings for Data Source Fields
    • Each data source field contains certain information that must be maintained, the information is based on the table below:
    • NameDescription
      Primary KeyA primary key is a field or group of fields that uniquely identifies data records in a data source.
      Field IDThe technical ID of the field. Only upper case letters (A, B, … Z), numbers (0, 1, … 9) and the underscore character (_) are allowed.
      Field NameThe semantic name of the field.
      Data TypeSee the Data Types for Cloud Data Source Fields table below.
      LengthDepending on the data type you select, you can define the length of the field.
      Upper Case

      Converts entries in the fields to upper case letters. Note that the field name is not affected.

      If this indicator is set, then the system differentiates between lower and upper case letters. If this indicator is not set, then the system converts all the letters into upper case.

      If you use letters in lower case, then you must be aware of whate happens when you enter a string for a variable defined in a report based on the data source. Specifically, if you use the characteristic in a variable, then the system only can find the values for the characteristic if the lower and upper case letters are entered accurately in the input field for the variable

      Alpha Conversion

      Presets the format of characteristics of the Char data type. Alpha conversion is often used, for example, with account numbers or document numbers.

      If you set this indicator, when converting from an external to an internal format, the system checks if the entry in the input field is numerical or alphanumerical with blank spaces before and/or after the string of digits.

      If the string is numerical, then the string is copied to the output field, right-aligned, and the space on the left is filled with zeros.

      If the string is alphanumerical, then the string is copied to the output field from the left to right and the space to the right remains blank.

      Input and output fields are each 8 characters long.

      Referencing Data SourceData source from which a characteristic is referenced as a key field
      Referencing Data Source Key Field

      Referenced characteristic used as a foreign key. Foreign keys are usually not available for entry, because the value is taken from the referenced characteristic in the data source. This ensure that the characteristic values are consistent.

      Note that the data type and length of the characteristic in the data source and the key field characteristic must match.

      Key for Master DataA key that enables you to add text descriptions to fields that have the Char data type. It also enables the corresponding field to be referenced by other data sources.
      Parent Characteristic for HierarchyArranges the characteritics as a hierarchy, with the characteristic you enter as the parent node of the hierarchy.
  2. Data Types for Cloud Data Source Fields
    • Data Type for Key Figures
    • NameDescription
      Amount

      A monetary sum with a currency unit.

      28 integer places are allowed.

      6 decimal places are allowed.

      If the uploaded value has more that 6 decimal places, then the sixth decimal place value is rounded to the nearest number.

      Quantity

      A definite amount of an item with a unit of measure.

      28 integer places are allowed.

      6 decimal places are allowed.

      If the uploaded value has more that 6 decimal places, then the sixth decimal place value is rounded to the nearest number.

      Integer

      4 byte integer, whole number with +/- sign.

      Only values between -2147483648 and 2147483647 are allowed.

      DateDate field in YYYYMMDD format.
      TimeTime field in HHMMSS format.
      Decimal Number

      Numeric value without a currency unit or unit of measure.

      28 integer places are allowed.

      6 decimal places are allowed.

      If the uploaded value has more that 6 decimal places, then the sixth decimal place value is rounded to the nearest number.

    • Data Type for Characteristics
    • NameDescription
      CharAlphanumerical string with a character length between 1 and 60.
      DateDate field in YYYYMMDD format.
      TimeTime field in HHMMSS format.
      WeekDate field as a calendar week in WW format.
      MonthDate field in MM format.
      QuarterDate field in Q format.
      YearDate field in YYYY format.
      Year MonthDate field in YYYY-MM format.
      Year QuarterDate field in YYYY-Q-# format.
      Year WeekDate field in YYYY-W-# format.

For information on Data Upload for Cloud Data Sources, please, check the document Cloud Data Sources - Data Upload.

For more information on Analytics, please, check Central Document for Analytics Troubleshooting.

No comments