SAP A137 table - Price per Country/Region details in SAP

SAP A137 table summary

Object Name: A137
Dictionary Type: Transparent table
Description: Price per Country/Region

Field list for A137 table

Details

A137-MANDT - Client ▼

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
Length (Dec): 000003 (000000)
Check Table: T000
Conversion Routine:
Domain Name: MANDT
Memory ID:
App Class: SAP
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	MANDT
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0001
Identifies a key field of a table	X
Flag: Field is required (not blank)
Data element (semantic domain)	MANDT
Check table name of the foreign key	T000
Nesting depth for includes	0
ABAP data type (C,D,N,...)	C
Internal Length in Bytes	000006
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	CLNT
Length (No. of Characters)	000003
Number of Decimal Places	000000
Domain name	MANDT
Origin of an Input Help	P
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID
Application class for DD objects (not used)	SAP
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Client
Output Length	000003
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table	T000
Conversion Routine
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field MANDT

A137-KAPPL - Application ▼

Description: Application
Field Name: KAPPL
Data Element: KAPPL
Data Type: CHAR
Length (Dec): 000002 (000000)
Check Table: T681A
Conversion Routine:
Domain Name: KAPPL
Memory ID: KAP
App Class: VF
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	KAPPL
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0002
Identifies a key field of a table	X
Flag: Field is required (not blank)
Data element (semantic domain)	KAPPL
Check table name of the foreign key	T681A
Nesting depth for includes	0
ABAP data type (C,D,N,...)	C
Internal Length in Bytes	000004
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	CHAR
Length (No. of Characters)	000002
Number of Decimal Places	000000
Domain name	KAPPL
Origin of an Input Help	P
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID	KAP
Application class for DD objects (not used)	VF
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Application
Output Length	000002
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table	T681A
Conversion Routine
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field KAPPL

A137-KSCHL - Condition Type ▼

Description: Condition Type
Field Name: KSCHL
Data Element: KSCHA
Data Type: CHAR
Length (Dec): 000004 (000000)
Check Table: T685
Conversion Routine:
Domain Name: KSCHL
Memory ID: VKS
App Class: VF
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	KSCHL
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0003
Identifies a key field of a table	X
Flag: Field is required (not blank)
Data element (semantic domain)	KSCHA
Check table name of the foreign key	T685
Nesting depth for includes	0
ABAP data type (C,D,N,...)	C
Internal Length in Bytes	000008
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	CHAR
Length (No. of Characters)	000004
Number of Decimal Places	000000
Domain name	KSCHL
Origin of an Input Help	P
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID	VKS
Application class for DD objects (not used)	VF
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Condition Type
Output Length	000004
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table	T685
Conversion Routine
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field KSCHL

A137-KOKRS - Controlling Area ▼

Description: Controlling Area
Field Name: KOKRS
Data Element: KOKRS
Data Type: CHAR
Length (Dec): 000004 (000000)
Check Table: TKA01
Conversion Routine:
Domain Name: CACCD
Memory ID: CAC
App Class: KS
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	KOKRS
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0004
Identifies a key field of a table	X
Flag: Field is required (not blank)
Data element (semantic domain)	KOKRS
Check table name of the foreign key	TKA01
Nesting depth for includes	0
ABAP data type (C,D,N,...)	C
Internal Length in Bytes	000008
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	CHAR
Length (No. of Characters)	000004
Number of Decimal Places	000000
Domain name	CACCD
Origin of an Input Help	P
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID	CAC
Application class for DD objects (not used)	KS
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Controlling Area
Output Length	000004
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table	TKA01
Conversion Routine
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field KOKRS

A137-VERSN - Version ▼

Description: Version
Field Name: VERSN
Data Element: VERSN
Data Type: CHAR
Length (Dec): 000003 (000000)
Check Table: TKVS
Conversion Routine: ALPHA
Domain Name: COVERSI
Memory ID: KVS
App Class: KE
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	VERSN
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0005
Identifies a key field of a table	X
Flag: Field is required (not blank)
Data element (semantic domain)	VERSN
Check table name of the foreign key	TKVS
Nesting depth for includes	0
ABAP data type (C,D,N,...)	C
Internal Length in Bytes	000006
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	CHAR
Length (No. of Characters)	000003
Number of Decimal Places	000000
Domain name	COVERSI
Origin of an Input Help	P
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID	KVS
Application class for DD objects (not used)	KE
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Version
Output Length	000003
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table	TKVS
Conversion Routine	ALPHA
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field VERSN

A137-RESRC - Resource ▼

Description: Resource
Field Name: RESRC
Data Element: CO_RESSOURCE
Data Type: CHAR
Length (Dec): 000010 (000000)
Check Table: CSKR
Conversion Routine: ALPHA
Domain Name: CO_RESSOURCE
Memory ID: RCE
App Class: KA
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	RESRC
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0006
Identifies a key field of a table	X
Flag: Field is required (not blank)
Data element (semantic domain)	CO_RESSOURCE
Check table name of the foreign key	CSKR
Nesting depth for includes	0
ABAP data type (C,D,N,...)	C
Internal Length in Bytes	000020
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	CHAR
Length (No. of Characters)	000010
Number of Decimal Places	000000
Domain name	CO_RESSOURCE
Origin of an Input Help	P
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID	RCE
Application class for DD objects (not used)	KA
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Resource
Output Length	000010
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table	CSKR
Conversion Routine	ALPHA
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects	D
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field RESRC

A137-LAND1 - Country/Region Key ▼

Description: Country/Region Key
Field Name: LAND1
Data Element: LAND1_GP
Data Type: CHAR
Length (Dec): 000003 (000000)
Check Table: T005
Conversion Routine:
Domain Name: LAND1
Memory ID:
App Class: SAP
SHLP Name: C_LAND1
SHLP Field: LAND1

Table Name	A137
Field Name	LAND1
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0007
Identifies a key field of a table	X
Flag: Field is required (not blank)
Data element (semantic domain)	LAND1_GP
Check table name of the foreign key	T005
Nesting depth for includes	0
ABAP data type (C,D,N,...)	C
Internal Length in Bytes	000006
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	CHAR
Length (No. of Characters)	000003
Number of Decimal Places	000000
Domain name	LAND1
Origin of an Input Help	P
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID
Application class for DD objects (not used)	SAP
Name of a Search Help	C_LAND1
Name of a search help parameter	LAND1
Short Description of Repository Objects	Country/Region Key
Output Length	000003
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table	T005
Conversion Routine
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field LAND1

A137-REGIO - Region (State, Province, County) ▼

Description: Region (State, Province, County)
Field Name: REGIO
Data Element: REGIO
Data Type: CHAR
Length (Dec): 000003 (000000)
Check Table: T005S
Conversion Routine:
Domain Name: REGIO
Memory ID:
App Class: SAP
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	REGIO
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0008
Identifies a key field of a table	X
Flag: Field is required (not blank)
Data element (semantic domain)	REGIO
Check table name of the foreign key	T005S
Nesting depth for includes	0
ABAP data type (C,D,N,...)	C
Internal Length in Bytes	000006
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	CHAR
Length (No. of Characters)	000003
Number of Decimal Places	000000
Domain name	REGIO
Origin of an Input Help	P
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID
Application class for DD objects (not used)	SAP
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Region (State, Province, County)
Output Length	000003
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table	T005S
Conversion Routine
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field REGIO

A137-DATBI - Validity end date of the condition record ▼

Description: Validity end date of the condition record
Field Name: DATBI
Data Element: KODATBI
Data Type: DATS
Length (Dec): 000008 (000000)
Check Table:
Conversion Routine:
Domain Name: DATUM
Memory ID:
App Class: TEST
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	DATBI
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0009
Identifies a key field of a table	X
Flag: Field is required (not blank)
Data element (semantic domain)	KODATBI
Check table name of the foreign key
Nesting depth for includes	0
ABAP data type (C,D,N,...)	D
Internal Length in Bytes	000016
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	DATS
Length (No. of Characters)	000008
Number of Decimal Places	000000
Domain name	DATUM
Origin of an Input Help	T
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID
Application class for DD objects (not used)	TEST
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Validity end date of the condition record
Output Length	000010
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table
Conversion Routine
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field DATBI

A137-DATAB - Validity start date of the condition record ▼

Description: Validity start date of the condition record
Field Name: DATAB
Data Element: KODATAB
Data Type: DATS
Length (Dec): 000008 (000000)
Check Table:
Conversion Routine:
Domain Name: DATUM
Memory ID:
App Class: TEST
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	DATAB
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0010
Identifies a key field of a table
Flag: Field is required (not blank)
Data element (semantic domain)	KODATAB
Check table name of the foreign key
Nesting depth for includes	0
ABAP data type (C,D,N,...)	D
Internal Length in Bytes	000016
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	DATS
Length (No. of Characters)	000008
Number of Decimal Places	000000
Domain name	DATUM
Origin of an Input Help	T
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID
Application class for DD objects (not used)	TEST
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Validity start date of the condition record
Output Length	000010
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table
Conversion Routine
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field DATAB

A137-KNUMH - Number of Condition Record ▼

Description: Number of Condition Record
Field Name: KNUMH
Data Element: KNUMH
Data Type: CHAR
Length (Dec): 000010 (000000)
Check Table:
Conversion Routine:
Domain Name: KNUMH
Memory ID:
App Class: VF
SHLP Name:
SHLP Field:

Table Name	A137
Field Name	KNUMH
Activation State of Repository Object	A
Version of the entry (not used)	0000
Position of the field in the table	0011
Identifies a key field of a table
Flag: Field is required (not blank)
Data element (semantic domain)	KNUMH
Check table name of the foreign key
Nesting depth for includes	0
ABAP data type (C,D,N,...)	C
Internal Length in Bytes	000020
Reference Table for Field
Name of included table
Reference Field for Currency and Quantity Fields
Check or generating module for fields
Indicator for initial values in database fields	X
Data Type in ABAP Dictionary	CHAR
Length (No. of Characters)	000010
Number of Decimal Places	000000
Domain name	KNUMH
Origin of an Input Help
DD: Flag if it is a table
DD: Depth for structured types	00
DD: Component Type	E
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table	0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types	00
Spatial Reference System	0
Short Description of Repository Objects
Set/Get parameter ID
Application class for DD objects (not used)	VF
Name of a Search Help
Name of a search help parameter
Short Description of Repository Objects	Number of Condition Record
Output Length	000010
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value table
Conversion Routine
Template (not used)
Template length (not used)	0000
Activation flag
Activation type	00
Original Language in Repository objects
Reserve for domains (not used)
Flag for private DD objects (not used)
Domain name
DD: Indicator that at least one domain append exists
DD: Is a generated proxy object
DD: Indicator whether an AM/PM time format is desired
ABAP Language Version

See all SAP tables containing field KNUMH

View list of all SAP tables (S4H/ECC)
Select data from SAP table A137

A100	- SOrg/DstCh/Material_MainItem/Material
A101	- SOrg/DstCh/Material-Main Item/Material Pricing Group
A102	- SOrg/DstCh/Material Pricing Group-Main Item/Material
A103	- SOrg/DstCh/MaterialPricingGroup-MainItem/MatPricingGroup
A104	- Service Conditions (Own Estimate)
A105	- Controlling Area/Company Code/Business Area
A106	- Price List/Material Group
A107	- Vendor Hierarchy
A108	- Vendor Hierarchy / Material
A109	- Vendor hierarchy: vendor sub-range