Netweaver Data Model

Connection String Options

  1. Auto Cache
  2. Cache Connection
  3. Cache Driver
  4. Cache Location
  5. Cache Metadata
  6. Charset
  7. Client
  8. Connection Type
  9. Connect On Open
  10. Destination
  11. Endian Type
  12. Firewall Password
  13. Firewall Port
  14. Firewall Server
  15. Firewall Type
  16. Firewall User
  17. Gateway Host
  18. Gateway Service
  19. Group
  20. Host
  21. Initial Value Mode
  22. Language
  23. Location
  24. Logfile
  25. Max Log File Size
  26. Max Rows
  27. Message Server
  28. Message Server Service
  29. Offline
  30. Other
  31. Pagesize
  32. Password
  33. Proxy Auth Scheme
  34. Proxy Auto Detect
  35. Proxy Password
  36. Proxy Port
  37. Proxy Server
  38. Proxy SSL Type
  39. Proxy User
  40. Pseudo Columns
  41. Query Cache
  42. Read Table Function
  43. RFC Url
  44. RTK
  45. SNC Lib Path
  46. SNC Mode
  47. SNC Name
  48. SNC Partner Name
  49. SNC Qop
  50. SSL Server Cert
  51. Support Enhanced SQL
  52. System Id
  53. System Number
  54. Tables
  55. Timeout
  56. User
  57. Use Unicode RFC
  58. Verbosity

Auto Cache

Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver automatically caches the results of SELECT queries to a cache specified by the CacheLocation option. CacheLocation defines the path to a simple, file-based cache.

AutoCache is the simplest caching configuration available, however, like any caching scheme, using a cache is not without pitfalls such as reporting on stale data. The driver is designed to be fully functional without relying on caching.

The following sections outline how and when to use AutoCache. Understanding how AutoCache works and its limitations will help you choose an effective caching strategy. For more information on deploying other caching strategies, see Caching Data.

How AutoCaching Works

When you execute a SELECT statement with AutoCache set, the driver executes the query to the remote data and persists the results; rows and columns that already exist are overwritten. That is, SELECT statements are used to create and refresh the cache, not to query it.

Non-queries (such as UPDATE/INSERT/DELETE statements) are executed to the remote data as well; these statements will not modify the data in the cache at all, regardless of the value set for AutoCache.

To work with the local data, append #CACHE to the table name. For example:

