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 |
Latest Table Searches
Service entry sheet table in SAPService order table in SAP
Po item table in SAP
Goods movement table in SAP
Goods receipt table in SAP
Purchase invoice table in SAP
Service master table in SAP
Purchase order history table in SAP
Movement type table in SAP
Document flow table in SAP
Scheduling agreement table in SAP
Release strategy table in SAP
Purchase info record table in SAP
Purchasing group table in SAP
Purchasing organization table in SAP
Purchase requisition table in SAP
Invoice table in SAP
Purchase order table in SAP
Popular Table Searches
Scheduling agreement table in SAPDocument flow table in SAP
Service entry sheet table in SAP
Goods receipt table in SAP
Purchase order table in SAP
Invoice table in SAP
Purchase requisition table in SAP
Purchasing organization table in SAP
Purchase info record table in SAP
Movement type table in SAP