SAP A005 table - Customer/Material details in SAP

SAP A005 table summary

Object Name: A005
Dictionary Type: Transparent table
Description: Customer/Material

Field list for A005 table

Details
A005-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 NameA005
Field NameMANDT
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0001
Identifies a key field of a tableX
Flag: Field is required (not blank)
Data element (semantic domain)MANDT
Check table name of the foreign keyT000
Nesting depth for includes0
ABAP data type (C,D,N,...)C
Internal Length in Bytes000006
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 fieldsX
Data Type in ABAP DictionaryCLNT
Length (No. of Characters)000003
Number of Decimal Places000000
Domain nameMANDT
Origin of an Input HelpP
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
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 ObjectsClient
Output Length000003
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value tableT000
Conversion Routine
Template (not used)
Template length (not used)0000
Activation flag
Activation type00
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
A005-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 NameA005
Field NameKAPPL
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0002
Identifies a key field of a tableX
Flag: Field is required (not blank)
Data element (semantic domain)KAPPL
Check table name of the foreign keyT681A
Nesting depth for includes0
ABAP data type (C,D,N,...)C
Internal Length in Bytes000004
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 fieldsX
Data Type in ABAP DictionaryCHAR
Length (No. of Characters)000002
Number of Decimal Places000000
Domain nameKAPPL
Origin of an Input HelpP
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
Short Description of Repository Objects
Set/Get parameter IDKAP
Application class for DD objects (not used)VF
Name of a Search Help
Name of a search help parameter
Short Description of Repository ObjectsApplication
Output Length000002
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value tableT681A
Conversion Routine
Template (not used)
Template length (not used)0000
Activation flag
Activation type00
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
A005-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 NameA005
Field NameKSCHL
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0003
Identifies a key field of a tableX
Flag: Field is required (not blank)
Data element (semantic domain)KSCHA
Check table name of the foreign keyT685
Nesting depth for includes0
ABAP data type (C,D,N,...)C
Internal Length in Bytes000008
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 fieldsX
Data Type in ABAP DictionaryCHAR
Length (No. of Characters)000004
Number of Decimal Places000000
Domain nameKSCHL
Origin of an Input HelpP
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
Short Description of Repository Objects
Set/Get parameter IDVKS
Application class for DD objects (not used)VF
Name of a Search Help
Name of a search help parameter
Short Description of Repository ObjectsCondition Type
Output Length000004
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value tableT685
Conversion Routine
Template (not used)
Template length (not used)0000
Activation flag
Activation type00
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
A005-VKORG - Sales Organization ▼

Description: Sales Organization
Field Name: VKORG
Data Element: VKORG
Data Type: CHAR
Length (Dec): 000004 (000000)
Check Table: TVKO
Conversion Routine:
Domain Name: VKORG
Memory ID: VKO
App Class: MG
SHLP Name: C_VKORG
SHLP Field: VKORG

Table NameA005
Field NameVKORG
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0004
Identifies a key field of a tableX
Flag: Field is required (not blank)
Data element (semantic domain)VKORG
Check table name of the foreign keyTVKO
Nesting depth for includes0
ABAP data type (C,D,N,...)C
Internal Length in Bytes000008
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 fieldsX
Data Type in ABAP DictionaryCHAR
Length (No. of Characters)000004
Number of Decimal Places000000
Domain nameVKORG
Origin of an Input HelpP
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
Short Description of Repository Objects
Set/Get parameter IDVKO
Application class for DD objects (not used)MG
Name of a Search HelpC_VKORG
Name of a search help parameterVKORG
Short Description of Repository ObjectsSales Organization
Output Length000004
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value tableTVKO
Conversion Routine
Template (not used)
Template length (not used)0000
Activation flag
Activation type00
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 VKORG
A005-VTWEG - Distribution Channel ▼

Description: Distribution Channel
Field Name: VTWEG
Data Element: VTWEG
Data Type: CHAR
Length (Dec): 000002 (000000)
Check Table: TVTW
Conversion Routine:
Domain Name: VTWEG
Memory ID: VTW
App Class: MG
SHLP Name: C_VTWEG
SHLP Field: VTWEG

Table NameA005
Field NameVTWEG
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0005
Identifies a key field of a tableX
Flag: Field is required (not blank)
Data element (semantic domain)VTWEG
Check table name of the foreign keyTVTW
Nesting depth for includes0
ABAP data type (C,D,N,...)C
Internal Length in Bytes000004
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 fieldsX
Data Type in ABAP DictionaryCHAR
Length (No. of Characters)000002
Number of Decimal Places000000
Domain nameVTWEG
Origin of an Input HelpP
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
Short Description of Repository Objects
Set/Get parameter IDVTW
Application class for DD objects (not used)MG
Name of a Search HelpC_VTWEG
Name of a search help parameterVTWEG
Short Description of Repository ObjectsDistribution Channel
Output Length000002
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value tableTVTW
Conversion Routine
Template (not used)
Template length (not used)0000
Activation flag
Activation type00
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 VTWEG
A005-KUNNR - Customer number ▼