SELECT * FROM [MARA#CACHE]
Limitations of AutoCache

In the following scenarios, consider the alternatives listed below:

  • When you need to work with the cache transparently: Because AutoCache requires a special syntax to utilize the cache, it is not suitable for use with BI, analytics, and reporting. Many of these tools generate SQL statements for you; these generated statements will still be executed to SAP instead of the cache.

    In these situations, one solution is to use the Offline property. When this is set, all queries are executed locally. See Caching: Best Practices for examples.

    One downside of this approach is that it requires a separate connection. As an alternative, consider using the CData Sync tool to maintain a local database that is kept fresh with scheduled updates.

  • When you need more control over cached data: The AutoCache feature does not have the ability to remove rows from the cache that were deleted from the remote data. It also does not support dropping a table from the cache or more advanced cache maintenance such as changing the cached table schemas.

    In this scenario, consider CACHE Statements. CACHE statements can remove cached rows that no longer exist in SAP.

    See Caching Explicitly for more information on how to use CACHE statements.

  • When you need to work with an RDBMS: AutoCache can only be used with the default database, JavaDB or SQLite. Many enterprises will need to use an RDBMS to support more concurrent writes or integrate with existing infrastructure. You can specify a database driver with CacheConnection and CacheDriver.



Cache Connection

Data Type

string

Default Value

""

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. The CacheConnection defines the connection properties necessary to connect to the cache database.

Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost:7437;user=sa;password=123456;databaseName=Cache'



Cache Driver

Data Type

string

Default Value

""

Remarks

You can cache to any database that you have a JDBC driver for. The driver has been tested with SQL Server, Derby and Java DB, MySQL, Oracle, and SQLite.

The cache database is determined based on CacheDriver and the CacheConnection properties. The CacheDriver is the name of the JDBC driver class that you would like to use to cache data. The example below caches to SQL Server:

Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost:7437;user=sa;password=123456;databaseName=Cache'
Note that the driver JAR must be specified on the classpath.



Cache Location

Data Type

string

Default Value

""

Remarks

If AutoCache is set but the cache location is not specified, CacheLocation defaults to the cache folder on the directory specified by the Location setting.

The CacheLocation is a simple, file-based cache. See the CacheConnection and CacheDriver properties to cache to other databases.



Cache Metadata

Data Type

bool

Default Value

false

Remarks

The cache.db file will be created in the location specified by the CacheConnection or if that is not set, the CacheLocation.



Charset

Data Type

string

Default Value

"DEFAULT"

Remarks

For example, UTF-8. Use DEFAULT to use the machine default.



Client

Data Type

string

Default Value

""

Remarks

Client, User, and Password are needed for authentication to the R/3 server.



Connection Type

Data Type

string

Default Value

"Classic"

Remarks

The type of connection you are making to SAP.
Use CLASSIC for the librfc32.dll.
Use CLASSIC_UNICODE for the librfc32u.dll.
Use NETWEAVER to indicate you are using the sapnwrfc.dll.
Use JCO to indicate you are using the sapjco.jar.
Use SOAP to indicate you are using SOAP and setting the RFC URL.



Connect On Open

Data Type

bool

Default Value

true

Remarks

When set to 'true', a connection will be made to SAP when the connection is opened. This property enables the 'Test Connection' feature available in various database tools.

This feature acts as a NOOP command as it is used to verify a connection can be made to SAP and nothing from this initial connection is maintained.

Setting this property to 'false' may provide performance improvements (depending upon the number of times a connection is opened).



Destination

Data Type

string

Default Value

""

Remarks

If the connection is not described completely by the remaining properties, this property is used as a key into an .ini file where the connection should then be described.

See the SAP RFC SDK for more information about using .ini files with the RFC library.



Endian Type

Data Type

string

Default Value

""

Remarks

If you do not know the Endian type for the SAP server, leave this value blank.



Firewall Password

Data Type

string

Default Value

""

Remarks

If FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate to the given firewall.



Firewall Port

Data Type

string

Default Value

""

Remarks

Note that the driver sets the FirewallPort to the default port associated with the specified FirewallType. See the description of the FirewallType option for details.



Firewall Server

Data Type

string

Default Value

""

Remarks

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding IP address.



Firewall Type

Data Type

string

Default Value

"NONE"

Remarks

The applicable values are:

Firewall Type Default FirewallPort
TUNNEL 80
SOCKS4 1080
SOCKS5 1080



Firewall User

Data Type

string

Default Value

""

Remarks

If the FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate against the firewall.



Gateway Host

Data Type

string

Default Value

""

Remarks

If not specified, the SAP system will assume to run at Host.



Gateway Service

Data Type

string

Default Value

""

Remarks

If not specified, the SAP system will use the default "sapgw##" where the "##" is the SystemNumber.



Group

Data Type

string

Default Value

""

Remarks

The default in most SAP systems will be PUBLIC.



Host

Data Type

string

Default Value

""

Remarks

Host names can be regular host names defined in a hosts file, an IP address like 123.123.123.123, or an SAProuter address such as "/H/hostname/S/port/H/host/S/port/ ..."

This property is required when connecting through the SAP librfc32.dll interface. The "librfc32.dll" is included in R/3 (NetWeaver) and RFC API installations, or may be acquired directly from SAP.

This property is necessary only when not using the RFCUrl property to connect with SAP.



Initial Value Mode

Data Type

string

Default Value

"Null"

Remarks

Set to Null to treat them as if they were null. Set to InitialValue to return the values exactly as they come back from SAP.



Language

Data Type

string

Default Value

"EN"

Remarks

By default, EN will be used.



Location

Data Type

string

Default Value

""

Remarks

The path to a directory which contains the schema files for the driver (.rsd files for tables and views, .rsb files for stored procedures). The Location property is only needed if you would like to customize definitions (e.g., change a column name, ignore a column, etc.) or extend the data model with new tables, views, or stored procedures.

The schema files used in your application must be deployed with other assemblies. You must also ensure that Location points to the folder that contains the schema files. The folder location can be a relative path from the location of the executable.

The path to a directory which contains the schema files for the driver (.rsd files for tables and views; .rsb files for stored procedures). The Location property allows the driver to interface with a variety of data sources.

The schema files used in your application must be deployed with other assemblies. You must also ensure that Location points to the folder that contains the schema files. The folder location can be a relative path from the location of the executable.



Logfile

Data Type

string

Default Value

""

Remarks

For more control over what is written to the log file, take a look at Verbosity.



Max Log File Size

Data Type

string

Default Value

""

Remarks

A string specifying the maximum size in bytes for a log file (ex: 10MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end. There is no limit by default. Values lower than 100kB will use 100kB as the value instead.



Max Rows

Data Type

string

Default Value

"1000"

Remarks

To avoid accidentally returning all of the information for a given SAP table, MaxRows may be used to set a standard limitation on the number of results to return for any given table. Set MaxRows to 0 or less than 0 for it to be ignored.



Message Server

Data Type

string

Default Value

""

Remarks

The message server is used instead of an individual application server when connecting to an SAP system using load balancing. The load is balanced between several application servers and clients only need to know the name of the message server to connect.



Message Server Service

Data Type

string

Default Value

""

Remarks

If not specified, http will be used. On windows machines, these services to their port mappings are stored on C:\windows\system32\drivers\etc\services.



Offline

Data Type

bool

Default Value

false

Remarks

When Offline is set to TRUE, all queries execute against the cache as opposed to the live data source. In this mode, certain queries like INSERT, UPDATE, DELETE, and CACHE are not allowed.



Other

Data Type

string

Default Value

""

Remarks

The Other property is a semicolon-separated list of name-value pairs used in connection parameters specific to a data source.

Caching Configuration

CachePartial=TrueCaches only a subset of columns, which you can specify in your query.
QueryPassthrough=TruePasses the specified query to the cache database instead of using the SQL parser of the driver.

Integration and Formatting

SupportAccessLinkedModeIn Access' linked mode, it is generally a good idea to always use a cache as most data sources do not support multiple Id queries. However if you want to use the driver in Access but not in linked mode, this property must be set to False to avoid using a cache of a SELECT * query for the given table.
ConvertDateTimesToGMTWhether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filenameRecords the underlying socket data transfer to the specified file.
ClientCultureThis property can be used to specify the format of data (e.g., currency values) that is accepted by the client application. This property can be used when the client application does not support the machine's culture settings. For example, Microsoft Access requires 'en-US'.
CultureThis setting can be used to specify culture settings that determine how the driver interprets certain data types that are passed into the driver. For example, setting Culture='de-DE' will output German formats even on an American machine.



Pagesize

Data Type

string

Default Value

""

Remarks

The number of results to return per page from SAP. Only used for SAP tables. The RFC_READ_TABLE uses the rowcount and rowskips parameters for paging. This can cause unusual behavior if you are paging through data while it is being interacted with. For instance, if a new row is inserted to a table while you are paging through data, you may see a duplicate entry show up. Also, if a row is deleted from a table, the results you get back may be missing a row. This can be avoided by increasing the pagesize to a degree that there is only one page of data returned. However, please note that this can significantly decrease performance for large tables.



Password

Data Type

string

Default Value

""

Remarks

Client, User, and Password are needed for authentication to the R/3 server.



Proxy Auth Scheme

Data Type

string

Default Value

"BASIC"

Remarks

This value may be BASIC, DIGEST, NONE, NTLM, NEGOTIATE or PROPRIETARY.



Proxy Auto Detect

Data Type

bool

Default Value

true

Remarks

This indicates whether to use the default system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings.



Proxy Password

Data Type

string

Default Value

""

Remarks

If the ProxyServer is specified, the ProxyUser and ProxyPassword properties are used to connect and authenticate against the firewall.



Proxy Port

Data Type

string

Default Value

"80"

Remarks

See the description of the ProxyServer field for details.



Proxy Server

Data Type

string

Default Value

""

Remarks

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding address.



Proxy SSL Type

Data Type

string

Default Value

"AUTO"

Remarks

This value may be AUTO, ALWAYS, NEVER, or TUNNEL.



Proxy User

Data Type

string

Default Value

""

Remarks

If a ProxyServer is specified, the ProxyUser and ProxyPassword options are used to connect and authenticate against the firewall.



Pseudo Columns

Data Type

string

Default Value

""

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; i.e., "*=*".



Query Cache

Data Type

string

Default Value

""

Remarks

The QueryCache allows you to cache the results of a query in-memory and use them until the cache expires. Setting the QueryCache can improve performance if the same or similar (see below) queries are executed often. The in-memory query cache is shared across connections, so it can help with performance even if more than one connection is being used.

The cache manager for QueryCache will not only use the results in the cache for exactly the same query, but also for queries that represent a subset of data in the cached query. For example, in the following queries, the cache created while executing Query A will be used to obtain the results for both Query B and Query C.

SELECT * from Account; // Query A
SELECT * from Account WHERE Name LIKE '%John'; // Query B
SELECT Id, Name from from Account LIMIT 10; // Query C

Setting the QueryCache to zero disables in-memory caching.



Read Table Function

Data Type

string

Default Value

"RFC_READ_TABLE"

Remarks

The function to use for reading table data. Change this to a custom function to remove limitations on the buffer size.



RFC Url

Data Type

string

Default Value

""

Remarks

If connecting to SAP through the SOAP interface, this property must be set to the SOAP URL of your SAP system.

An example of this is http://localhost:8000/sap/bc/soap/rfc.

The SOAP service must be enabled in your SAP system for this type of connection to work properly.



RTK

Data Type

string

Default Value

""

Remarks

The RTK property may be used to license a build. Please see the included licensing file to see how to set this property. The runtime key is only available if you purchased an OEM license.



SNC Lib Path

Data Type

string

Default Value

""

Remarks

The default is the system-defined library as defined in the environment variable SNC_LIB.



SNC Mode

Data Type

bool

Default Value

false

Remarks

SNC security will only be used when you establish a connection to SAP using one of the RFC SDKs outlined in the ConnectionType. You should be able to find the values you need to specify by going to your SAP Logon, right-clicking your connection and opening Properties. On the System Entry Properties dialog, open the Network --> Secure Network Settings window. This window should have the information you need to specify for the SNC properties.



SNC Name

Data Type

string

Default Value

""

Remarks

Although this parameter is optional, we recommend setting it to make sure that the correct SNC name is used for the connection.



SNC Partner Name

Data Type

string

Default Value

""

Remarks

The application server's SNC name.



SNC Qop

Data Type

string

Default Value

""

Remarks

This is an integer that will be -1 if unspecified and can potentially go to a maximum of 9 depending on your application server. Valid values are 1, 2, 3, 8, or 9, which correspond to the following protection levels:

1Apply authentication only.
2Apply integrity protection (authentication).
3Apply privacy protection (integrity and authentication).
8Apply the default protection.
9Apply the maximum protection.



SSL Server Cert

Data Type

string

Default Value

""

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine will be rejected. This can take the form of a full PEM certificate, the path to a file containing the certificate, the public key, the MD5 thumbprint, or the SHA1 thumbprint. If not specified, any trusted certificate will be accepted. Use '*' to signify to accept all certificates (not recommended for security concerns).



Support Enhanced SQL

Data Type

bool

Default Value

true

Remarks

Use QueryCache to cache in memory for a given time in seconds or to disable in-memory caching.

It is recommended to set this property to false when using ABAP and Query tables to avoid getting incorrect results.



System Id

Data Type

string

Default Value

""

Remarks

The System Id is a string with a maximum of three characters. It often used in connections to SAP systems with load balancing, but may also be used in SAP systems with a dedicated application server.



System Number

Data Type

string

Default Value

"0"

Remarks

The valid range is 0 to 99. In general, this value is 0.



Tables

Data Type

string

Default Value

""

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the driver.



Timeout

Data Type

string

Default Value

"60"

Remarks

If the Timeout property is set to 0, operations do not time out: They run until they complete successfully or encounter an error condition.

If Timeout expires and the operation is not yet complete, the driver throws an exception.



User

Data Type

string

Default Value

""

Remarks

Client, User, and Password are needed for authentication to the R/3 server.



Use Unicode RFC

Data Type

bool

Default Value

true

Remarks

A boolean indicating if you want to use RFC_GET_UNICODE_STRUCTURE to get structure information from your SAP system. Required for SAP systems in Unicode, but should be set to false for SAP systems that do not support RFC_GET_UNICODE_STRUCTURE.



Verbosity

Data Type

string

Default Value

"1"

Remarks

The verbosity level determines the amount of detail that the driver reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are described below:

1Setting Verbosity to 1 will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.
2Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and HTTP headers.
3Setting Verbosity to 3 will additionally log the body of the HTTP requests.
4Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.
5Setting Verbosity to 5 will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.

The Verbosity should not be set to greater than 1 for normal operation. Substantial amounts of data can be logged at higher verbosities, which can delay execution times.





Views

  1. ABAP_MARA
  2. ABAP_USR02
  3. AQGQCAT
  4. AQLQCAT
  5. BIRTHDAYLIST
  6. CAR_SEARCH
  7. CEPC
  8. CSKS
  9. DD02L
  10. DD02T
  11. DD03L
  12. EINA
  13. EKKN
  14. EKKO
  15. EKPO
  16. IKPF
  17. ISEG
  18. KNA1
  19. LFA1
  20. MAKT
  21. MARA
  22. MARC
  23. MARD
  24. SearchFunctions
  25. SKB1
  26. T000
  27. T001
  28. T001W
  29. T880
  30. TFTIT
  31. VBAK
  32. VBAP

ABAP_MARA

Customized ABAP query for MARA.

Columns

Name Type Description
MANDT [KEY] String Client
MATNR [KEY] String Material Number
ERSDA String Created On



ABAP_USR02

Customized ABAP query for USR02.

Columns

Name Type Description
MANDT [KEY] String Client
BNAME [KEY] String Name of the user
BCODE String Initial password



AQGQCAT

The SAP table AQGQCAT.

Columns

Name Type Description
NUM [KEY] String SAP Query (S): Name of a user group
QNUM [KEY] String SAP Query (S): Query name
CLAS String SAP Query (S): InfoSet

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



AQLQCAT

The SAP table AQLQCAT.

Columns

Name Type Description
MANDT [KEY] String Client
NUM [KEY] String SAP Query (S): Name of a user group
QNUM [KEY] String SAP Query (S): Query name
CLAS String SAP Query (S): InfoSet

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



BIRTHDAYLIST

The SAP query BIRTHDAYLIST..

Columns

Name Type Description
P0000-PERNR String P0000-PERNR
P0002-NACHN String P0002-NACHN
P0002-VORNA String P0002-VORNA
SYHR_A_P0000_AF_HIREDATE Date SYHR_A_P0000_AF_HIREDATE
SYHR_A_P0000_AF_FIREDATE Date SYHR_A_P0000_AF_FIREDATE
P0002-GBDAT Date Date of birth
P0002-GBTAG String Birthday (within a month)
SYHR_A_P0002_AF_MTGEBDAT String Day and month of date of birth
P0002-GBJHR String Year of birth
P0002-GBMON String Month of birth
P0002-GESCH String Gender key
P0001-KOSTL String Cost center
P0001-ORGEH String Organizational unit
SYHR_A_P0002_AF_EMPL_AGE Integer Age of employee

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PNPBEGDA Date Data selection: From
PNPBEGPS Date Person selection: From
PNPDISBD Date PNPDISBD
PNPDISED Date PNPDISED
PNPDISPJ String PNPDISPJ
PNPDISPP String PNPDISPP
PNPENDDA Date Data selection: To
PNPENDPS Date Person selection: To
PNPESSCF String PNPESSCF
PNPMCIDE String PNPMCIDE
PNPMCSTR String PNPMCSTR
PNPPABRJ String Period selection: Year
PNPPABRP String Period selection: Period
PNPPLVAR String PNPPLVAR
PNPSORTF String PNPSORTF
PNPSORTT String PNPSORTT
PNPTIMED String PNPTIMED
PNPTIMR1 String Today
PNPTIMR2 String Current month
PNPTIMR3 String Current year
PNPTIMR4 String To current date
PNPTIMR5 String From current date
PNPTIMR6 String Other period
PNPTIMR9 String Current period
PNPTIMRA String Other period
PNPXABKR String Period selection: Payroll area
PYABRJ0 String PYABRJ0
PYABRJ1 String PYABRJ1
PYABRP0 String PYABRP0
PYABRP1 String p1
PYARCH String PYARCH
PYBEGDA Date start
PYENDDA Date end
PYEVAL String PYEVAL
PYPA03R0 String r0
PYPA03R1 String r1
PYPARAID String PYPARAID
PYSORTT String PYSORTT
PYVW0 String PYVW0
PYVW0_0 String End of in-period
PYVW0_1 String In-period view
PYVW1 String PYVW1
PYVW1_0 String End of for-period
PYVW1_1 String For-period view
PYVW2 String PYVW2
PYVW2_0 String Payday
PYXABKR String Payroll Area
PNPABKRS String Payroll area
PNPANSVH String Work contract
PNPBTRTL String Personnel subarea
PNPBUKRS String Company code
PNPENAME String Employee name
PNPFISTL String Funds Center
PNPFKBER String Functional area
PNPGEBER String Fund
PNPGRANT String Grant
PNPGSBER String Business area
PNPINDEX String PNPINDEX
PNPJUPER String Legal person
PNPKOKRS String Controlling area
PNPKOKTL String Controlling area/cost center
PNPKOSTL String Cost center
PNPMASNG String Action type/action reason
PNPMASSG String Reason for action
PNPMASSN String Action type
PNPMSTBR String Supervisor area
PNPOBJID String PNPOBJID
PNPORGEH String Organizational unit
PNPOTYPE String Object Type
PNPPERNR String Personnel number
PNPPERSG String Employee group
PNPPERSK String Employee subgroup
PNPPLANS String Position
PNPSACHA String Payroll administrator
PNPSACHP String Personnel administrator
PNPSACHZ String Time recording administrator
PNPSASBA String Administrator group: payroll
PNPSASBP String Administrator group: personnel
PNPSASBZ String Administrator group: time
PNPSBMOD String Administrator group
PNPSNAME String EE name can be sorted
PNPSTAT1 String Customer-specific status
PNPSTAT2 String Employment status
PNPSTAT3 String Special payment status
PNPSTATU String Status 1/status 2/status 3
PNPSTELL String Job
PNPVDSK1 String Organization key
PNPWERKS String Personnel area
PNPXBWBK String Pers.area/subarea/cost center
PNPXPGPK String Employee group/subgroup
Workspace String The workspace to use when executing the query.

The default value is Global.

Variant String The variant for the query.
rows@next String This is a system column used to page through the results in SAP.



CAR_SEARCH

The SAP query CAR_SEARCH..

Columns

Name Type Description
P0000-PERNR String P0000-PERNR
P0002-VORNA String First name
P0002-NACHN String Last name
P0032-KFZKZ String License plate number
P0032-TEL01 String In-house telephone number
P0032-GEBNR String Building number
P0032-ZIMNR String Room number
P0001-ABKRS String P0001-ABKRS
P0001-BUKRS String P0001-BUKRS
P0001-KOSTL String P0001-KOSTL

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PNPBEGDA Date Data selection: From
PNPBEGPS Date Person selection: From
PNPDISBD Date PNPDISBD
PNPDISED Date PNPDISED
PNPDISPJ String PNPDISPJ
PNPDISPP String PNPDISPP
PNPENDDA Date Data selection: To
PNPENDPS Date Person selection: To
PNPESSCF String PNPESSCF
PNPMCIDE String PNPMCIDE
PNPMCSTR String PNPMCSTR
PNPPABRJ String Period selection: Year
PNPPABRP String Period selection: Period
PNPPLVAR String PNPPLVAR
PNPSORTF String PNPSORTF
PNPSORTT String PNPSORTT
PNPTIMED String PNPTIMED
PNPTIMR1 String Today
PNPTIMR2 String Current month
PNPTIMR3 String Current year
PNPTIMR4 String To current date
PNPTIMR5 String From current date
PNPTIMR6 String Other period
PNPTIMR9 String Current period
PNPTIMRA String Other period
PNPXABKR String Period selection: Payroll area
PYABRJ0 String PYABRJ0
PYABRJ1 String PYABRJ1
PYABRP0 String PYABRP0
PYABRP1 String p1
PYARCH String PYARCH
PYBEGDA Date start
PYENDDA Date end
PYEVAL String PYEVAL
PYPA03R0 String r0
PYPA03R1 String r1
PYPARAID String PYPARAID
PYSORTT String PYSORTT
PYVW0 String PYVW0
PYVW0_0 String End of in-period
PYVW0_1 String In-period view
PYVW1 String PYVW1
PYVW1_0 String End of for-period
PYVW1_1 String For-period view
PYVW2 String PYVW2
PYVW2_0 String Payday
PYXABKR String Payroll Area
PNPABKRS String Payroll area
PNPANSVH String Work contract
PNPBTRTL String Personnel subarea
PNPBUKRS String Company code
PNPENAME String Employee name
PNPFISTL String Funds Center
PNPFKBER String Functional area
PNPGEBER String Fund
PNPGRANT String Grant
PNPGSBER String Business area
PNPINDEX String PNPINDEX
PNPJUPER String Legal person
PNPKOKRS String Controlling area
PNPKOKTL String Controlling area/cost center
PNPKOSTL String Cost center
PNPMASNG String Action type/action reason
PNPMASSG String Reason for action
PNPMASSN String Action type
PNPMSTBR String Supervisor area
PNPOBJID String PNPOBJID
PNPORGEH String Organizational unit
PNPOTYPE String Object Type
PNPPERNR String Personnel number
PNPPERSG String Employee group
PNPPERSK String Employee subgroup
PNPPLANS String Position
PNPSACHA String Payroll administrator
PNPSACHP String Personnel administrator
PNPSACHZ String Time recording administrator
PNPSASBA String Administrator group: payroll
PNPSASBP String Administrator group: personnel
PNPSASBZ String Administrator group: time
PNPSBMOD String Administrator group
PNPSNAME String EE name can be sorted
PNPSTAT1 String Customer-specific status
PNPSTAT2 String Employment status
PNPSTAT3 String Special payment status
PNPSTATU String Status 1/status 2/status 3
PNPSTELL String Job
PNPVDSK1 String Organization key
PNPWERKS String Personnel area
PNPXBWBK String Pers.area/subarea/cost center
PNPXPGPK String Employee group/subgroup
Workspace String The workspace to use when executing the query.

The default value is Global.

Variant String The variant for the query.
rows@next String This is a system column used to page through the results in SAP.



CEPC

The SAP table CEPC.

Columns

Name Type Description
MANDT [KEY] String Client
PRCTR [KEY] String Profit Center
DATBI [KEY] Date Valid To Date
KOKRS [KEY] String Controlling Area
DATAB Date Valid-From Date
ERSDA Date Created on
USNAM String Entered by
MERKMAL String Field name of CO-PA characteristic
ABTEI String Department
VERAK String Person Responsible for Profit Center
VERAK_USER String User Responsible for the Profit Center
WAERS String Currency Key
NPRCTR String Successor profit center
LAND1 String Country Key
ANRED String Title
NAME1 String Name 1
NAME2 String Name 2
NAME3 String Name 3
NAME4 String Name 4
ORT01 String City
ORT02 String District
STRAS String House number and street
PFACH String PO Box
PSTLZ String Postal Code
PSTL2 String P.O. Box Postal Code
SPRAS String Language Key
TELBX String Telebox number
TELF1 String First telephone number
TELF2 String Second telephone number
TELFX String Fax Number
TELTX String Teletex number
TELX1 String Telex number
DATLT String Data communication line no.
DRNAM String Printer name for profit center
KHINR String Profit center area
BUKRS String Company Code
VNAME String Joint Venture
RECID String Recovery Indicator
ETYPE String Equity type
TXJCD String Tax Jurisdiction
REGIO String Region (State, Province, County)
KVEWE String Usage of the condition table
KAPPL String Application
KALSM String Procedure (Pricing, Output Control, Acct. Det., Costing,...)
LOGSYSTEM String Logical System
LOCK_IND String Lock indicator
PCA_TEMPLATE String Template for Formula Planning in Profit Centers
SEGMENT String Segment for Segmental Reporting

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



CSKS

The SAP table CSKS.

Columns

Name Type Description
MANDT [KEY] String Client
KOKRS [KEY] String Controlling Area
KOSTL [KEY] String Cost Center
DATBI [KEY] Date Valid To Date
DATAB Date Valid-From Date
BKZKP String Lock Indicator for Actual Primary Postings
PKZKP String Lock Indicator for Plan Primary Costs
BUKRS String Company Code
GSBER String Business Area
KOSAR String Cost Center Category
VERAK String Person Responsible
VERAK_USER String User Responsible
WAERS String Currency Key
KALSM String Costing Sheet
TXJCD String Tax Jurisdiction
PRCTR String Profit Center
WERKS String Plant
LOGSYSTEM String Logical System
ERSDA Date Created on
USNAM String Entered by
BKZKS String Lock Indicator for Actual Secondary Costs
BKZER String Lock Indicator for Actual Revenue Postings
BKZOB String Lock Indicator for Commitment Update
PKZKS String Lock Indicator for Plan Secondary Costs
PKZER String Lock Indicator for Planning Revenues
VMETH String Indicator for Allowed Allocation Methods
MGEFL String Indicator for Recording Consumption Quantities
ABTEI String Department
NKOST String Subsequent cost center
KVEWE String Usage of the condition table
KAPPL String Application
KOSZSCHL String CO-CCA Overhead Key
LAND1 String Country Key
ANRED String Title
NAME1 String Name 1
NAME2 String Name 2
NAME3 String Name 3
NAME4 String Name 4
ORT01 String City
ORT02 String District
STRAS String House number and street
PFACH String PO Box
PSTLZ String Postal Code
PSTL2 String P.O. Box Postal Code
REGIO String Region (State, Province, County)
SPRAS String Language Key
TELBX String Telebox number
TELF1 String First telephone number
TELF2 String Second telephone number
TELFX String Fax Number
TELTX String Teletex number
TELX1 String Telex number
DATLT String Data communication line no.
DRNAM String Printer destination for CCtr report
KHINR String Standard Hierarchy Area
CCKEY String Cost collector key
KOMPL String Completion flag for the cost center master record
STAKZ String Indicator. object is statistical
OBJNR String Object number
FUNKT String Function of cost center
AFUNK String Alternative function of cost center
CPI_TEMPL String Template for Activity-Independent Formula Planning
CPD_TEMPL String Template for Activity-Dependent Formula Planning
FUNC_AREA String Functional Area
SCI_TEMPL String Template: Activity-Independent Allocation to Cost Center
SCD_TEMPL String Template: Activity-Dependent Allocation to Cost Center
VNAME String Joint Venture
RECID String Recovery Indicator
ETYPE String Equity type
JV_OTYPE String Joint Venture Object Type
JV_JIBCL String JIB/JIBE Class
JV_JIBSA String JIB/JIBE Subclass A
FERC_IND String Regulatory indicator

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



DD02L

The SAP table DD02L.

Columns

Name Type Description
TABNAME [KEY] String Table Name
AS4LOCAL [KEY] String Activation Status of a Repository Object
AS4VERS [KEY] String Version of the entry (not used)
TABCLASS String Table category
SQLTAB String Name of an SQL table or an appended table
DATMIN String Minimum no. of entries
DATMAX String Maximum no. of entries
DATAVG String Average number of entries
CLIDEP String Flag indicating client-specific entries
BUFFERED String Buffering flag
COMPRFLAG String Field compression indicator
LANGDEP String Language dependency
ACTFLAG String Activation flag
APPLCLASS String Application class for DD objects (not used)
AUTHCLASS String Activation type
AS4USER String Last Changed by
AS4DATE Date Date of Last Change
AS4TIME Time Last changed at
MASTERLANG String Original Language in Repository objects
MAINFLAG String Flag if Maintenance with Standard Tools is allowed
CONTFLAG String Delivery class
RESERVETAB String SDIC: Reserve for tables
GLOBALFLAG String Flag for private DD objects (not used)
PROZPUFF String Percentage for buffers
VIEWCLASS String View Type
VIEWGRANT String Maintenance status (modif. authorization) for view data
MULTIPLEX String Indicator whether multiplexing is possible for a table
SHLPEXI String Search help attachment to table exists
PROXYTYPE String DD: Is a generated proxy object
EXCLASS String DD: Ranking for include and subtype extension
WRONGCL String Enhancement category is incorrect

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



DD02T

The SAP table DD02T.

Columns

Name Type Description
TABNAME [KEY] String Table Name
DDLANGUAGE [KEY] String Language Key
AS4LOCAL [KEY] String Activation Status of a Repository Object
AS4VERS [KEY] String Version of the entry (not used)
DDTEXT String Short Description of Repository Objects

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



DD03L

The SAP table DD03L.

Columns

Name Type Description
TABNAME [KEY] String Table Name
FIELDNAME [KEY] String Field Name
AS4LOCAL [KEY] String Activation Status of a Repository Object
AS4VERS [KEY] String Version of the entry (not used)
POSITION [KEY] String Position of the field in the table
KEYFLAG String Identifies a key field of a table
MANDATORY String Flag: Field is required (not blank)
ROLLNAME String Data element (semantic domain)
CHECKTABLE String Check table name of the foreign key
ADMINFIELD String Nesting depth for includes
INTTYPE String ABAP data type (C,D,N,...)
INTLEN String Internal Length in Bytes
REFTABLE String Table for reference field
PRECFIELD String Name of included table
REFFIELD String Reference field for currency and qty fields
CONROUT String Check or generating module for fields
NOTNULL String Indicator that NOT NULL is forced for this field
DATATYPE String Data Type in ABAP Dictionary
LENG String Length (No. of Characters)
DECIMALS String Number of Decimal Places
DOMNAME String Domain name
SHLPORIGIN String Origin of an Input Help
TABLETYPE String DD: Flag if it is a table
DEPTH String DD: Depth for structured types
COMPTYPE String DD: Component Type
REFTYPE String Type of Object Referenced
LANGUFLAG String DD: Indicator for a Language Field
DBPOSITION String Position of the field in the table
ANONYMOUS String Anonymization Indicator (for User Fields)
OUTPUTSTYLE String DD: Output Style (Output Style) for Decfloat Types

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



EINA

The SAP table EINA.

Columns

Name Type Description
MANDT [KEY] String Client
INFNR [KEY] String Number of Purchasing Info Record
MATNR String Material Number
MATKL String Material Group
LIFNR String Vendor Account Number
LOEKZ String Purchasing info: General data flagged for deletion
ERDAT Date Date on Which Record Was Created
ERNAM String Name of Person who Created the Object
TXZ01 String Short Text for Purchasing Info Record
SORTL String Sort Term for Non-Stock Info Records
MEINS String Purchase Order Unit of Measure
UMREZ Decimal Numerator for Conversion of Order Unit to Base Unit
UMREN Decimal Denominator for Conversion of Order Unit to Base Unit
IDNLF String Material Number Used by Vendor
VERKF String Salesperson Responsible in the Event of Queries
TELF1 String Vendor
MAHN1 Decimal Number of Days for First Reminder/Expediter
MAHN2 Decimal Number of Days for Second Reminder/Expediter
MAHN3 Decimal Number of Days for Third Reminder/Expediter
URZNR String Certificate Number
URZDT Date Certificate of Origin Valid Until
URZLA String Country of Issue of Certificate of Origin
URZTP String Certificate Category
URZZT String Number
LMEIN String Base Unit of Measure
REGIO String Region (State, Province, County)
VABME String Variable Purchase Order Unit Active
LTSNR String Vendor Subrange
LTSSF String Sort Sequence Number
WGLIF String Vendor Material Group
RUECK String Return Agreement
LIFAB Date Available (Deliverable) From
LIFBI Date Available (Deliverable) Until
KOLIF String Prior Vendor
ANZPU Decimal Number of Points
PUNEI String Points unit
RELIF String Regular Vendor
MFRNR String Manufacturer

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



EKKN

The SAP table EKKN.

Columns

Name Type Description
MANDT [KEY] String Client
EBELN [KEY] String Purchasing Document Number
EBELP [KEY] String Item Number of Purchasing Document
ZEKKN [KEY] String Sequential Number of Account Assignment
LOEKZ String Deletion Indicator: Purchasing Document Account Assignment
AEDAT Date Date on Which Record Was Created
KFLAG String Change flag: Purchasing (currently not used)
MENGE Decimal Quantity
VPROZ Decimal Distribution Percentage in Case of Multiple Account Assgt
NETWR Double Net Order Value in PO Currency
SAKTO String G/L Account Number
GSBER String Business Area
KOSTL String Cost Center
PROJN String Old: Project number : No longer used --> PS_POSNR
VBELN String Sales and Distribution Document Number
VBELP String Sales Document Item
VETEN String Delivery Schedule Line Number
KZBRB String Gross requirements indicator
ANLN1 String Main Asset Number
ANLN2 String Asset Subnumber
AUFNR String Order Number
WEMPF String Goods Recipient/Ship-To Party
ABLAD String Unloading Point
KOKRS String Controlling Area
XBKST String Posting to cost center?
XBAUF String Post To Order
XBPRO String Post to project
EREKZ String Final Invoice Indicator
KSTRG String Cost Object
PAOBJNR String Profitability Segment Number (CO-PA)
PRCTR String Profit Center
PS_PSP_PNR String Work Breakdown Structure Element (WBS Element)
NPLNR String Network Number for Account Assignment
AUFPL String Routing number of operations in the order
IMKEY String Internal Key for Real Estate Object
APLZL String Internal counter
VPTNR String Partner account number
FIPOS String Commitment Item
RECID String Recovery Indicator
ZZSPREG String Special Region
ZZBUSPARTN String Business partner
ZZPRODUCT String Product group
ZZLOCA String City
ZZCHAN String Distribution channel
ZZLOB String BUSINESS LINE
ZZNFAL String Fallnummer f?r IS-H
ZZUSERFLD1 String Territory
ZZUSERFLD2 String Owner/Cont.
ZZUSERFLD3 String Vein
ZZREGION String Location
ZZSTATE String State/Province Code
FISTL String Funds Center
GEBER String Fund
FKBER String Functional Area
DABRZ Date Reference Date for Settlement
AUFPL_ORD String Routing number of operations in the order
APLZL_ORD String General counter for order
MWSKZ String Tax on sales/purchases code
TXJCD String Tax Jurisdiction
NAVNW Double Non-deductible input tax
KBLNR String Document Number for Earmarked Funds
KBLPOS String Earmarked Funds: Document Item
LSTAR String Activity Type
PRZNR String Business Process
GRANT_NBR String Grant
BUDGET_PD String FM: Budget Period
FM_SPLIT_BATCH String Batch to group results from an PSM assignment distribution
FM_SPLIT_BEGRU String Authorization group for PSM account assignment distribution
AA_FINAL_IND String Final Account Assignment Indicator
AA_FINAL_REASON String Final Account Assignment Reason Code
AA_FINAL_QTY Decimal Final Account Assignment Quantity
AA_FINAL_QTY_F Double Final Account Assignment Quantity (Floating Point Number)
MENGE_F Double Quantity (Floating Point Number - Internal Field)
EGRUP String Equity group
VNAME String Joint Venture
TCOBJNR String Object number
DATEOFSERVICE Date Date of Service
NOTAXCORR String Do Not Consider Item in Input Tax Correction
DIFFOPTRATE Decimal Real estate option rate
HASDIFFOPTRATE String Use Different Option Rate

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



EKKO

The SAP table EKKO.

Columns

Name Type Description
MANDT [KEY] String Client
EBELN [KEY] String Purchasing Document Number
BUKRS String Company Code
BSTYP String Purchasing Document Category
BSART String Purchasing Document Type
BSAKZ String Control indicator for purchasing document type
LOEKZ String Deletion Indicator in Purchasing Document
STATU String Status of Purchasing Document
AEDAT Date Date on Which Record Was Created
ERNAM String Name of Person who Created the Object
PINCR String Item Number Interval
LPONR String Last Item Number
LIFNR String Vendor Account Number
SPRAS String Language Key
ZTERM String Terms of Payment Key
ZBD1T Decimal Cash (Prompt Payment) Discount Days
ZBD2T Decimal Cash (Prompt Payment) Discount Days
ZBD3T Decimal Cash (Prompt Payment) Discount Days
ZBD1P Decimal Cash Discount Percentage 1
ZBD2P Decimal Cash Discount Percentage 2
EKORG String Purchasing Organization
EKGRP String Purchasing Group
WAERS String Currency Key
WKURS Decimal Exchange Rate
KUFIX String Indicator: Fixing of Exchange Rate
BEDAT Date Purchasing Document Date
KDATB Date Start of Validity Period
KDATE Date End of Validity Period
BWBDT Date Closing Date for Applications
ANGDT Date Deadline for Submission of Bid/Quotation
BNDDT Date Binding Period for Quotation
GWLDT Date Warranty Date
AUSNR String Bid invitation number
ANGNR String Quotation Number
IHRAN Date Quotation Submission Date
IHREZ String Your Reference
VERKF String Responsible Salesperson at Vendor
TELF1 String Vendor
LLIEF String Supplying Vendor
KUNNR String Customer Number
KONNR String Number of Principal Purchase Agreement
ABGRU String Field Not Used
AUTLF String Complete Delivery Stipulated for Each Purchase Order
WEAKT String Indicator: Goods Receipt Message
RESWK String Supplying (Issuing) Plant in Stock Transport Order
LBLIF String Field not used
INCO1 String Incoterms (Part 1)
INCO2 String Incoterms (Part 2)
KTWRT Double Target Value for Header Area per Distribution
SUBMI String Collective Number
KNUMV String Number of the document condition
KALSM String Procedure (Pricing, Output Control, Acct. Det., Costing,...)
STAFO String Update group for statistics update
LIFRE String Different Invoicing Party
EXNUM String Number of foreign trade data in MM and SD documents
UNSEZ String Our Reference
LOGSY String Logical System
UPINC String Item Number Interval for Subitems
STAKO String Document with time-dependent conditions
FRGGR String Release group
FRGSX String Release Strategy
FRGKE String Release Indicator: Purchasing Document
FRGZU String Release status
FRGRL String Release Not Yet Completely Effected
LANDS String Country for Tax Return
LPHIS String Indicator for scheduling agreement release documentation
ADRNR String Address number
STCEG_L String Country of Sales Tax ID Number
STCEG String VAT Registration Number
ABSGR String Reason for Cancellation
ADDNR String Document number for additional
KORNR String Correction of miscellaneous provisions
MEMORY String Purchase order not yet complete
PROCSTAT String Purchasing document processing state
RLWRT Double Total value at time of release
REVNO String Version number in Purchasing
SCMPROC String SCM Process That Created the Purchase Order
REASON_CODE String Goods Receipt Reason Code
MEMORYTYPE String Category of Incompleteness
RETTP String Retention Indicator
RETPC Decimal Retention in Percent
DPTYP String Down Payment Indicator
DPPCT Decimal Down Payment Percentage
DPAMT Double Down Payment Amount in Document Currency
DPDAT Date Due Date for Down Payment
MSR_ID String Process Identification Number
HIERARCHY_EXISTS String Part of a Contract Hierarchy
THRESHOLD_EXISTS String Threshold Value for Exchange Rates Exists
LEGAL_CONTRACT String Legal Contract Number
DESCRIPTION String Contract Name
RELEASE_DATE Date Release Date of Contract
FORCE_ID String Internal Key for Force Element
FORCE_CNT String Internal (Version) Counter
RELOC_ID String Relocation ID
RELOC_SEQ_ID String Relocation Step ID
SOURCE_LOGSYS String Logical system
VZSKZ String Interest calculation indicator
POHF_TYPE String Document for Seasonal Purchase Order Processing
EQ_EINDT Date Delivery Date Header: All Items Have Same Delivery Date
EQ_WERKS String Plant Header: All Items Have Same Receiving Plant
FIXPO String Firm Deal Indicator
EKGRP_ALLOW String Take Account of Purch. Group
WERKS_ALLOW String Take Account of Plants
CONTRACT_ALLOW String Take Account of Contracts
PSTYP_ALLOW String Take Account of Item Categories
FIXPO_ALLOW String Take Account of Fixed-Date Purchases Indicator
KEY_ID_ALLOW String Consider Budget
AUREL_ALLOW String Take Account of Alloc. Table Relevance
DELPER_ALLOW String Take Account of Dlvy Period
EINDT_ALLOW String Take Account of Delivery Date
LTSNR_ALLOW String Include Vendor Subrange
OTB_LEVEL String OTB Check Level
OTB_COND_TYPE String OTB Condition Type
KEY_ID String Unique Number of Budget
OTB_VALUE Double Required Budget
OTB_CURR String OTB Currency
OTB_RES_VALUE Double Reserved Budget for OTB-Relevant Purchasing Document
OTB_SPEC_VALUE Double Special Release Budget
SPR_RSN_PROFILE String Reason Profile for OTB Special Release
BUDG_TYPE String Budget Type
OTB_STATUS String OTB Check Status
OTB_REASON String Reason Indicator for OTB Check Status
CHECK_TYPE String Type of OTB Check
CON_OTB_REQ String OTB-Relevant Contract
CON_PREBOOK_LEV String OTB Indicator Level for Contracts
CON_DISTR_LEV String Distribution Using Target Value or Item Data

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



EKPO

The SAP table EKPO.

Columns

Name Type Description
MANDT [KEY] String Client
EBELN [KEY] String Purchasing Document Number
EBELP [KEY] String Item Number of Purchasing Document
LOEKZ String Deletion Indicator in Purchasing Document
STATU String RFQ status
AEDAT Date Purchasing Document Item Change Date
TXZ01 String Short Text
MATNR String Material Number
EMATN String Material Number
BUKRS String Company Code
WERKS String Plant
LGORT String Storage Location
BEDNR String Requirement Tracking Number
MATKL String Material Group
INFNR String Number of Purchasing Info Record
IDNLF String Material Number Used by Vendor
KTMNG Decimal Target Quantity
MENGE Decimal Purchase Order Quantity
MEINS String Purchase Order Unit of Measure
BPRME String Order Price Unit (Purchasing)
BPUMZ Decimal Numerator for Conversion of Order Price Unit into Order Unit
BPUMN Decimal Denominator for Conv. of Order Price Unit into Order Unit
UMREZ Decimal Numerator for Conversion of Order Unit to Base Unit
UMREN Decimal Denominator for Conversion of Order Unit to Base Unit
NETPR Double Net Price in Purchasing Document (in Document Currency)
PEINH Decimal Price Unit
NETWR Double Net Order Value in PO Currency
BRTWR Double Gross order value in PO currency
AGDAT Date Deadline for Submission of Bid/Quotation
WEBAZ Decimal Goods Receipt Processing Time in Days
MWSKZ String Tax on sales/purchases code
BONUS String Settlement Group 1 (Purchasing)
INSMK String Stock Type
SPINF String Indicator: Update Info Record
PRSDR String Price Printout
SCHPR String Indicator: Estimated Price
MAHNZ Decimal Number of Reminders/Expediters
MAHN1 Decimal Number of Days for First Reminder/Expediter
MAHN2 Decimal Number of Days for Second Reminder/Expediter
MAHN3 Decimal Number of Days for Third Reminder/Expediter
UEBTO Decimal Overdelivery Tolerance Limit
UEBTK String Indicator: Unlimited Overdelivery Allowed
UNTTO Decimal Underdelivery Tolerance Limit
BWTAR String Valuation Type
BWTTY String Valuation Category
ABSKZ String Rejection Indicator
AGMEM String Internal Comment on Quotation
ELIKZ String "Delivery Completed" Indicator
EREKZ String Final Invoice Indicator
PSTYP String Item Category in Purchasing Document
KNTTP String Account Assignment Category
KZVBR String Consumption Posting
VRTKZ String Distribution indicator for multiple account assignment
TWRKZ String Partial Invoice Indicator
WEPOS String Goods Receipt Indicator
WEUNB String Goods Receipt, Non-Valuated
REPOS String Invoice Receipt Indicator
WEBRE String Indicator: GR-Based Invoice Verification
KZABS String Order Acknowledgment Requirement
LABNR String Order Acknowledgment Number
KONNR String Number of Principal Purchase Agreement
KTPNR String Item Number of Principal Purchase Agreement
ABDAT Date Reconciliation Date for Agreed Cumulative Quantity
ABFTZ Decimal Agreed Cumulative Quantity
ETFZ1 Decimal Firm Zone (Go-Ahead for Production)
ETFZ2 Decimal Trade-Off Zone (Go-Ahead for Materials Procurement)
KZSTU String Firm/Trade-Off Zones Binding with Regard to Mat. Planning
NOTKZ String Exclusion in Outline Agreement Item with Material Class
LMEIN String Base Unit of Measure
EVERS String Shipping Instructions
ZWERT Double Target Value for Outline Agreement in Document Currency
NAVNW Double Non-deductible input tax
ABMNG Decimal Standard release order quantity
PRDAT Date Date of Price Determination
BSTYP String Purchasing Document Category
EFFWR Double Effective value of item
XOBLR String Item affects commitments
KUNNR String Customer
ADRNR String Manual address number in purchasing document item
EKKOL String Condition Group with Vendor
SKTOF String Item Does Not Qualify for Cash Discount
STAFO String Update group for statistics update
PLIFZ Decimal Planned Delivery Time in Days
NTGEW Decimal Net Weight
GEWEI String Unit of Weight
TXJCD String Tax Jurisdiction
ETDRK String Indicator: Print-relevant schedule lines exist
SOBKZ String Special Stock Indicator
ARSNR String Settlement reservation number
ARSPS String Item number of the settlement reservation
INSNC String Quality inspection indicator cannot be changed
SSQSS String Control Key for Quality Management in Procurement
ZGTYP String Certificate Type
EAN11 String International Article Number (EAN/UPC)
BSTAE String Confirmation Control Key
REVLV String Revision Level
GEBER String Fund
FISTL String Funds Center
FIPOS String Commitment Item
KO_GSBER String Business area reported to the partner
KO_PARGB String assumed business area of the business partner
KO_PRCTR String Profit Center
KO_PPRCTR String Partner Profit Center
MEPRF String Price Determination (Pricing) Date Control
BRGEW Decimal Gross Weight
VOLUM Decimal Volume
VOLEH String Volume unit
INCO1 String Incoterms (Part 1)
INCO2 String Incoterms (Part 2)
VORAB String Advance procurement: project stock
KOLIF String Prior Vendor
LTSNR String Vendor Subrange
PACKNO String Package number
FPLNR String Invoicing plan number
GNETWR Double Currently not used
STAPO String Item is statistical
UEBPO String Higher-Level Item in Purchasing Documents
LEWED Date Latest Possible Goods Receipt
EMLIF String Vendor to be supplied/who is to receive delivery
LBLKZ String Subcontracting vendor
SATNR String Cross-Plant Configurable Material
ATTYP String Material Category
KANBA String Kanban Indicator
ADRN2 String Number of delivery address
CUOBJ String Configuration (internal object number)
XERSY String Evaluated Receipt Settlement (ERS)
EILDT Date Start Date for GR-Based Settlement
DRDAT Date Last Transmission
DRUHR Time Time
DRUNR String Sequential Number
AKTNR String Promotion
ABELN String Allocation Table Number
ABELP String Item number of allocation table
ANZPU Decimal Number of Points
PUNEI String Points unit
SAISO String Season Category
SAISJ String Season Year
EBON2 String Settlement Group 2 (Rebate Settlement, Purchasing)
EBON3 String Settlement Group 3 (Rebate Settlement, Purchasing)
EBONF String Item Relevant to Subsequent (Period-End Rebate) Settlement
MLMAA String Material ledger activated at material level
MHDRZ Decimal Minimum Remaining Shelf Life
ANFNR String RFQ Number
ANFPS String Item Number of RFQ
KZKFG String Origin of Configuration
USEQU String Quota arrangement usage
UMSOK String Special Stock Indicator for Physical Stock Transfer
BANFN String Purchase Requisition Number
BNFPO String Item Number of Purchase Requisition
MTART String Material Type
UPTYP String Subitem Category, Purchasing Document
UPVOR String Subitems Exist

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



IKPF

The SAP table IKPF.

Columns

Name Type Description
MANDT [KEY] String Client
IBLNR [KEY] String Physical Inventory Document
GJAHR [KEY] String Fiscal Year
VGART String Transaction/Event Type
WERKS String Plant
LGORT String Storage Location
SOBKZ String Special Stock Indicator
BLDAT Date Document Date in Document
GIDAT Date Planned date of inventory count
ZLDAT Date Date of last count
BUDAT Date Posting Date in the Document
MONAT String Fiscal Period
USNAM String User name
SPERR String Posting block due to physical inventory
ZSTAT String Status of count
DSTAT String Status of adjustment posting (inventory differences)
XBLNI String Reference Number for Physical Inventory
LSTAT String Status of delete flag
XBUFI String Freeze book inventory
KEORD String Type of grouping criterion
ORDNG String Grouping criterion of physical inventory document item
INVNU String Physical inventory number
IBLTXT String Description of Physical Inventory Document
INVART String Physical Inventory Type
WSTI_BSTAT String Status of Calculation of Inventory Balance at Count Time

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



ISEG

The SAP table ISEG.

Columns

Name Type Description
MANDT [KEY] String Client
IBLNR [KEY] String Physical Inventory Document
GJAHR [KEY] String Fiscal Year
ZEILI [KEY] String Line Number
MATNR String Material Number
WERKS String Plant
LGORT String Storage Location
CHARG String Batch Number
SOBKZ String Special Stock Indicator
BSTAR String Stock Type (Physical Inventory
KDAUF String Sales Order Number
KDPOS String Item Number in Sales Order
KDEIN String Delivery Schedule for Sales Order
LIFNR String Vendor Account Number
KUNNR String Account Number of Customer
PLPLA String Distribution of Differences
USNAM String Changed by
AEDAT Date Changed On
USNAZ String Counted By
ZLDAT Date Date of last count
USNAD String Adjustment posting made by
BUDAT Date Posting Date in the Document
XBLNI String Reference Number for Physical Inventory
XZAEL String Item has been counted
XDIFF String Difference posted
XNZAE String Item will be recounted
XLOEK String Item is Deleted (Physical Inventory)
XAMEI String Handling in Alternative Unit of Measure
BUCHM Decimal Book quantity immediately prior to count
XNULL String Zero count
MENGE Decimal Quantity
MEINS String Base Unit of Measure
ERFMG Decimal Quantity in unit of entry (physical inventory)
ERFME String Unit of entry (physical inventory)
MBLNR String Number of Material Document
MJAHR String Material Document Year
ZEILE String Item in Material Document
NBLNR String Number of recount document
DMBTR Double Difference amount in local currency
WAERS String Currency Key
ABCIN String Physical inventory indicator for cycle counting
PS_PSP_PNR String Work Breakdown Structure Element (WBS Element)
VKWRT Double Value at Sales Prices Including Value-Added Tax
EXVKW Double Externally Entered Sales Value in Local Currency
BUCHW Double Book value based on sales prices (SP) at time of count
KWART String Indicates that the value-only material is to be inventoried
VKWRA Double Value at sales prices excluding value-added tax
VKMZL Double Sales Value of Inv. Differences (with VAT) on Count Entry
VKNZL Double Sales Value of Inventory Difference (w/o VAT) on Count Entry
WRTZL Double Value of physical inventory count
WRTBM Double Value of book quantity
DIWZL Double Inventory difference value upon count entry
ATTYP String Material Category
GRUND String Reason for inventory diff.
SAMAT String Cross-Plant Configurable Material
XDISPATCH String Distribution of Physical Inventory Differences
DISUB_OWNER String Owner of stock
WSTI_COUNTDATE Date Date of Count During Opening Time
WSTI_COUNTTIME Time Time of Count During Opening Time
WSTI_FREEZEDATE Date Freeze Date for Inventory Balance
WSTI_FREEZETIME Time Freeze Time for Inventory Balance
WSTI_POSM Decimal Quantity to Which Book Quantity was Changed
WSTI_POSW Double Retail Value to Which Retail Book Value was Changed
WSTI_XCALC String Book Inventory Calculated at Count Time
WSTI_ENTERDATE Date Entry Date of Physical Inventory Count in System
WSTI_ENTERTIME Time Entry Time of Physical Inventory Count in System

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



KNA1

The SAP table KNA1.

Columns

Name Type Description
MANDT [KEY] String Client
KUNNR [KEY] String Customer Number
LAND1 String Country Key
NAME1 String Name 1
NAME2 String Name 2
ORT01 String City
PSTLZ String Postal Code
REGIO String Region (State, Province, County)
SORTL String Sort field
STRAS String House number and street
TELF1 String First telephone number
TELFX String Fax Number
XCPDK String Indicator: Is the account a one-time account?
ADRNR String Address
MCOD1 String Search term for matchcode search
MCOD2 String Search Term for Matchcode Search
MCOD3 String Search term for matchcode search
ANRED String Title
AUFSD String Central order block for customer
BAHNE String Express train station
BAHNS String Train station
BBBNR String International location number (part 1)
BBSNR String International location number (Part 2)
BEGRU String Authorization Group
BRSCH String Industry key
BUBKZ String Check digit for the international location number
DATLT String Data communication line no.
ERDAT Date Date on which the Record Was Created
ERNAM String Name of Person who Created the Object
EXABL String Indicator: Unloading points exist
FAKSD String Central billing block for customer
FISKN String Account number of the master record with the fiscal address
KNAZK String Working Time Calendar
KNRZA String Account number of an alternative payer
KONZS String Group key
KTOKD String Customer Account Group
KUKLA String Customer classification
LIFNR String Account Number of Vendor or Creditor
LIFSD String Central delivery block for the customer
LOCCO String City Coordinates
LOEVM String Central Deletion Flag for Master Record
NAME3 String Name 3
NAME4 String Name 4
NIELS String Nielsen ID
ORT02 String District
PFACH String PO Box
PSTL2 String P.O. Box Postal Code
COUNC String County Code
CITYC String City Code
RPMKR String Regional Market
SPERR String Central posting block
SPRAS String Language Key
STCD1 String Tax Number 1
STCD2 String Tax Number 2
STKZA String Indicator: Business Partner Subject to Equalization Tax?
STKZU String Liable for VAT
TELBX String Telebox number
TELF2 String Second telephone number
TELTX String Teletex number
TELX1 String Telex number
LZONE String Transportation zone to or from which the goods are delivered
XZEMP String Indicator: Is an alternative payer allowed in document?
VBUND String Company ID of trading partner
STCEG String VAT Registration Number
DEAR1 String Indicator: Competitor
DEAR2 String Indicator: Sales partner
DEAR3 String Indicator: Sales prospect
DEAR4 String Indicator for customer type 4
DEAR5 String ID for default sold-to party
GFORM String Legal status
BRAN1 String Industry Code 1
BRAN2 String Industry code 2
BRAN3 String Industry code 3
BRAN4 String Industry code 4
BRAN5 String Industry code 5
EKONT String Initial contact
UMSAT Double Annual sales
UMJAH String Year For Which Sales are Given
UWAER String Currency of sales figure
JMZAH String Yearly number of employees
JMJAH String Year for which the number of employees is given
KATR1 String Attribute 1
KATR2 String Attribute 2
KATR3 String Attribute 3
KATR4 String Attribute 4
KATR5 String Attribute 5
KATR6 String Attribute 6
KATR7 String Attribute 7
KATR8 String Attribute 8
KATR9 String Attribute 9
KATR10 String Attribute 10
STKZN String Natural Person
UMSA1 Double Annual sales
TXJCD String Tax Jurisdiction
PERIV String Fiscal Year Variant
ABRVW String Usage Indicator
INSPBYDEBI String Inspection Carried Out By Customer (No Inspection Lot)
INSPATDEBI String Inspection for a Delivery Note After Outbound Delivery
KTOCD String Reference Account Group for One-Time Account (Customer)
PFORT String PO Box city
WERKS String Plant
DTAMS String Indicator for Data Medium Exchange
DTAWS String Instruction key for data medium exchange
DUEFL String Status of Data Transfer into Subsequent Release
HZUOR String Assignment to Hierarchy
SPERZ String Payment Block
ETIKG String IS-R Labeling: customer/plant group
CIVVE String ID for mainly non-military use
MILVE String ID for mainly military use
KDKG1 String Customer condition group 1
KDKG2 String Customer condition group 2
KDKG3 String Customer condition group 3
KDKG4 String Customer condition group 4
KDKG5 String Customer condition group 5
XKNZA String Indicator: Alternative payer using account number
FITYP String Tax type
STCDT String Tax Number Type
STCD3 String Tax Number 3
STCD4 String Tax Number 4
STCD5 String Tax Number 5
XICMS String Customer is ICMS-exempt
XXIPI String Customer is IPI-exempt
XSUBT String Customer group for Substitui?ao Tribut?ria calculation
CFOPC String Customer
TXLW1 String Tax law: ICMS
TXLW2 String Tax law: IPI
CCC01 String Indicator for biochemical warfare for legal control
CCC02 String Indicator for nuclear nonproliferation for legal control
CCC03 String Indicator for national security for legal control
CCC04 String Indicator for missile technology for legal control
CASSD String Central sales block for customer
KNURL String Uniform Resource Locator
J_1KFREPRE String Name of Representative
J_1KFTBUS String Type of Business
J_1KFTIND String Type of Industry
CONFS String Status of Change Authorization (Central)
UPDAT Date Date on Which the Changes Were Confirmed
UPTIM Time Time of Last Change Confirmation
NODEL String Central deletion block for master record
DEAR6 String Indicator: Consumer
VSOR_PALHGT Decimal Maximum Stacking Height of the Packaging Material (VSO)
VSOR_PAL_UL String Unit of Length for Packaging Material (VSO)
VSOR_PK_MAT String Customer-Related Packing for Each Packaging Material (VSO)
VSOR_MATPAL String Packaging Material of the Customer in VSO
VSOR_I_NO_LYR String Number Layers Under an Inter-Pallet (VSO)
VSOR_ONE_MAT String Packing Material-Specific for Each Packaging Material
VSOR_ONE_SORT String Pack Only One Package Type for Each PKM (VSO)
VSOR_ULD_SIDE String Side Preference of Loading/Unloading (VSO)
VSOR_LOAD_PREF String Front/Back Preference of Loading/Unloading (VSO)
VSOR_DPOINT String Collective Unloading Point for VSO
ALC String Agency Location Code
PMT_OFFICE String Payment Office
FEE_SCHEDULE String Fee schedule
DUNS String DUNS Number
DUNS4 String DUNS+4
PSOFG String Processor group
PSOIS String Subledger acct preprocessing procedure
PSON1 String Name 1
PSON2 String Name 2
PSON3 String Name 3
PSOVN String First Name
PSOTL String Title
PSOHS String House number: is no longer used from Release 4.6B
PSOST String Street: No longer used from Release 4.6B
PSOO1 String Description
PSOO2 String Description
PSOO3 String Description
PSOO4 String Description
PSOO5 String Description

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



LFA1

The SAP table LFA1.

Columns

Name Type Description
MANDT [KEY] String Client
LIFNR [KEY] String Account Number of Vendor or Creditor
LAND1 String Country Key
NAME1 String Name 1
NAME2 String Name 2
NAME3 String Name 3
NAME4 String Name 4
ORT01 String City
ORT02 String District
PFACH String PO Box
PSTL2 String P.O. Box Postal Code
PSTLZ String Postal Code
REGIO String Region (State, Province, County)
SORTL String Sort field
STRAS String House number and street
ADRNR String Address
MCOD1 String Search term for matchcode search
MCOD2 String Search term for matchcode search
MCOD3 String Search term for matchcode search
ANRED String Title
BAHNS String Train station
BBBNR String International location number (part 1)
BBSNR String International location number (Part 2)
BEGRU String Authorization Group
BRSCH String Industry key
BUBKZ String Check digit for the international location number
DATLT String Data communication line no.
DTAMS String Indicator for Data Medium Exchange
DTAWS String Instruction key for data medium exchange
ERDAT Date Date on which the Record Was Created
ERNAM String Name of Person who Created the Object
ESRNR String ISR Subscriber Number
KONZS String Group key
KTOKK String Vendor account group
KUNNR String Customer Number
LNRZA String Account Number of the Alternative Payee
LOEVM String Central Deletion Flag for Master Record
SPERR String Central posting block
SPERM String Centrally imposed purchasing block
SPRAS String Language Key
STCD1 String Tax Number 1
STCD2 String Tax Number 2
STKZA String Indicator: Business Partner Subject to Equalization Tax?
STKZU String Liable for VAT
TELBX String Telebox number
TELF1 String First telephone number
TELF2 String Second telephone number
TELFX String Fax Number
TELTX String Teletex number
TELX1 String Telex number
XCPDK String Indicator: Is the account a one-time account?
XZEMP String Indicator: Alternative payee in document allowed ?
VBUND String Company ID of trading partner
FISKN String Account number of the master record with fiscal address
STCEG String VAT Registration Number
STKZN String Natural Person
SPERQ String Function That Will Be Blocked
GBORT String Place of birth of the person subject to withholding tax
GBDAT Date Date of birth of the person subject to withholding tax
SEXKZ String Key for the Sex of the Person Subject to Withholding Tax
KRAUS String Credit information number
REVDB Date Last review (external)
QSSYS String Vendor
KTOCK String Reference Account Group for One-Time Account (Vendor)
PFORT String PO Box city
WERKS String Plant (Own or External)
LTSNA String Indicator: vendor sub-range relevant
WERKR String Indicator: plant level relevant
PLKAL String Factory calendar key
DUEFL String Status of Data Transfer into Subsequent Release
TXJCD String Tax Jurisdiction
SPERZ String Payment Block
SCACD String Standard carrier access code
SFRGR String Forwarding agent freight group
LZONE String Transportation zone to or from which the goods are delivered
XLFZA String Indicator: Alternative payee using account number
DLGRP String Service agent procedure group
FITYP String Tax type
STCDT String Tax Number Type
REGSS String Registered for Social Insurance
ACTSS String Activity Code for Social Insurance
STCD3 String Tax Number 3
STCD4 String Tax Number 4
STCD5 String Tax Number 5
IPISP String Tax Split
TAXBS String Tax Base in Percentage
PROFS String Profession
STGDL String Shipment: statistics group, transportation service agent
EMNFR String External manufacturer code name or number
LFURL String Uniform Resource Locator
J_1KFREPRE String Name of Representative
J_1KFTBUS String Type of Business
J_1KFTIND String Type of Industry
CONFS String Status of Change Authorization (Central)
UPDAT Date Date on Which the Changes Were Confirmed
UPTIM Time Time of Last Change Confirmation
NODEL String Central deletion block for master record
QSSYSDAT Date Validity date of certification
PODKZB String Vendor indicator relevant for proof of delivery
FISKU String Account Number of Master Record of Tax Office Responsible
STENR String Tax Number at Responsible Tax Authority
CARRIER_CONF String Carrier confirmation is expected
J_SC_CAPITAL Double Capital Amount
J_SC_CURRENCY String Currency
ALC String Agency Location Code
PMT_OFFICE String Payment Office
PPA_RELEVANT String Vendor is PPA relevant
PSOFG String Processor group
PSOIS String Subledger acct preprocessing procedure
PSON1 String Name 1
PSON2 String Name 2
PSON3 String Name 3
PSOVN String First Name
PSOTL String Title
PSOHS String House number: is no longer used from Release 4.6B
PSOST String Street: No longer used from Release 4.6B
TRANSPORT_CHAIN String Transportation Chain
STAGING_TIME Decimal Staging Time in Days
SCHEDULING_TYPE String Scheduling Procedure
SUBMI_RELEVANT String Cross Docking: Relevant for Collective Numbering

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



MAKT

The SAP table MAKT.

Columns

Name Type Description
MANDT [KEY] String Client
MATNR [KEY] String Material Number
SPRAS [KEY] String Language Key
MAKTX String Material Description (Short Text)
MAKTG String Material description in upper case for matchcodes

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



MARA

The SAP table MARA.

Columns

Name Type Description
MANDT [KEY] String Client
MATNR [KEY] String Material Number
ERSDA Date Created On
ERNAM String Name of Person who Created the Object
LAEDA Date Date of Last Change
AENAM String Name of Person Who Changed Object
VPSTA String Maintenance status of complete material
PSTAT String Maintenance status
LVORM String Flag Material for Deletion at Client Level
MTART String Material Type
MBRSH String Industry sector
MATKL String Material Group
BISMT String Old material number
MEINS String Base Unit of Measure
BSTME String Purchase Order Unit of Measure
ZEINR String Document number (without document management system)
ZEIAR String Document type (without Document Management system)
ZEIVR String Document version (without Document Management system)
ZEIFO String Page format of document (without Document Management system)
AESZN String Document change number (without document management system)
BLATT String Page number of document (without Document Management system)
BLANZ String Number of sheets (without Document Management system)
FERTH String Production/inspection memo
FORMT String Page Format of Production Memo
GROES String Size/dimensions
WRKST String Basic Material
NORMT String Industry Standard Description (such as ANSI or ISO)
LABOR String Laboratory/design office
EKWSL String Purchasing Value Key
BRGEW Decimal Gross Weight
NTGEW Decimal Net Weight
GEWEI String Weight Unit
VOLUM Decimal Volume
VOLEH String Volume unit
BEHVO String Container requirements
RAUBE String Storage conditions
TEMPB String Temperature conditions indicator
DISST String Low-Level Code
TRAGR String Transportation Group
STOFF String Hazardous material number
SPART String Division
KUNNR String Competitor
EANNR String European Article Number (EAN) - obsolete!!!!!
WESCH Decimal Quantity: Number of GR/GI slips to be printed
BWVOR String Procurement rule
BWSCL String Source of Supply
SAISO String Season Category
ETIAR String Label type
ETIFO String Label form
ENTAR String Deactivated
EAN11 String International Article Number (EAN/UPC)
NUMTP String Category of International Article Number (EAN)
LAENG Decimal Length
BREIT Decimal Width
HOEHE Decimal Height
MEABM String Unit of Dimension for Length/Width/Height
PRDHA String Product hierarchy
AEKLK String Stock Transfer Net Change Costing
CADKZ String CAD Indicator
QMPUR String QM in Procurement is Active
ERGEW Decimal Allowed packaging weight
ERGEI String Unit of weight (allowed packaging weight)
ERVOL Decimal Allowed packaging volume
ERVOE String Volume unit (allowed packaging volume)
GEWTO Decimal Excess Weight Tolerance for Handling unit
VOLTO Decimal Excess Volume Tolerance of the Handling Unit
VABME String Variable Purchase Order Unit Active
KZREV String Revision Level Has Been Assigned to the Material
KZKFG String Configurable Material
XCHPF String Batch management requirement indicator
VHART String Packaging Material Type
FUELG Decimal Maximum level (by volume)
STFAK Int Stacking factor
MAGRV String Material Group: Packaging Materials
BEGRU String Authorization Group
DATAB Date Valid-From Date
LIQDT Date Deletion date
SAISJ String Season Year
PLGTP String Price Band Category
MLGUT String Empties Bill of Material
EXTWG String External Material Group
SATNR String Cross-Plant Configurable Material
ATTYP String Material Category
KZKUP String Indicator: Material can be co-product
KZNFM String Indicator: The material has a follow-up material
PMATA String Pricing Reference Material
MSTAE String Cross-Plant Material Status
MSTAV String Cross-distribution-chain material status
MSTDE Date Date from which the cross-plant material status is valid
MSTDV Date Date from which the X-distr.-chain material status is valid
TAKLV String Tax classification of the material
RBNRM String Catalog Profile
MHDRZ Decimal Minimum Remaining Shelf Life
MHDHB Decimal Total shelf life
MHDLP Decimal Storage percentage
INHME String Content unit
INHAL Decimal Net contents
VPREH Decimal Comparison price unit
ETIAG String IS-R Labeling: material grouping (deactivated in 4.0)
INHBR Decimal Gross contents
CMETH String Quantity Conversion Method
CUOBF String Internal object number
KZUMW String Environmentally Relevant
KOSCH String Product allocation determination procedure
SPROF String Pricing profile for variants
NRFHG String Material qualifies for discount in kind
MFRPN String Manufacturer Part Number
MFRNR String Number of a Manufacturer
BMATN String Number of firm
MPROF String Manufacturer Part Profile
KZWSM String Units of measure usage
SAITY String Rollout in a Season
PROFL String Dangerous Goods Indicator Profile
IHIVI String Indicator: Highly Viscous
ILOOS String Indicator: In Bulk/Liquid
SERLV String Level of Explicitness for Serial Number
KZGVH String Packaging Material is Closed Packaging
XGCHP String Indicator: Approved batch record required
KZEFF String Assign effectivity parameter values/ override change numbers
COMPL String Material completion level
IPRKZ String Period Indicator for Shelf Life Expiration Date
RDMHD String Rounding rule for calculation of SLED
PRZUS String Indicator: Product composition printed on packaging
MTPOS_MARA String General item category group
BFLME String Generic Material with Logistical Variants
MATFI String Material Is Locked
CMREL String Relevant for Configuration Management
BBTYP String Assortment List Type
SLED_BBD String Expiration Date
GTIN_VARIANT String Global Trade Item Number Variant
GENNR String Material Number of the Generic Material in Prepack Materials
RMATP String Reference material for materials packed in same way
GDS_RELEVANT String Indicator: Global Data Synchronization-Relevant
WEORA String Acceptance At Origin
HUTYP_DFLT String Standard HU Type
PILFERABLE String Pilferable
WHSTC String Warehouse Storage Condition
WHMATGR String Warehouse Material Group
HNDLCODE String Handling Indicator
HAZMAT String Relevant for Hazardous Substances
HUTYP String Handling Unit Type
TARE_VAR String Variable Tare Weight
MAXC Decimal Maximum Allowed Capacity of Packaging Material
MAXC_TOL Decimal Overcapacity Tolerance of the Handling Unit
MAXL Decimal Maximum Packing Length of Packaging Material
MAXB Decimal Maximum Packing Width of Packaging Material
MAXH Decimal Maximum Packing Height of Packaging Material
MAXDIM_UOM String Unit of Measure for Maximum Packing Length/Width/Height
HERKL String Country of origin of the material
MFRGR String Material freight group
QQTIME Decimal Quarantine Period
QQTIMEUOM String Time Unit for Quarantine Period
QGRP String Quality Inspection Group
SERIAL String Serial Number Profile
PS_SMARTFORM String Form Name
LOGUNIT String EWM CW: Logistics Unit of Measure
CWQREL String EWM CW: Material Is a Catch Weight Material
CWQPROC String EWM CW: Catch Weight Profile for Entering CW Quantity
CWQTOLGR String EWM-CW: Catch Weight Tolerance Group for EWM
ADPROF String Adjustment Profile
IPMIPPRODUCT String ID for an Intellectual Property (CRM Product)
ALLOW_PMAT_IGNO String Variant Price Allowed (for Material Master)
MEDIUM String Medium
BEV1LULEINH String Loading Units
BEV1LULDEGRP String Loading Unit Group: IS Beverage
BEV1NESTRUCCAT String Structure Category for Material Relationship
DSDSL_TOLTYP String Tolerance Type ID
DSDSV_CNT_GRP String Counting Group
DSDVC_GROUP String DSD Grouping
VSOR_TILT_IND String Material may be Tilted (Vehicle Space Optimization)
VSOR_STACK_IND String Stacking not Allowed (VSO)
VSOR_BOT_IND String Bottom Layer (Vehicle Space Optimization)
VSOR_TOP_IND String Top Layer (VSO)
VSOR_STACK_NO String Stacking Factor (Vehicle Space Optimization)
VSOR_PAL_IND String Load without Packaging Material (VSO)
VSOR_PAL_OVR_D Decimal Permissible Overhang (Depth) of Packaging Material (VSO)
VSOR_PAL_OVR_W Decimal Permissible Overhang (Width) of Shipping Material (VSO)
VSOR_PAL_B_HT Decimal Maximum Stacking Height of the Packaging Material (VSO)
VSOR_PAL_MIN_H Decimal Minimum Stacking Height of the Packaging Material (VSO)
VSOR_TOL_B_HT Decimal Tolerance to Exceed the Max. Stacking Height (VSO)
VSOR_NO_P_GVH String Number of Materials for each Closed PKM (VSO)
VSOR_QUAN_UNIT String Unit of Measure Vehicle Space Optimization
VSOR_KZGVH_IND String Closed Packaging Material Required (VSO)
PACKCODE String Packaging Code
DG_PACK_STATUS String Dangerous Goods Packaging Status
MCOND String Material Condition Management
RETDELC String Return Code
LOGLEV_RETO String Return to Logistics Level
NSNID String NATO Stock Number
ADSPC_SPC String Spare Part Class Code
IMATN String FFF class
PICNUM String Supersession chain number
BSTAT String Creation Status - Seasonal Procurement
COLOR_ATINN String Internal Charactieristic Number for Color Characteristics
SIZE1_ATINN String Internal Char. Number for Characteristics for Main Sizes
SIZE2_ATINN String Internal Char. Number for Characteristics for Second Sizes
COLOR String Characteristic Value for Colors of Variants
SIZE1 String Characteristic Value for Main Sizes of Variants
SIZE2 String Characteristic Value for Second Size for Variants
FREE_CHAR String Characteristic Value for Evaluation Purposes
CARE_CODE String Care Codes (such as Washing Code, Ironing Code, etc.)
BRAND_ID String Brand
FIBER_CODE1 String Fiber Code for Textiles (Component 1)
FIBER_PART1 String Percentage Share of Fiber (Component 1)
FIBER_CODE2 String Fiber Code for Textiles (Component 2)
FIBER_PART2 String Percentage Share of Fiber (Component 2)
FIBER_CODE3 String Fiber Code for Textiles (Component 3)
FIBER_PART3 String Percentage Share of Fiber (Component 3)
FIBER_CODE4 String Fiber Code for Textiles (Component 4)
FIBER_PART4 String Percentage Share of Fiber (Component 4)
FIBER_CODE5 String Fiber Code for Textiles (Component 5)
FIBER_PART5 String Percentage Share of Fiber (Component 5)
FASHGRD String Fashion Grade

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



MARC

The SAP table MARC.

Columns

Name Type Description
MANDT [KEY] String Client
MATNR [KEY] String Material Number
WERKS [KEY] String Plant
PSTAT String Maintenance status
LVORM String Flag Material for Deletion at Plant Level
BWTTY String Valuation Category
XCHAR String Batch management indicator (internal)
MMSTA String Plant-Specific Material Status
MMSTD Date Date from which the plant-specific material status is valid
MAABC String ABC Indicator
KZKRI String Indicator: Critical part
EKGRP String Purchasing Group
AUSME String Unit of issue
DISPR String Material: MRP profile
DISMM String MRP Type
DISPO String MRP Controller (Materials Planner)
KZDIE String Indicator: MRP controller is buyer (deactivated)
PLIFZ Decimal Planned Delivery Time in Days
WEBAZ Decimal Goods Receipt Processing Time in Days
PERKZ String Period Indicator
AUSSS Decimal Assembly scrap in percent
DISLS String Lot size (materials planning)
BESKZ String Procurement Type
SOBSL String Special procurement type
MINBE Decimal Reorder Point
EISBE Decimal Safety Stock
BSTMI Decimal Minimum Lot Size
BSTMA Decimal Maximum Lot Size
BSTFE Decimal Fixed lot size
BSTRF Decimal Rounding value for purchase order quantity
MABST Decimal Maximum stock level
LOSFX Double Ordering costs
SBDKZ String Dependent requirements ind. for individual and coll. reqmts
LAGPR String Storage costs indicator
ALTSL String Method for Selecting Alternative Bills of Material
KZAUS String Discontinuation indicator
AUSDT Date Effective-Out Date
NFMAT String Follow-Up Material
KZBED String Indicator for Requirements Grouping
MISKZ String Mixed MRP indicator
FHORI String Scheduling Margin Key for Floats
PFREI String Indicator: automatic fixing of planned orders
FFREI String Release indicator for production orders
RGEKZ String Indicator: Backflush
FEVOR String Production Supervisor
BEARZ Decimal Processing time
RUEZT Decimal Setup and teardown time
TRANZ Decimal Interoperation time
BASMG Decimal Base quantity
DZEIT Decimal In-house production time
MAXLZ Decimal Maximum Storage Period
LZEIH String Unit for maximum storage period
KZPRO String Indicator: withdrawal of stock from production bin
GPMKZ String Indicator: Material Included in Rough-Cut Planning
UEETO Decimal Overdelivery tolerance limit
UEETK String Indicator: Unlimited Overdelivery Allowed
UNETO Decimal Underdelivery tolerance limit
WZEIT Decimal Total replenishment lead time (in workdays)
ATPKZ String Replacement part
VZUSL Decimal Surcharge factor for cost in percent
HERBL String State of manufacture
INSMK String Post to Inspection Stock
SPROZ Decimal Sample for quality inspection (in %) (deactivated)
QUAZT Decimal Quarantine period (deactivated)
SSQSS String Control Key for Quality Management in Procurement
MPDAU Decimal Mean inspection duration (deactivated)
KZPPV String Indicator for inspection plan (deactivated)
KZDKZ String Documentation required indicator
WSTGH Decimal Active substance content (deactivated)
PRFRQ Decimal Interval until next recurring inspection
NKMPR Date Date according to check sampling inspection (deactivated)
UMLMC Decimal Stock in Transfer (Plant to Plant)
LADGR String Loading Group
XCHPF String Batch management requirement indicator
USEQU String Quota arrangement usage
LGRAD Decimal Service level
AUFTL String Splitting Indicator
PLVAR String Plan Version
OTYPE String Object Type
OBJID String Object ID
MTVFP String Checking Group for Availability Check
PERIV String Fiscal Year Variant
KZKFK String Indicator: take correction factors into account
VRVEZ Decimal Shipping setup time
VBAMG Decimal Base quantity for capacity planning in shipping
VBEAZ Decimal Shipping processing time
LIZYK String Deactivated
BWSCL String Source of Supply
KAUTB String Indicator: "automatic purchase order allowed"
KORDB String Indicator: Source list requirement
STAWN String Commodity Code/Import Code Number for Foreign Trade
HERKL String Country of origin of the material
HERKR String Region of origin of material (non-preferential origin)
EXPME String Unit of measure for commodity code (foreign trade)
MTVER String Export/import material group
PRCTR String Profit Center
TRAME Decimal Stock in Transit
MRPPP String PPC planning calendar
SAUFT String Ind.: Repetitive mfg allowed
FXHOR String Planning time fence
VRMOD String Consumption mode
VINT1 String Consumption period: backward
VINT2 String Consumption period: forward
VERKZ String Version Indicator
STLAL String Alternative BOM
STLAN String BOM Usage
PLNNR String Key for Task List Group
APLAL String Group Counter
LOSGR Decimal Lot Size for Product Costing
SOBSK String Special Procurement Type for Costing
FRTME String Production unit
LGPRO String Issue Storage Location
DISGR String MRP Group
KAUSF Decimal Component scrap in percent
QZGTP String Certificate Type
QMATV String Inspection Setup Exists for Material/Plant
TAKZT Decimal Takt time
RWPRO String Range of coverage profile
COPAM String Local field name for CO/PA link to SOP
ABCIN String Physical inventory indicator for cycle counting
AWSLS String Variance Key
SERNP String Serial Number Profile
CUOBJ String Internal object number
STDPD String Configurable material
SFEPR String Repetitive manufacturing profile
XMCNG String Negative stocks allowed in plant
QSSYS String Required QM System for Vendor
LFRHY String Planning cycle
RDPRF String Rounding Profile
VRBMT String Reference material for consumption
VRBWK String Reference plant for consumption
VRBDT Date To date of the material to be copied for consumption
VRBFK Decimal Multiplier for reference material for consumption
AUTRU String Reset Forecast Model Automatically
PREFE String Preference indicator in export/import
PRENC String Exemption certificate: Indicator for legal control
PRENO String Exemption certificate number for legal control
PREND Date Exemption certificate: Issue date of exemption certificate
PRENE String Indicator: Vendor declaration exists
PRENG Date Validity date of vendor declaration
ITARK String Indicator: Military goods
SERVG String IS-R service level
KZKUP String Indicator: Material can be co-product
STRGR String Planning strategy group
CUOBV String Internal object number of configurable material for planning
LGFSB String Default storage location for external procurement
SCHGT String Indicator: Bulk Material
CCFIX String CC indicator is fixed
EPRIO String Stock determination group
QMATA String Material Authorization Group for Activities in QM
RESVP Decimal Period of adjustment for planned independent requirements
PLNTY String Task List Type
UOMGR String Unit of Mearsure Group (Oil, Natural Gas,...)
UMRSL String Conversion Group (Oil, Natural Gas,..)
ABFAC Decimal Air Bouyancy Factor
SFCPF String Production Scheduling Profile
SHFLG String Safety time indicator (with or without safety time)
SHZET String Safety time (in workdays)
MDACH String Action control: planned order processing
KZECH String Determination of batch entry in the production/process order
MEGRU String Unit of Measure Group
MFRGR String Material freight group
VKUMC Double Stock transfer sales value (plant to plant) for VO material
VKTRW Double Transit value at sales price for value-only material
KZAGL String Indicator: smooth promotion consumption
FVIDK String Production Version To Be Costed
FXPRU String Fixed-Price Co-Product
LOGGR String Logistics handling group for workload calculation
FPRFM String Distribution profile of material in plant
GLGMG Decimal Tied Empties Stock
VKGLG Double Sales value of tied empties stock
INDUS String Material CFOP category
MOWNR String CAP: Number of CAP products list
MOGRU String Common Agricultural Policy: CAP products group-Foreign Trade
CASNR String CAS number for pharmaceutical products in foreign trade
GPNUM String Production statistics: PRODCOM number for foreign trade
STEUC String Control code for consumption taxes in foreign trade
FABKZ String Indicator: Item Relevant to JIT Delivery Schedules
MATGR String Group of Materials for Transition Matrix
VSPVB String Proposed Supply Area in Material Master Record
DPLFS String Fair share rule
DPLPU String Indicator: push distribution
DPLHO Decimal Deployment horizon in days
MINLS Decimal Minimum lot size for Supply Demand Match
MAXLS Decimal Maximum lot size for Supply Demand Match
FIXLS Decimal Fixed lot size for Supply Demand Match
LTINC Decimal Lot size increment for Supply Demand Match
COMPL String This field is no longer used
CONVT String Conversion types for production figures
SHPRO String Period Profile for Safety Time
AHDIS String MRP relevancy for dependent requirements
DIBER String Indicator: MRP area exists
KZPSP String Indicator for cross-project material
OCMPF String Overall profile for order change management
APOKZ String Indicator: Is material relevant for APO
MCRUE String MARDH rec. already exists for per. before last of MARD per.
LFMON String Current period (posting period)
LFGJA String Fiscal Year of Current Period
EISLO Decimal Minimum Safety Stock
NCOST String Do Not Cost
ROTATION_DATE String Strategy for Putaway and Stock Removal
UCHKZ String Indicator for Original Batch Management
UCMAT String Reference Material for Original Batches
BWESB Decimal Valuated Goods Receipt Blocked Stock
MRSSPROF_GUID String GUID in
MRSSPROF_KEY String Profile Key
MRSSDATACHANGE String Data was changed in the controls on the user screen
SAPMPTOLPRPL Decimal Percentage Tolerance Plus
SAPMPTOLPRMI Decimal Percentage Tolerance Minus
VSOR_PKGRP String Packing Group of the Material (VSO)
VSOR_LANE_NUM String Line within the Automatic Picking Zone (VSO)
VSOR_PAL_VEND String Material No. of the Packaging Material of the Vendor (VSO)
VSOR_FORK_DIR String Pick Packaging Materials only Lengthwise (VSO)
IUID_RELEVANT String IUID-Relevant
IUID_TYPE String Structure Type of UII
UID_IEA String External Allocation of UII
CONS_PROCG String Consignment Control
GI_PR_TIME Decimal Goods Issue Processing Time in Days
MULTIPLE_EKGRP String Purchasing Across Purchasing Group
REF_SCHEMA String Reference Determination Schema
MIN_TROC String Minimum Target Range of Coverage
MAX_TROC String Maximum Target Range of Coverage
TARGET_STOCK Decimal Target Stock

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



MARD

The SAP table MARD.

Columns

Name Type Description
MANDT [KEY] String Client
MATNR [KEY] String Material Number
WERKS [KEY] String Plant
LGORT [KEY] String Storage Location
PSTAT String Maintenance status
LVORM String Flag Material for Deletion at Storage Location Level
LFGJA String Fiscal Year of Current Period
LFMON String Current period (posting period)
SPERR String Physical Inventory Blocking Indicator
LABST Decimal Valuated Unrestricted-Use Stock
UMLME Decimal Stock in transfer (from one storage location to another)
INSME Decimal Stock in Quality Inspection
EINME Decimal Total Stock of All Restricted Batches
SPEME Decimal Blocked Stock
RETME Decimal Blocked Stock Returns
VMLAB Decimal Valuated unrestricted-use stock in previous period
VMUML Decimal Stock in Transfer in Previous Period
VMINS Decimal Stock in Quality Inspection in Previous Period
VMEIN Decimal Restricted-Use Stock in Previous Period
VMSPE Decimal Blocked stock of previous period
VMRET Decimal Blocked Stock Returns in Previous Period
KZILL String Physical inventory indicator for whse stock in current year
KZILQ String Phys. inventory ind. f. stock in qual. insp. in current year
KZILE String Physical inventory indicator for restricted-use stock
KZILS String Physical inventory indicator for blocked stock
KZVLL String Physical inventory indicator for stock in previous year
KZVLQ String Phys. inventory ind. f. stock in qual. insp. in prev. period
KZVLE String Physical inventory ind. for restricted-use stock, prev.pd
KZVLS String Phys. inventory indicator for blocked stock in prev. period
DISKZ String Storage location MRP indicator
LSOBS String Special procurement type at storage location level
LMINB Decimal Reorder point for storage location MRP
LBSTF Decimal Replenishment quantity for storage location MRP
HERKL String Country of origin of the material
EXPPG String Preference indicator (deactivated)
EXVER String Export indicator (deactivated)
LGPBE String Storage Bin
KLABS Decimal Unrestricted-Use Consignment Stock
KINSM Decimal Consignment Stock in Quality Inspection
KEINM Decimal Restricted-Use Consignment Stock
KSPEM Decimal Blocked Consignment Stock
DLINL Date Date of Last Posted Count for Unrestricted-Use Stock
PRCTL String Profit Center
ERSDA Date Created On
VKLAB Double Stock value of a value-only material at sales price
VKUML Double Sales value in stock transfer (SLOc to SLoc)
LWMKB String Picking area for lean WM
BSKRF Double Inventory correction factor
MDRUE String MARDH rec. already exists for per. before last of MARD per.
MDJIN String Fiscal year of current physical inventory indicator

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



SearchFunctions

A list of SAP functions available in your system.

Columns

Name Type Description
Name String The name of the function.
Group String The group name for the function.
Filter String The filter you are using to search for functions with.

The default value is RFC*.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



SKB1

The SAP table SKB1.

Columns

Name Type Description
MANDT [KEY] String Client
BUKRS [KEY] String Company Code
SAKNR [KEY] String G/L Account Number
BEGRU String Authorization Group
BUSAB String Accounting clerk
DATLZ Date Date of the last interest calculation run
ERDAT Date Date on which the Record Was Created
ERNAM String Name of Person who Created the Object
FDGRV String Planning group
FDLEV String Planning level
FIPLS String Financial Budget Item
FSTAG String Field status group
HBKID String Short Key for a House Bank
HKTID String ID for account details
KDFSL String Key for Exchange Rate Differences in Foreign Currency Accts
MITKZ String Account is reconciliation account
MWSKZ String Tax Category in Account Master Record
STEXT String G/L account additional text
VZSKZ String Interest calculation indicator
WAERS String Account currency
WMETH String Indicator: account managed in external system
XGKON String Cash receipt account / cash disbursement account
XINTB String Indicator: Is account only posted to automatically?
XKRES String Indicator: Can Line Items Be Displayed by Account?
XLOEB String Indicator: Account marked for deletion?
XNKON String Indicator: Supplement for automatic postings ?
XOPVW String Indicator: Open item management?
XSPEB String Indicator: Is Account Blocked for Posting?
ZINDT Date Key date of the last interest calculation
ZINRT String Interest calculation frequency in months
ZUAWA String Key for sorting according to assignment numbers
ALTKT String Alternative account number in company code
XMITK String Indicator: Reconcil.acct ready for input at time of posting?
RECID String Recovery Indicator
FIPOS String Commitment Item
XMWNO String Indicator: Tax code is not a required field
XSALH String Indicator: Only Manage Balances in Local Currency
BEWGP String Valuation Group
INFKY String Inflation Key
TOGRU String Tolerance Group for G/L Accounts
XLGCLR String Clearing Specific to Ledger Groups
MCAKEY String MCA Key

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



T000

The SAP table T000.

Columns

Name Type Description
MANDT [KEY] String Client
MTEXT String Client name
ORT01 String City
MWAER String Standard currency throughout client
ADRNR String Character Field Length = 10
CCCATEGORY String Client control: Role of client (production, test,...)
CCCORACTIV String Changes and transports for client-specific objects
CCNOCLIIND String Maintenance authorization for objects in all clients
CCCOPYLOCK String Protection reg. client copy program and comparison tools
CCNOCASCAD String Client control: No client cascade for upgrade import
CCSOFTLOCK String Client control: Soft Lock Required (Planned for 4.0)
CCORIGCONT String Recording Client for Switch BC Sets
CCIMAILDIS String Client Control: CATT und eCATT Authorization
CCTEMPLOCK String Client control: Indicator that client is temporarily locked
CHANGEUSER String Last Changed by
CHANGEDATE Date Date of Last Change
LOGSYS String Logical system

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



T001

The SAP table T001.

Columns

Name Type Description
MANDT [KEY] String Client
BUKRS [KEY] String Company Code
BUTXT String Name of Company Code or Company
ORT01 String City
LAND1 String Country Key
WAERS String Currency Key
SPRAS String Language Key
KTOPL String Chart of Accounts
WAABW String Maximum exchange rate deviation in percent
PERIV String Fiscal Year Variant
KOKFI String Allocation Indicator
RCOMP String Company
ADRNR String Address
STCEG String VAT Registration Number
FIKRS String Financial Management Area
XFMCO String Indicator: Project Cash Management active?
XFMCB String Indicator: Cash budget management active
XFMCA String Activate Update in Funds Management
TXJCD String Jurisdiction for tax calculation - tax jurisdiction code
FMHRDATE Date Funds center can be assigned to an account in HR from
BUVAR String Company Code Variant (Screen)
FDBUK String Cash Management and Forecast Company Code
XFDIS String Indicator: Cash Management activated?
XVALV String Indicator: Propose current date as value date ?
XSKFN String Indicator: Discount base amount is the net value
KKBER String Credit control area
XMWSN String Indicator: Base amount for tax is net of discount ?
MREGL String Rules for Copying from the Sample Account for G/L Accounts
XGSBE String Indicator: Business area financial statements required?
XGJRV String Indicator: Propose fiscal year ?
XKDFT String Indicator: Post translations for exchange rate differences ?
XPROD String Indicator: Productive company code?
XEINK String Indicator: Purchase Account Processing is Active
XJVAA String Indicator: JVA Active
XVVWA String Indicator: Financial Assets Management active
XSLTA String Indicator: No ex.rate difference when clearing in local crcy
XFDMM String Indicator: Updating MM in Cash Mgmt/Forecast activated?
XFDSD String Indicator: Updating SD in Cash Mgmt/Forecast activated?
XEXTB String Indicator: Company code is in another system
EBUKR String Original Key of the Company Code
KTOP2 String Chart of Accounts According to Country Legislation
UMKRS String Sales/Purchases Tax Group
BUKRS_GLOB String Name of global company code
FSTVA String Field Status Variant
OPVAR String Posting Period Variant
XCOVR String Indicator: hedge request active
TXKRS String Foreign Currency Translation for Tax Items
WFVAR String Workflow variant
XBBBF String G/L account authorization check in inventory management
XBBBE String G/L account authorization check in PO/scheduling agreement
XBBBA String G/L account authorization check in purchase requisitions
XBBKO String G/L account authorization check in contracts
XSTDT String Indicator: Document date as the basis for tax determination
MWSKV String Input Tax Code for Non-Taxable Transactions
MWSKA String Output Tax Code for Non-Taxable Transactions
IMPDA String Foreign Trade: Import Data Control in MM Purchase Orders
XNEGP String Indicator: Negative Postings Permitted
XKKBI String Indicator: Can credit control area be overwritten?
WT_NEWWT String Indicator: Extended withholding tax active
PP_PDATE String Procedure for Setting the Posting Date
INFMT String Inflation Method
FSTVARE String Funds reservation field status var.
KOPIM String Foreign trade: Import data copying control for GR
DKWEG String Foreign Trade: Screen ctrl of imp.data f. MM-goods rececipt
OFFSACCT String Method for offsetting account determination
BAPOVAR String Additional settings variant for bus.area financial statemnts
XCOS String Cost of sales accounting status
XCESSION String Accounts Receivable Pledging Active
XSPLT String Enable Amount Split
SURCCM String Surcharge Calculation Method
DTPROV String Document Type for Provisions for Taxes on Services Received
DTAMTC String Document Type for Journal Voucher (Amount Correction)
DTTAXC String Document Type for Journal Voucher (Tax Code Correction)
DTTDSP String Document Type for Remittance Challans
DTAXR String Deferred Tax Rule
XVATDATE String Tax Reporting Date Active in Documents
PST_PER_VAR String Manage Variant of Posting Period for Company Code/Ledger
XBBSC String G/L account authorization check in shopping cart
FM_DERIVE_ACC String Activate Account Assignment Derivation in Funds Management

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



T001W

The SAP table T001W.

Columns

Name Type Description
MANDT [KEY] String Client
WERKS [KEY] String Plant
NAME1 String Name
BWKEY String Valuation Area
KUNNR String Customer number of plant
LIFNR String Vendor number of plant
FABKL String Factory calendar key
NAME2 String Name 2
STRAS String House number and street
PFACH String PO Box
PSTLZ String Postal Code
ORT01 String City
EKORG String Purchasing Organization
VKORG String Sales organization for intercompany billing
CHAZV String Indicator: batch status management active
KKOWK String Indicator: Conditions at plant level
KORDB String Indicator: Source list requirement
BEDPL String Activating requirements planning
LAND1 String Country Key
REGIO String Region (State, Province, County)
COUNC String County Code
CITYC String City Code
ADRNR String Address
IWERK String Maintenance Planning Plant
TXJCD String Tax Jurisdiction
VTWEG String Distribution channel for intercompany billing
SPART String Division for intercompany billing
SPRAS String Language Key
WKSOP String SOP plant
AWSLS String Variance Key
CHAZV_OLD String Indicator: batch status management active
VLFKZ String Plant category
BZIRK String Sales district
ZONE1 String Supply region (region supplied)
TAXIW String Tax Indicator: Plant (Purchasing)
BZQHL String Take regular vendor into account
LET01 Decimal Number of Days for First Reminder/Expediter
LET02 Decimal Number of Days for Second Reminder/Expediter
LET03 Decimal Number of Days for Third Reminder/Expediter
TXNAM_MA1 String Text name of 1st dunning of vendor declarations
TXNAM_MA2 String Text name of the 2nd dunning of vendor declarations
TXNAM_MA3 String Text name of 3rd dunning of vendor declarations
BETOL String Number of days for PO tolerance - Compress info records - SU
J_1BBRANCH String Business Place
VTBFI String Rule for determining the sales area for stock transfers
FPRFW String Distribution profile at plant level
ACHVM String Central archiving marker for master record
DVSART String Batch Record: Type of DMS Used
NODETYPE String Node type: supply chain network
NSCHEMA String Structure for name formation
PKOSA String Cost Object Controlling linking active
MISCH String Updating is active for mixed costing
MGVUPD String Updating is active in actual costing
VSTEL String Shipping Point/Receiving Point
MGVLAUPD String Update of Activity Consumption in the Quantity Structure
MGVLAREVAL String Control of Credit of Cost Centers
SOURCING String Invoke Added-Function Source Determination via ATP
OILIVAL String Exchange valuation indicator
OIHVTYPE String Vendor type (refinery/mill/other) (Brazil)
OIHCREDIPI String IPI credit allowed
STORETYPE String Store Category to Differentiate Store, Dep. Store, Shop
DEP_STORE String Superior Department Store

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



T880

The SAP table T880.

Columns

Name Type Description
MANDT [KEY] String Client
RCOMP [KEY] String Company
NAME1 String Company name
CNTRY String Country of company
NAME2 String Name of company 2
LANGU String Language Key
STRET String Street address of the company
POBOX String Post office box of the company
PSTLC String Global company zip code
CITY String City where company is located
CURR String Local currency
MODCP String Global company grouping code
GLSIP String Write line items
RESTA String Legal status of company
RFORM String Legal form of company
ZWEIG String Industrial sector
MCOMP String Master data company code
MCLNT String Master data client
LCCOMP String Consolidation company indicator
STRT2 String Street of company 2
INDPO String Read purchase order

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



TFTIT

The SAP table TFTIT.

Columns

Name Type Description
SPRAS [KEY] String Language Key
FUNCNAME [KEY] String Name of Function Module
STEXT String Short text for function module

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



VBAK

The SAP table VBAK.

Columns

Name Type Description
MANDT [KEY] String Client
VBELN [KEY] String Sales Document
ERDAT Date Date on Which Record Was Created
ERZET Time Entry time
ERNAM String Name of Person who Created the Object
ANGDT Date Quotation/Inquiry is valid from
BNDDT Date Date until which bid/quotation is binding (valid-to date)
AUDAT Date Document Date (Date Received/Sent)
VBTYP String SD document category
TRVOG String Transaction group
AUART String Sales Document Type
AUGRU String Order reason (reason for the business transaction)
GWLDT Date Guarantee date
SUBMI String Collective number (SD)
LIFSK String Delivery block (document header)
FAKSK String Billing block in SD document
NETWR Double Net Value of the Sales Order in Document Currency
WAERK String SD Document Currency
VKORG String Sales Organization
VTWEG String Distribution Channel
SPART String Division
VKGRP String Sales Group
VKBUR String Sales Office
GSBER String Business Area
GSKST String Business area from cost center
GUEBG Date Valid-from date (outline agreements, product proposals)
GUEEN Date Valid-to date (outline agreements, product proposals)
KNUMV String Number of the document condition
VDATU Date Requested delivery date
VPRGR String Proposed date type
AUTLF String Complete delivery defined for each sales order?
VBKLA String Original system with release and transaction control
VBKLT String SD document indicator
KALSM String Sales and Distribution: Pricing Procedure in Pricing
VSBED String Shipping Conditions
FKARA String Proposed billing type for an order-related billing document
AWAHR String Sales probability
KTEXT String Search term for product proposal
BSTNK String Customer purchase order number
BSARK String Customer purchase order type
BSTDK Date Customer purchase order date
BSTZD String Purchase order number supplement
IHREZ String Your Reference
BNAME String Name of orderer
TELF1 String Telephone Number
MAHZA Decimal Number of contacts from the customer
MAHDT Date Last customer contact date
KUNNR String Sold-to party
KOSTL String Cost Center
STAFO String Update group for statistics update
STWAE String Statistics currency
AEDAT Date Changed On
KVGR1 String Customer group 1
KVGR2 String Customer group 2
KVGR3 String Customer group 3
KVGR4 String Customer group 4
KVGR5 String Customer group 5
KNUMA String Agreement (various conditions grouped together)
KOKRS String Controlling Area
PS_PSP_PNR String Work Breakdown Structure Element (WBS Element)
KURST String Exchange Rate Type
KKBER String Credit control area
KNKLI String Customer
GRUPP String Customer Credit Group
SBGRP String Credit representative group for credit management
CTLPC String Credit management: Risk category
CMWAE String Currency key of credit control area
CMFRE Date Release date of the document determined by credit management
CMNUP Date Date of next credit check of document
CMNGV Date Next date
AMTBL Double Released credit value of the document
HITYP_PR String Hierarchy type for pricing
ABRVW String Usage Indicator
ABDIS String MRP for delivery schedule types
VGBEL String Document number of the reference document
OBJNR String Object number at header level
BUKRS_VF String Company code to be billed
TAXK1 String Alternative tax classification
TAXK2 String Tax classification 2 for customer
TAXK3 String Tax classification 3 for customer
TAXK4 String Tax Classification 4 Customer
TAXK5 String Tax classification 5 for customer
TAXK6 String Tax classification 6 for customer
TAXK7 String Tax classification 7 for customer
TAXK8 String Tax classification 8 for customer
TAXK9 String Tax classification 9 for customer
XBLNR String Reference Document Number
ZUONR String Assignment number
VGTYP String Document category of preceding SD document
KALSM_CH String Search procedure for batch determination
AGRZR String Accrual period for order-related billing docs.to be accrued
AUFNR String Order Number
QMNUM String Notification No
VBELN_GRP String Mster contract number
SCHEME_GRP String Referencing requirement: Procedure
ABRUF_PART String Check partner authorizations
ABHOD Date Pick up date
ABHOV Time Pick up time
ABHOB Time Pick up time
RPLNR String Number of payment card plan type
VZEIT Time Proposed schedule line time (local with ref. to sales org.)
STCEG_L String Tax Destination Country
LANDTX String Tax departure country
XEGDR String Indicator: Triangular deal within the EU ?
ENQUEUE_GRP String Block master contr. until all lower level contracts updated
DAT_FZAU Date Cml delivery order qty date
FMBDAT Date Material Staging/Availability Date
VSNMR_V String Sales document version number
HANDLE String International unique key for VBAK-VBELN
PROLI String Dangerous Goods Management Profile in SD Documents
CONT_DG String Indicator: Document contains dangerous goods
CRM_GUID String Character field, length 70
UPD_TMSTMP Decimal UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
MSR_ID String Process Identification Number
TM_CTRL_KEY String Control Key for Document Transfer to TM
PSM_BUDAT Date Posting Date in the Document
SWENR String Business Entity Number
SMENR String Number of Sales Unit
PHASE String Sales Phase
MTLAUR String Marker for Low Income Housing
STAGE Int Construction Stage
HB_CONT_REASON String Contingency data
HB_EXPDATE Date Expiration date
HB_RESDATE Date Resolution date
MILL_APPL_ID String Application ID Category for Configuration
TAS String Treasury Account Symbol
BETC String Business Event Type Code
MOD_ALLOW String Modification Allowed
CANCEL_ALLOW String Cancellation Allowed
PAY_METHOD String List of the Payment Methods to be Considered
BPN String Business Partner Number
REP_FREQ String Reporting Frequency
LOGSYSB String Logical system with which document was created
KALCD String Procedure for Campaign Determination
MULTI String Multiple Campaigns/Trade Promotions Active Indicator
SPPAYM String Payment Form for Special Payment Method
WTYSC_CLM_HDR String Claim header

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.



VBAP

The SAP table VBAP.

Columns

Name Type Description
MANDT [KEY] String Client
VBELN [KEY] String Sales Document
POSNR [KEY] String Sales Document Item
MATNR String Material Number
MATWA String Material entered
PMATN String Pricing Reference Material
CHARG String Batch Number
MATKL String Material Group
ARKTX String Short text for sales order item
PSTYV String Sales document item category
POSAR String Item type
LFREL String Item is relevant for delivery
FKREL String Relevant for Billing
UEPOS String Higher-level item in bill of material structures
GRPOS String Item for which this item is an alternative
ABGRU String Reason for rejection of quotations and sales orders
PRODH String Product hierarchy
ZWERT Double Target Value for Outline Agreement in Document Currency
ZMENG Decimal Target quantity in sales units
ZIEME String Target quantity UoM
UMZIZ Decimal Factor for converting sales units to base units (target qty)
UMZIN Decimal Factor for converting sales units to base units (target qty)
MEINS String Base Unit of Measure
SMENG Decimal Scale quantity in base unit of measure
ABLFZ Decimal Rounding quantity for delivery
ABDAT Date Reconciliation Date for Agreed Cumulative Quantity
ABSFZ Decimal Allowed deviation in quantity (absolute)
POSEX String Item Number of the Underlying Purchase Order
KDMAT String Material Number Used by Customer
KBVER Decimal Allowed deviation in quantity (in percent)
KEVER Decimal Days by which the quantity can be shifted
VKGRU String Repair Processing: Classification of Items
VKAUS String Usage Indicator
GRKOR String Delivery group (items are delivered together)
FMENG String Quantity is Fixed
UEBTK String Unlimited overdelivery allowed
UEBTO Decimal Overdelivery Tolerance Limit
UNTTO Decimal Underdelivery Tolerance Limit
FAKSP String Billing block for item
ATPKZ String Replacement part
RKFKF String Method of billing for CO/PPC orders
SPART String Division
GSBER String Business Area
NETWR Double Net value of the order item in document currency
WAERK String SD Document Currency
ANTLF Decimal Maximum Number of Partial Deliveries Allowed Per Item
KZTLF String Partial delivery at item level
CHSPL String Batch split allowed
KWMENG Decimal Cumulative Order Quantity in Sales Units
LSMENG Decimal Cumulative required delivery qty (all dlv-relev.sched.lines)
KBMENG Decimal Cumulative confirmed quantity in sales unit
KLMENG Decimal Cumulative confirmed quantity in base unit
VRKME String Sales unit
UMVKZ Decimal Numerator (factor) for conversion of sales quantity into SKU
UMVKN Decimal Denominator (Divisor) for Conversion of Sales Qty into SKU
BRGEW Decimal Gross Weight of the Item
NTGEW Decimal Net Weight of the Item
GEWEI String Weight Unit
VOLUM Decimal Volume of the item
VOLEH String Volume unit
VBELV String Originating document
POSNV String Originating item
VGBEL String Document number of the reference document
VGPOS String Item number of the reference item
VOREF String Complete reference indicator
UPFLU String Update indicator for sales document document flow
ERLRE String Completion rule for quotation / contract
LPRIO String Delivery Priority
WERKS String Plant (Own or External)
LGORT String Storage Location
VSTEL String Shipping Point/Receiving Point
ROUTE String Route
STKEY String Origin of the bill of material
STDAT Date Key date of the bill of material
STLNR String Bill of material
STPOS Decimal Bill of material item number VBAP not used
AWAHR String Order probability of the item
ERDAT Date Date on Which Record Was Created
ERNAM String Name of Person who Created the Object
ERZET Time Entry time
TAXM1 String Tax classification material
TAXM2 String Tax classification material
TAXM3 String Tax classification material
TAXM4 String Tax classification material
TAXM5 String Tax classification material
TAXM6 String Tax classification material
TAXM7 String Tax classification material
TAXM8 String Tax classification material
TAXM9 String Tax classification material
VBEAF Decimal Fixed shipping processing time in days (= setup time)
VBEAV Decimal Variable shipping processing time in days
VGREF String Preceding document has resulted from reference
NETPR Double Net price
KPEIN Decimal Condition pricing unit
KMEIN String Condition unit
SHKZG String Returns Item
SKTOF String Cash discount indicator
MTVFP String Checking Group for Availability Check
SUMBD String Summing up of requirements
KONDM String Material Pricing Group
KTGRM String Account assignment group for this material
BONUS String Volume rebate group
PROVG String Commission group
EANNR String European Article Number (EAN) - obsolete!!!!!
PRSOK String Pricing is OK
BWTAR String Valuation Type
BWTEX String Indicator: Separate valuation
XCHPF String Batch management requirement indicator
XCHAR String Batch management indicator (internal)
LFMNG Decimal Minimum delivery quantity in delivery note processing
STAFO String Update group for statistics update
WAVWR Double Cost in document currency
KZWI1 Double Subtotal 1 from pricing procedure for condition
KZWI2 Double Subtotal 2 from pricing procedure for condition
KZWI3 Double Subtotal 3 from pricing procedure for condition
KZWI4 Double Subtotal 4 from pricing procedure for condition
KZWI5 Double Subtotal 5 from pricing procedure for condition
KZWI6 Double Subtotal 6 from pricing procedure for condition
STCUR Decimal Exchange rate for statistics (Exch.rate at time of creation)
AEDAT Date Changed On
EAN11 String International Article Number (EAN/UPC)
FIXMG String Delivery date and quantity fixed
PRCTR String Profit Center
MVGR1 String Material group 1
MVGR2 String Material group 2
MVGR3 String Material group 3
MVGR4 String Material group 4
MVGR5 String Material group 5
KMPMG Decimal Component quantity
SUGRD String Reason for material substitution
SOBKZ String Special Stock Indicator
VPZUO String Allocation Indicator
PAOBJNR String Profitability Segment Number (CO-PA)
PS_PSP_PNR String Work Breakdown Structure Element (WBS Element)
AUFNR String Order Number
VPMAT String Planning material
VPWRK String Planning plant
PRBME String Base unit of measure for product group
UMREF Double Conversion factor: quantities
KNTTP String Account Assignment Category
KZVBR String Consumption Posting
SERNR String BOM explosion number
OBJNR String Object number at item level
ABGRS String Results Analysis Key
BEDAE String Requirements type
CMPRE Double Item credit price
CMTFG String ID for partial release of order item, credit block
CMPNT String ID: Item with active credit function / relevant for credit
CMKUA Decimal Credit data exchange rate for requested delivery date
CUOBJ String Configuration
CUOBJ_CH String Internal object number of the batch classification
CEPOK String Status expected price
KOUPD String Condition update
SERAIL String Serial Number Profile
ANZSN Int Number of serial numbers
NACHL String Customer has not posted goods receipt
MAGRV String Material Group: Packaging Materials
MPROK String Status manual price change
VGTYP String Document category of preceding SD document
PROSA String ID for material determination
UEPVW String ID for higher-level item usage
KALNR String Cost Estimate Number for Cost Est. w/o Qty Structure
KLVAR String Costing Variant
SPOSN String BOM Item Number
KOWRR String Statistical values
STADAT Date Statistics date
EXART String Business Transaction Type for Foreign Trade
PREFE String Preference indicator in export/import
KNUMH String Number of condition record from batch determination
CLINT String Internal Class Number
CHMVS String Batches: Exit to quantity proposal
STLTY String BOM category
STLKN String BOM item node number
STPOZ String Internal counter
STMAN String Inconsistent configuration
ZSCHL_K String Overhead key
KALSM_K String Costing Sheet
KALVAR String Costing Variant
KOSCH String Product allocation determination procedure
UPMAT String Pricing reference material of main item
UKONM String Material pricing group of main item
MFRGR String Material freight group
PLAVO String Planning delivery schedule instruction
KANNR String KANBAN/sequence number
CMPRE_FLT Double Item credit price
ABFOR String Form of payment guarantee
ABGES Double Guaranteed (factor between 0 and 1)
J_1BCFOP String CFOP Code and Extension
J_1BTAXLW1 String Tax law: ICMS
J_1BTAXLW2 String Tax law: IPI
J_1BTXSDC String SD tax code
WKTNR String Value contract no.
WKTPS String Value contract item
SKOPF String Assortment module
KZBWS String Valuation of Special Stock
WGRU1 String Material group hierarchy 1
WGRU2 String Material group hierarchy 2
KNUMA_PI String Promotion
KNUMA_AG String Sales deal
KZFME String ID: Leading unit of measure for completing a transaction
LSTANR String Free goods delivery control
TECHS String Parameter Variant/Standard Variant
MWSBP Double Tax amount in document currency
BERID String MRP Area
PCTRF String Profit Center for Billing
LOGSYS_EXT String Logical system
J_1BTAXLW3 String ISS Tax Law
J_1BTAXLW4 String COFINS Tax Law
J_1BTAXLW5 String PIS Tax Law
STOCKLOC String First Inventory-Managing Location
SLOCTYPE String Type of First Inventory-Managing Location
MSR_RET_REASON String Return Reason
MSR_REFUND_CODE String Returns Refund Code
MSR_APPROV_BLOCK String Approval Block
NRAB_KNUMH String Condition record number
TRMRISK_RELEVANT String Risk Relevancy in Sales
Z_PRS_OFFSHORE String Professional Services: Delivery Type
Z_PRS_BILL_FLAG String Professional Services: Billable/Non-Billable
Z_PRS_COUNTRY String Country Key
Z_PRS_CHARGELEVL String Professional Services: Charge Level
BEV1SRFUND String Analysis/Reason for Rejection
AUFPL_OLC String Routing number of operations in the order
APLZL_OLC String Internal counter
FERC_IND String Regulatory indicator
KOSTL String Cost Center
FONDS String Fund
FISTL String Funds Center
FKBER String Functional Area
GRANT_NBR String Grant
BUDGET_PD String FM: Budget Period
IUID_RELEVANT String IUID Relevant for Customer
MILL_SE_GPOSN String Global Item
PRS_OBJNR String Engagement mgmt: Object number
PRS_SD_SPSNR String Standard WBS Element for Project Inception via SD
PRS_WORK_PERIOD String Work Period (Internal Representation)
TAS String Treasury Account Symbol
BETC String Business Event Type Code
MOD_ALLOW String Modification Allowed
CANCEL_ALLOW String Cancellation Allowed
PAY_METHOD String List of the Payment Methods to be Considered
BPN String Business Partner Number
REP_FREQ String Reporting Frequency
PARGB String Trading partner
AUFPL_OAA String Routing number of operations in the order
APLZL_OAA String Internal counter
ARSNUM String Number of reservation/dependent requirements
ARSPOS String Item number of reservation/dependent requirements
WTYSC_CLMITEM String Claim item number
ZZDEA_LICENSE String DEA Number
ZZDEA_SCHEDULE String DEA Schedule Key

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
rows@next String This is a system column used to page through the results in SAP.