SXIPERF_ORDER_HEADER SAP (OrderHeader) Structure details
Description: OrderHeader
Related tables to SXIPERF_ORDER_HEADER
Access table SXIPERF_ORDER_HEADER
Structure field list including key, data, relationships and ABAP select examples
SXIPERF_ORDER_HEADER is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "OrderHeader" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_SXIPERF_ORDER_HEADER TYPE SXIPERF_ORDER_HEADER.
The SXIPERF_ORDER_HEADER table consists of various fields, each holding specific information or linking keys about OrderHeader data available in SAP. These include ORDER_DATE (Creation date of purchase order), LANGUAGE (Language ISO code), CURRENCY (Currency ISO code), METHOD (Action to perform with this document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP SXIPERF_ORDER_HEADER structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
ORDER_ID | Number of purchase order in Enterprise Buyer | 0 | |||||||
ORDER_DATE | Creation date of purchase order | 0 | |||||||
LANGUAGE | Language ISO code | SXIPERF_LANGUAGE | CHAR | 2 | |||||
CURRENCY | Currency ISO code | SXIPERF_CURRENCY | CHAR | 3 | |||||
METHOD | Action to perform with this document | 0 | |||||||
FOLLOWUP_ACTIONS | 0 | ||||||||
CONFIRMATION | Goods receipt indicator | 0 | |||||||
INVOICE | Invoice receipt indicator: Automatic settlement of confirmat | 0 | |||||||
TRADING_PARTNERS | 0 | ||||||||
VENDOR | 0 | ||||||||
IDENTIFIER | 0 | ||||||||
PARTNER_ID | Business partner ID in EBP | 0 | |||||||
DUNS | Dun and Bradstreet standard ID for this partner (has to be m | 0 | |||||||
PARTNER_IDVENDOR | Business partner ID assigned by the vendor (has to be mainta | 0 | |||||||
ADDRESS | 0 | ||||||||
COMPANY_NAME1 | Name 1 of organization | 0 | |||||||
COMPANY_NAME2 | Name 2 of organization | 0 | |||||||
CARE_OF_NAME | 0 | ||||||||
POBOX | PO Box | 0 | |||||||
STREET | Street | 0 | |||||||
HOUSE_NUMBER | House number | 0 | |||||||
CITY | City | 0 | |||||||
POSTAL_CODE | City postal code | 0 | |||||||
REGION | Region (state, province, county) | 0 | |||||||
DISTRICT | District | 0 | |||||||
COUNTRY | ISO code of country | SXIPERF_COUNTRY | CHAR | 2 | |||||
PERSON_TITLE | 0 | ||||||||
FIRST_NAME | First name | 0 | |||||||
LAST_NAME | Last name | 0 | |||||||
DEPARTMENT | Department | 0 | |||||||
BUILDING | Building (number or code) | 0 | |||||||
FLOOR | Floor | 0 | |||||||
ROOM_NUMBER | Room or appartment number | 0 | |||||||
TELEPHONE_NUMBER | Telephone no.: Area code+number | 0 | |||||||
TELEPHONE_NUMBER_EXTENSION | Telephone no.: Extension | 0 | |||||||
FAX_NUMBER | Fax no.: Area code+number | 0 | |||||||
FAX_NUMBER_EXTENSION | Fax no.: Extension | 0 | |||||||
EMAIL_ADDRESS | E-mail address | 0 | |||||||
ORDERING_PARTY | 0 | ||||||||
IDENTIFIER | 0 | ||||||||
PARTNER_ID | Business partner ID in EBP | 0 | |||||||
DUNS | Dun and Bradstreet standard ID for this partner (has to be m | 0 | |||||||
PARTNER_IDVENDOR | Business partner ID assigned by the vendor (has to be mainta | 0 | |||||||
ADDRESS | 0 | ||||||||
COMPANY_NAME1 | Name 1 of organization | 0 | |||||||
COMPANY_NAME2 | Name 2 of organization | 0 | |||||||
CARE_OF_NAME | 0 | ||||||||
POBOX | PO Box | 0 | |||||||
STREET | Street | 0 | |||||||
HOUSE_NUMBER | House number | 0 | |||||||
CITY | City | 0 | |||||||
POSTAL_CODE | City postal code | 0 | |||||||
REGION | Region (state, province, county) | 0 | |||||||
DISTRICT | District | 0 | |||||||
COUNTRY | ISO code of country | SXIPERF_COUNTRY | CHAR | 2 | |||||
PERSON_TITLE | 0 | ||||||||
FIRST_NAME | First name | 0 | |||||||
LAST_NAME | Last name | 0 | |||||||
DEPARTMENT | Department | 0 | |||||||
BUILDING | Building (number or code) | 0 | |||||||
FLOOR | Floor | 0 | |||||||
ROOM_NUMBER | Room or appartment number | 0 | |||||||
TELEPHONE_NUMBER | Telephone no.: Area code+number | 0 | |||||||
TELEPHONE_NUMBER_EXTENSION | Telephone no.: Extension | 0 | |||||||
FAX_NUMBER | Fax no.: Area code+number | 0 | |||||||
FAX_NUMBER_EXTENSION | Fax no.: Extension | 0 | |||||||
EMAIL_ADDRESS | E-mail address | 0 | |||||||
SHIP_TO_PARTY | 0 | ||||||||
IDENTIFIER | 0 | ||||||||
PARTNER_ID | Business partner ID in EBP | 0 | |||||||
DUNS | Dun and Bradstreet standard ID for this partner (has to be m | 0 | |||||||
PARTNER_IDVENDOR | Business partner ID assigned by the vendor (has to be mainta | 0 | |||||||
ADDRESS | 0 | ||||||||
COMPANY_NAME1 | Name 1 of organization | 0 | |||||||
COMPANY_NAME2 | Name 2 of organization | 0 | |||||||
CARE_OF_NAME | 0 | ||||||||
POBOX | PO Box | 0 | |||||||
STREET | Street | 0 | |||||||
HOUSE_NUMBER | House number | 0 | |||||||
CITY | City | 0 | |||||||
POSTAL_CODE | City postal code | 0 | |||||||
REGION | Region (state, province, county) | 0 | |||||||
DISTRICT | District | 0 | |||||||
COUNTRY | ISO code of country | SXIPERF_COUNTRY | CHAR | 2 | |||||
PERSON_TITLE | 0 | ||||||||
FIRST_NAME | First name | 0 | |||||||
LAST_NAME | Last name | 0 | |||||||
DEPARTMENT | Department | 0 | |||||||
BUILDING | Building (number or code) | 0 | |||||||
FLOOR | Floor | 0 | |||||||
ROOM_NUMBER | Room or appartment number | 0 | |||||||
TELEPHONE_NUMBER | Telephone no.: Area code+number | 0 | |||||||
TELEPHONE_NUMBER_EXTENSION | Telephone no.: Extension | 0 | |||||||
FAX_NUMBER | Fax no.: Area code+number | 0 | |||||||
FAX_NUMBER_EXTENSION | Fax no.: Extension | 0 | |||||||
EMAIL_ADDRESS | E-mail address | 0 | |||||||
BILL_TO_PARTY | 0 | ||||||||
IDENTIFIER | 0 | ||||||||
PARTNER_ID | Business partner ID in EBP | 0 | |||||||
DUNS | Dun and Bradstreet standard ID for this partner (has to be m | 0 | |||||||
PARTNER_IDVENDOR | Business partner ID assigned by the vendor (has to be mainta | 0 | |||||||
ADDRESS | 0 | ||||||||
COMPANY_NAME1 | Name 1 of organization | 0 | |||||||
COMPANY_NAME2 | Name 2 of organization | 0 | |||||||
CARE_OF_NAME | 0 | ||||||||
POBOX | PO Box | 0 | |||||||
STREET | Street | 0 | |||||||
HOUSE_NUMBER | House number | 0 | |||||||
CITY | City | 0 | |||||||
POSTAL_CODE | City postal code | 0 | |||||||
REGION | Region (state, province, county) | 0 | |||||||
DISTRICT | District | 0 | |||||||
COUNTRY | ISO code of country | SXIPERF_COUNTRY | CHAR | 2 | |||||
PERSON_TITLE | 0 | ||||||||
FIRST_NAME | First name | 0 | |||||||
LAST_NAME | Last name | 0 | |||||||
DEPARTMENT | Department | 0 | |||||||
BUILDING | Building (number or code) | 0 | |||||||
FLOOR | Floor | 0 | |||||||
ROOM_NUMBER | Room or appartment number | 0 | |||||||
TELEPHONE_NUMBER | Telephone no.: Area code+number | 0 | |||||||
TELEPHONE_NUMBER_EXTENSION | Telephone no.: Extension | 0 | |||||||
FAX_NUMBER | Fax no.: Area code+number | 0 | |||||||
FAX_NUMBER_EXTENSION | Fax no.: Extension | 0 | |||||||
EMAIL_ADDRESS | E-mail address | 0 | |||||||
SHIP_TO_ADDRESS | 0 | ||||||||
COMPANY_NAME1 | Name 1 of organization | 0 | |||||||
COMPANY_NAME2 | Name 2 of organization | 0 | |||||||
CARE_OF_NAME | 0 | ||||||||
POBOX | PO Box | 0 | |||||||
STREET | Street | 0 | |||||||
HOUSE_NUMBER | House number | 0 | |||||||
CITY | City | 0 | |||||||
POSTAL_CODE | City postal code | 0 | |||||||
REGION | Region (state, province, county) | 0 | |||||||
DISTRICT | District | 0 | |||||||
COUNTRY | ISO code of country | SXIPERF_COUNTRY | CHAR | 2 | |||||
PERSON_TITLE | 0 | ||||||||
FIRST_NAME | First name | 0 | |||||||
LAST_NAME | Last name | 0 | |||||||
DEPARTMENT | Department | 0 | |||||||
BUILDING | Building (number or code) | 0 | |||||||
FLOOR | Floor | 0 | |||||||
ROOM_NUMBER | Room or appartment number | 0 | |||||||
TELEPHONE_NUMBER | Telephone no.: Area code+number | 0 | |||||||
TELEPHONE_NUMBER_EXTENSION | Telephone no.: Extension | 0 | |||||||
FAX_NUMBER | Fax no.: Area code+number | 0 | |||||||
FAX_NUMBER_EXTENSION | Fax no.: Extension | 0 | |||||||
EMAIL_ADDRESS | E-mail address | 0 | |||||||
COMPLETION_PERIOD | 0 | ||||||||
FROM_DATE | No date means today | 0 | |||||||
TO_DATE | No date means no end date or undefined end date. | 0 | |||||||
TERMS_OF_PAYMENT | 0 | ||||||||
DISCOUNT_MAX | 0 | ||||||||
DAYS | Payment within x days | 0 | |||||||
PERCENTAGE | Discount of n percent | 0 | |||||||
DISCOUNT | 0 | ||||||||
DAYS | Payment within x days | 0 | |||||||
PERCENTAGE | Discount of n percent | 0 | |||||||
DAYS | Payment within x days | 0 | |||||||
PROCUREMENT_CARD | 0 | ||||||||
ISSUE_COMPANY | Issuing company, for example VISA, MasterCard, or American E | 0 | |||||||
NUMBER | Credit card number | 0 | |||||||
HOLDER_NAME | Name of the holder of credit card | 0 | |||||||
VALIDITY_DATE | Credit card expiry date | 0 | |||||||
LIMIT | 0 | ||||||||
OVERALL_LIMIT | Overall limit indicator | 0 | |||||||
SUB_LIMIT_CONTRACT | 0 | ||||||||
DESCRIPTION | Short text (40 characters) for order description | 0 | |||||||
TEXT | 0 | ||||||||
CONTENT | The text itself | 0 | |||||||
LANGUAGE | Language ISO code | SXIPERF_LANGUAGE | CHAR | 2 | |||||
ATTACHMENT | 0 | ||||||||
USER_DEFINED_EXTENSION | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure SXIPERF_ORDER_HEADER using ABAP code?
As SXIPERF_ORDER_HEADER is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SXIPERF_ORDER_HEADER as there is no data to select.How to access SAP table SXIPERF_ORDER_HEADER
Within an ECC or HANA version of SAP you can also view further information about SXIPERF_ORDER_HEADER and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects