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 |
|---|---|
| AFSPREL | Relation Between Orders in an Order Split |
| AFSPOPR | Split Operations in an Order Split |
| OIUREP_MASTER_PC | RegID Split table (e.g. LA Parish split) |
| TMLCCSSCOPETXT | Actual Cost Component Split: Split for Data Range (Texts) |
| DRVLOG_TRAIL | Derivation: Orders / purchase orders in derivation path |
| TNHCO_COLORD | HCO: Definition Coll. Orders for Outpat.Case-Based Orders |
| TNHCO_CORD_SEL | HCO: Char. Sel. for Coll. Orders for Outpat. Case-Bsd Orders |
| /PLMB/NAV_XREL | Relation and External system Relation details |
| MLAUFKEPH | ML: Cost Component Split (Components) for Order History |
| MLBEKEPH | ML: Cost Comp. Split (Elements) for Purchase Order History |
| T312B | Profile for Transfer Order Split |
| /SAPHT/MESZSPLPO | Process Order Split link table |
| ACC_INPH3_DPR | Acc. relation table between pairs and found locations |
| AD04RELCON | Relation between conditions |
| BBPC_MENV_SCHFLD | Multi Envelope Bidding: Relation between envelope and folder |
Latest Table Searches
Id for mainly non-military use table in SAPCustomer number range table in SAP
Damage goods table in SAP
Reason codes 55 table in SAP
Sxmsclup2 table in SAP
Sxmsclup table in SAP
Transaction type 102 table in SAP
Popular Table Searches
Link between sales order and production order f table in SAPBusiness partner table in SAP
Shipping point table in SAP
Country codes table in SAP
Se16n table list for table in SAP
Accounting document table in SAP
Hdfc bank ltd company code for zinghr table in SAP