SAP WPOS_SPR_T_IDX AIF Index Table for Sales Per Receipt Items Table
Overview
WPOS_SPR_T_IDX is a standard SAP S/4HANA table that stores AIF Index Table for Sales Per Receipt Items data. There are total 37 fields in the WPOS_SPR_T_IDX table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WPOS_SPR_T_IDX belongs to Service based POS Interface - Inbound (LO-RFM-IFC-IN-SRV) module and is located in the package Implementation for SOAP Service for POS Sales (SOAP_RFM_POSI_SALES_IMPL).
In addition, following links provide an overview of foreign key relationships, if any, that link WPOS_SPR_T_IDX to other SAP tables and standard CDS views available based on WPOS_SPR_T_IDX table in S/4HANA 2020.
Techincal Settings of WPOS_SPR_T_IDX
Below are technical details of the table WPOS_SPR_T_IDX
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WPOS_SPR_T_IDX Fields
The following table gives you an overview of the fields available in WPOS_SPR_T_IDX
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| MSGGUID | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | |
| COUNTER | 4 Byte Signed Integer | INT4 | INT4 | 10 | |
| NS | Namespace | /AIF/NS | /AIF/T_NS | CHAR | 6 |
| IFNAME | Interface Name | /AIF/IFNAME | /AIF/T_FINF | CHAR | 10 |
| IFVER | Interface Version | /AIF/IFVERSION | /AIF/T_FINF | CHAR | 5 |
| NSRECIP | Namespace | /AIF/NS | * | CHAR | 6 |
| RECIPIENT | Alert Management Recipient | /AIF/ALRT_REC | * | CHAR | 30 |
| STATUS | Processing Status | /AIF/PROC_STATUS | CHAR | 1 | |
| SUB_STATUS | Sub status for 'In Process' status | /AIF/PROC_SUB_STATUS | CHAR | 1 | |
| AIF_LOCATION | Message Location | /AIF/MESSAGE_LOCATION | CHAR | 1 | |
| LOGNUMBER | Application log: log number | BALOGNR | * | CHAR | 20 |
| TRACE_LEVEL | AIF Trace Level | /AIF/TRACE_LEVEL | CHAR | 1 | |
| TL_EXP_DATE | Expiration Date | /AIF/EXP_DATE | DATS | 8 | |
| TL_EXP_TIME | Expiration Time | /AIF/EXP_TIME | TIMS | 6 | |
| CREATE_USER | Create User | /AIF/CREATE_USER | CHAR | 12 | |
| CREATE_DATE | Creation Date | /AIF/CREATE_DATE | DATS | 8 | |
| CREATE_TIME | Creation Time | /AIF/CREATE_TIME | TIMS | 6 | |
| LAST_USER | Last User | /AIF/LAST_USER | CHAR | 12 | |
| LAST_DATE | Last Date | /AIF/LAST_DATE | DATS | 8 | |
| LAST_TIME | Last Time | /AIF/LAST_TIME | TIMS | 6 | |
| END_USER | End User | /AIF/END_USER | CHAR | 12 | |
| END_DATE | End Date | /AIF/END_DATE | DATS | 8 | |
| END_TIME | End Time | /AIF/END_TIME | TIMS | 6 | |
| AIF_ALERT_ID | External ID for an Alert | SALRTEXTID | NUMC | 5 | |
| AIF_VARIANT_NS | Variant Namespace | /AIF/VARIANT_NS | CHAR | 6 | |
| AIF_VARIANT_NAME | Name of Interface Variant | /AIF/VARIANT_NAME | CHAR | 20 | |
| EXTERNAL_MESSAGE | Indicates source of message: internal or extenal (e.g CPI) | /AIF/EXTERNAL_MESSAGE | NUMC | 2 | |
| TIME_ZONE | Time Zone | TZNZONE | * | CHAR | 6 |
| PROCESSING_END_TSTMP | Message Processing Timestamp in UTC Timezone | /AIF/PROCESSING_TSTMP | DEC | 15 | |
| EXTERNAL_REFERENCE_DOC | POS Inbound Transaction: External Document Reference | WPOS_EXTERNAL_REFERENCE | CHAR | 16 | |
| TRANSACTION_INITIATOR | POS Inbound Transaction: Transaction Initiator | WPOS_TRANSACTION_INITIATOR | CHAR | 16 | |
| RETURN_ITEM_INDICATOR | Return Item Indicator | WPOS_RETURN_ITEM_IND | CHAR | 1 | |
| PRODUCT_ID | POS Inbound Transaction: Sales Product | WPOS_PRODUCT | CHAR | 40 | |
| PRODUCT_GTIN | POS Inbound Transaction: Sales Global Trade Item Number | WPOS_PRODUCT_GTIN | CHAR | 14 | |
| TRANSACTION_TYPE | Transact. type | POSUVORG | CHAR | 4 | |
| MATERIAL_GROUP | Material Group | MATKL | CHAR | 9 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WPOS_SPR_T_IDX
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WPOS_SPR_T_IDX | IFNAME | : | /AIF/T_FINF |
| WPOS_SPR_T_IDX | IFVER | : | /AIF/T_FINF |
| WPOS_SPR_T_IDX | NS | : | /AIF/T_NS |