Appendix: Error Types for Entities

This section lists the different types of errors that are logged in the staging tables for each entity.

Business Partner

For Business Partner records, an error is logged when any of the following validations fail:

Value for PARTY_TYPE or LANGUAGE (SPRAS) is greater than 1 character
Value for STATE, COUNTRY, BANK_COUNTRY, or RISK_CODE is greater than 3 characters
Value for COMPANY_CODE or PAYMENT_TERM is greater than 4 characters
Value for POSTAL_CODE, RECON_ACCOUNT, or BP_TYPE is greater than 10 characters
Value for BP_NUMBER is greater than 20 characters
Value for BP_NAME or CITY is greater than 40 characters
Value for BP_NUMBER, BP_TYPE, BP_NAME, PARTY_TYPE, COMPANY_CODE, RECON_ACCOUNT, STATE, CITY, POSTAL_CODE, or COUNTRY is NULL
POSTAL_CODE contains invalid data format
OVERALL_CREDIT_LIMIT is missing when credit management data is required
RISK_CODE is missing when credit management data is required

For Cost Center records, an error is logged when any of the following validations fail:

Value for LANGUAGE (SPRAS) is greater than 1 character
Value for CONTROLLING_AREA (KOKRS) or COMPANY_CODE (BUKRS) is greater than 3 characters
Value for SHORT_DESCRIPTION (KTEXT) is greater than 20 characters
Value for COST_CENTER_ID (KOSTL) is greater than 10 characters
Value for COST_CENTER_NAME (NAME1) is greater than 35 characters
Value for LONG_DESCRIPTION (LTEXT) is greater than 40 characters
Value for COST_CENTER_ID (KOSTL), CONTROLLING_AREA (KOKRS), COST_CENTER_NAME (NAME1), COMPANY_CODE (BUKRS), VALID_TO_DATE (DATBI), SHORT_DESCRIPTION (KTEXT), LONG_DESCRIPTION (LTEXT), or LANGUAGE (SPRAS) is NULL

For GL Account records, an error is logged when any of the following validations fail:

Value for LANGUAGE (SPRAS) is greater than 1 character
Value for ACCOUNT_GROUP (KTOKS), CHART_OF_ACCOUNTS (KTOPL), COMPANY_CODE (BUKRS), or FIELD_STATUS_GROUP (FSTAG) is greater than 4 characters
Value for CURRENCY_CODE (WAERS) is greater than 5 characters
Value for NATURAL_ACCOUNT (SAKNR) is greater than 10 characters
Value for SHORT_DESCRIPTION (TXT20) is greater than 20 characters
Value for LONG_DESCRIPTION (TXT50) is greater than 50 characters
Value for NATURAL_ACCOUNT (SAKNR), ACCOUNT_GROUP (KTOKS), CHART_OF_ACCOUNTS (KTOPL), SHORT_DESCRIPTION (TXT20), LONG_DESCRIPTION (TXT50), LANGUAGE (SPRAS), COMPANY_CODE (BUKRS), or FIELD_STATUS_GROUP (FSTAG) is NULL

For Internal Order records, an error is logged when any of the following validations fail:

Value for BUSINESS_AREA, COMPANY_CODE, CONTROLLING_AREA, INTERNAL_ORDER_TYPE, or PLANT is greater than 4 characters
Value for PROFIT_CENTER is greater than 10 characters
Value for INTERNAL_ORDER_TYPE, CONTROLLING_AREA, COMPANY_CODE, BUSINESS_AREA, ORDER_NAME, or OBJECT_CLASS is NULL

For Material records, an error is logged when any of the following validations fail:

Value for UNIT_OF_MEASURE, WEIGHT_UOM_CODE, DIMENSION_UOM_CODE, VOLUME_UOM_CODE, or ALT_UNIT_OF_MEASURE is greater than 3 characters
Value for PLANT, SALES_ORGANIZATION, STORAGE_LOCATION, or MATERIAL_TYPE is greater than 4 characters
Value for MATERIAL_NUMBER or MATERIAL_DESCRIPTION is greater than 40 characters
Value for MATERIAL_NUMBER, MATERIAL_DESCRIPTION, MATERIAL_TYPE, or UNIT_OF_MEASURE is NULL

For Profit Center records, an error is logged when any of the following validations fail:

Value for LANGUAGE (SPRAS) is greater than 1 character
Value for COMPANY_CODE (BUKRS) is greater than 3 characters
Value for PROFIT_CENTER_ID (PRCTR) is greater than 10 characters
Value for SHORT_DESCRIPTION (KTEXT) is greater than 20 characters
Value for PROFIT_CENTER_DESC (NAME1) is greater than 35 characters
Value for LONG_DESCRIPTION (LTEXT) is greater than 40 characters
Value for PROFIT_CENTER_ID (PRCTR), PROFIT_CENTER_DESC (NAME1), COMPANY_CODE (BUKRS), SHORT_DESCRIPTION (KTEXT), LONG_DESCRIPTION (LTEXT), or LANGUAGE (SPRAS) is NULL

The 'Status' column in the exception report/error log indicates the current state of each master data record. The possible status values are:

E – Error at CFIN or technical error at CFIN
P – In process (extraction from source completed, currently in staging area and ready to be posted to CFIN)
S – Successfully posted to CFIN
A – Application error at CFIN
I – In process at CFIN