AFSPREL is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of AFSPREL in SAP.
- Table description : Relation Between Orders in an Order Split
- Module : CRM-CIC
- Parent Module : CRM
- Package : CO
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP AFSPREL Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| C_AUFNR | Child order of a split hierarchy | SPLIT_CAUFNR | AUFNR |
| BYPRODUCT | Material Number By-Product Order Split | COOS_BYPRODUCT | MATNR |
| BYPRODUCT_BATCH | Batch Number By-Product Order Split | COOS_BYPRODUCT_BATCH | CHARG |
| SPLCNT | Counter for the Parent-Child Order Relationships | SPLCNT | NUMC4 |
| P_AUFNR | Parent order of a split hierarchy | SPLIT_PAUFNR | AUFNR |
| L_AUFNR | Leading order of a split hierarchy | SPLIT_LAUFNR | AUFNR |
| SPLQ | Split Quantity in Order Split | SPLIT_QTY | MENG13 |
| QUNIT | Unit of measure for activity | VORME | MEINS |
| SDATE | Created on | CATS_ERSDA | DATUM |
| STIME | Time created | C_TIME | UZEIT |
| SUSER | User Name | UNAME | UNAME |
| BYPROD_MAT_DOC | Material Document for Goods Receipt By-Product Order Split | COOS_MATERIAL_DOC_NO_BYPRODUCT | BELNR |
| BYPROD_MAT_ITEM | Material Document Item GR By-Product Order Split | COOS_MATERIAL_DOC_PO_BYPRODUCT | MBLPO |
| BYPROD_MAT_YEAR | Material Document Year Goods Receipt By-Product Order Split | COOS_MATERIAL_DOC_YY_BYPRODUCT | GJAHR |
| COMPONENT_BATCH | Component Batch Used for Order Split | COOS_COMPONENT_BATCH | CHARG |
| WIP_BATCH | WIP Batch Used for Order Split | COOS_WIPBATCH | CHARG |
| CANCELED | Order Split Cancelled | COOS_CANCELED | FLAG |
| CANCEL_USER | User Who Carried Out Order Split Cancellation | COOS_CANCELLATION_USER | UNAME |
| CANCEL_DATE | Cancellation Date Order Split | COOS_CANCELLATION_DATE | DATUM |
| CANCEL_TIME | Time of Cancellation | COOS_CANCELLATION_TIME | UZEIT |
AFSPREL related tables
| Table | Note |
|---|---|
| AFBP | CIM order: Batch print requests |
| AFFL | Work order sequence |
| AFKO | Order Header Data PP Orders |
| AFPO | Order item |
| AFSPOPR | Split Operations in an Order Split |
| AFSPREL | Relation Between Orders in an Order Split |
| AFVC | Operation within an order |
| AFVU | DB structure of the user fields of the operation |
| AFVV | DB structure of the quantities/dates/values in the operation |
| DRAD_PORDER | Attributes for Links: Document to Production Order |
| FAPW | Index of production-/issuing plant for production order |
| FTIND | Missing parts index |
| ORDCOM | Communication control Operation download |
| ORDLY | Table of delays for production order |
| T024F | Production scheduler |
| T399X | Parameters dependent on order type |
| T441C | Profile - availability check |
| T441CT | Texts for Profile "Display Availability Check" |
| T490 | Transactions PP - orders - order category |
| T496B | CIM order: Assigning document types to reference doc. types |