Description: Customer number
Field Name: KUNNR
Data Element: KUNNR_V
Data Type: CHAR
Length (Dec): 000010 (000000)
Check Table: KNA1
Conversion Routine: ALPHA
Domain Name: KUNNR
Memory ID: KUN
App Class: V
SHLP Name:
SHLP Field:

Table NameA005
Field NameKUNNR
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0006
Identifies a key field of a tableX
Flag: Field is required (not blank)
Data element (semantic domain)KUNNR_V
Check table name of the foreign keyKNA1
Nesting depth for includes0
ABAP data type (C,D,N,...)C
Internal Length in Bytes000020
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 fieldsX
Data Type in ABAP DictionaryCHAR
Length (No. of Characters)000010
Number of Decimal Places000000
Domain nameKUNNR
Origin of an Input HelpP
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
Short Description of Repository Objects
Set/Get parameter IDKUN
Application class for DD objects (not used)V
Name of a Search Help
Name of a search help parameter
Short Description of Repository ObjectsCustomer number
Output Length000010
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value tableKNA1
Conversion RoutineALPHA
Template (not used)
Template length (not used)0000
Activation flag
Activation type00
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 KUNNR
A005-MATNR - Material Number ▼

Description: Material Number
Field Name: MATNR
Data Element: MATNR
Data Type: CHAR
Length (Dec): 000040 (000000)
Check Table: MARA
Conversion Routine: MATN1
Domain Name: MATNR
Memory ID: MAT
App Class: MG
SHLP Name: S_MAT1
SHLP Field: MATNR

Table NameA005
Field NameMATNR
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0007
Identifies a key field of a tableX
Flag: Field is required (not blank)
Data element (semantic domain)MATNR
Check table name of the foreign keyMARA
Nesting depth for includes0
ABAP data type (C,D,N,...)C
Internal Length in Bytes000080
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 fieldsX
Data Type in ABAP DictionaryCHAR
Length (No. of Characters)000040
Number of Decimal Places000000
Domain nameMATNR
Origin of an Input HelpP
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
Short Description of Repository Objects
Set/Get parameter IDMAT
Application class for DD objects (not used)MG
Name of a Search HelpS_MAT1
Name of a search help parameterMATNR
Short Description of Repository ObjectsMaterial Number
Output Length000040
Lowercase letters allowed/not allowed
Flag for sign in numerical fields
Flag for language-dependent values(not used)
Existence of fixed values
Value tableMARA
Conversion RoutineMATN1
Template (not used)
Template length (not used)0000
Activation flag
Activation type00
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 MATNR
A005-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 NameA005
Field NameDATBI
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0008
Identifies a key field of a tableX
Flag: Field is required (not blank)
Data element (semantic domain)KODATBI
Check table name of the foreign key
Nesting depth for includes0
ABAP data type (C,D,N,...)D
Internal Length in Bytes000016
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 fieldsX
Data Type in ABAP DictionaryDATS
Length (No. of Characters)000008
Number of Decimal Places000000
Domain nameDATUM
Origin of an Input HelpT
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
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 ObjectsValidity end date of the condition record
Output Length000010
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 type00
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
A005-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 NameA005
Field NameDATAB
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0009
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 includes0
ABAP data type (C,D,N,...)D
Internal Length in Bytes000016
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
Data Type in ABAP DictionaryDATS
Length (No. of Characters)000008
Number of Decimal Places000000
Domain nameDATUM
Origin of an Input HelpT
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
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 ObjectsValidity start date of the condition record
Output Length000010
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 type00
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
A005-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 NameA005
Field NameKNUMH
Activation State of Repository ObjectA
Version of the entry (not used)0000
Position of the field in the table0010
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 includes0
ABAP data type (C,D,N,...)C
Internal Length in Bytes000020
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
Data Type in ABAP DictionaryCHAR
Length (No. of Characters)000010
Number of Decimal Places000000
Domain nameKNUMH
Origin of an Input Help
DD: Flag if it is a table
DD: Depth for structured types00
DD: Component TypeE
Type of Object Referenced
DD: Indicator for a Language Field
Position of the field in the table0000
Anonymization Indicator (for User Fields)
DD: Output Style (Output Style) for Decfloat Types00
Spatial Reference System0
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 ObjectsNumber of Condition Record
Output Length000010
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 type00
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 A005