SAP TABLES

/1CN/CTXSAPD0002 SAP Country/Order/Product Usage Table and data







/1CN/CTXSAPD0002 is a standard SAP Table which is used to store Country/Order/Product Usage data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP /1CN/CTXSAPD0002 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Cannot Be Enhanced
See here for more information about this and other SAP enhancement categories


SAP /1CN/CTXSAPD0002 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
CLIENTMANDTCLNT3
*
Client
.INCLUDE/SAPCND/TEMPLATE_TABL_KEY Key for Condition Tables
VARNUMH/SAPCND/COND_TABLE_ENTRY_IDRAW16 /SAPCND/CONDINDXCondition Record ID
COUNTRY_TXTTET_COUNTRYCHAR2
*
Country
ORG_ORTTET_ORG_ORCHAR32 Order
USAGE_STTTET_USAGENUMC3
*
Product Usage Indicator
.INCLUDE/SAPCND/TEMPLATE_TABL General Reference for Condition Tables
KSCHL/SAPCND/COND_TYPECHAR4
*
Condition Type
OBJECT_ID/SAPCND/OBJECT_IDRAW16 Higher-level object number for condition records
TIMESTAMP_TO/SAPCND/TIMESTAMP_TOCHAR14 Timestamp for Validity End Date
RELEASE_STATUS/SAPCND/RELEASE_STATUSCHAR1 Release Status
TIMESTAMP_FROM/SAPCND/TIMESTAMP_FROMCHAR14 Timestamp for Validity Start Date
KSCHL_SUPP/SAPCND/SUPP_COND_TYPECHAR4
*
Supplementary Condition Type
COND_GROUP_ID/SAPCND/COND_GROUP_IDRAW16 ID of Group of Condition Records
MAINT_STATUS/SAPCND/MAINT_STATUSCHAR2 Editing status
.INCLUDE/SAPCND/USER_LOG User Spec. Management Data (created, changed)
CREATED_BY/SAPCND/CREATED_BYCHAR12
*
Name of User that Created the Condition Record
CREATED_ON/SAPCND/CREATED_ONDATS8 Date on which Condition Record was Created
.INCLUDE/SAPCND/TEMPLATE_SUPP_KEY General Reference for Additional Information
KOPOS/SAPCND/SUPP_CONDITION_IDNUMC3 Condition Supplement ID
SUPP_EXIST/SAPCND/SUPP_EXISTCHAR1 Additional Data Indicator for Condition Record
SCALE_DIM/SAPCND/DIMENSION_IDNUMC2 Dimenstion number
KBETRPRCT_COND_RATECURR15(2) Condition Rate
KPEINPRCT_COND_PRICING_UNITDEC5 Condition Pricing Unit
KMEINPRCT_PROD_UOMUNIT3
*
Unit of Measure for Product-Specific QuantityCUNIT
KONWAPRCT_COND_CURRCUKY5
*
Condition Currency
KRECHPRCT_CALCULATION_TYPECHAR3
*
Calculation Type for Condition
TAXTYPTTET_TAX_TYPCHAR4
*
Tax Type
TAXRATEID_NONDDTTET_TAX_RATE_ID_NDDCHAR4
*
Tax Rate ID for Non-Deductibility
DEDREASTTET_DEDUCTIBILITY_REASONNUMC3
*
Deductibility Reason
POSTING_INDTTET_POSTINGINDNUMC2
*
Posting Indicator for Non-Deductible Taxes



Key field
Non-key field