- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Advanced Returns Management (LO-ARM)
- Batches (LO-BM)
- Commodity Management in Logistics (LO-CMM)
- ERP Logistik Integration (LO-INT)
- Engineering Change Management (LO-ECH)
- Global Trade (LO-GT)
- Handling Unit Management (LO-HU)
- Logistics Basic Data (LO-MD)
- Logistics Information System (LIS) (LO-LIS)
- Product Data Management (LO-PDM)
- Retail & Fashion Management in S/4HANA (LO-RFM)
- Communication and Interfaces (LO-RFM-IFC)
- Cross Application Functionality (LO-RFM-CA)
- Logistics Basic Data (LO-RFM-MD)
- Merchandise Logistic (LO-RFM-LG)
- Obsolete Functionality (LO-RFM-OBS)
- Order Allocation Run (LO-RFM-ARN)
- Production Planning for Fashion (LO-RFM-PP)
- Purchasing (LO-RFM-PUR)
- Retail & Fashion Sales and Distribution (LO-RFM-SD)
- Segmentation (LO-RFM-SGT)
- Store Operations (LO-RFM-STO)
- SAP Agricultural Contract Management (LO-AGR)
- Segmentation (LO-SGT)
- Settlement Management (LO-AB)
- Variant Configuration (LO-VC)
- Variant configuration on HANA (LO-VCH)
- Warranty Claim Processing (LO-WTY)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_SupDmndAllDocPurReqnAssgQ
Query View for Purchase Requisition Assignment Details
| view: CSUPDMNDADPRAQ
| Extraction:
Not supported
| Component: Order Allocation Run
Tables used:
SCAL_TT_DATE, EBAN, EBKN, SCAL_TT_WEEK, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, LFA1, MARA, MARC, T001K, T001W
- 🔑 Keys (10)
- 💰 Amounts (1)
- ∑ Quantities (2)
- 📅 Dates (2)
- ☰ Categorical (1)
- Other (11)
- 🔗 Relations (12)
| Column Name | Description | |
|---|---|---|
| Material FK | Material Number | |
| Plant FK | Plant | |
| Batch | Batch Number | |
| StorageLocation | Storage location | |
| SupplyNumber | null | |
| SupplyItem | null | |
| SupplyScheduleLine | null | |
| ProductAvailabilityDate | Item delivery date | |
| AssignedSupplyType | null | |
| RequirementType | Requirement Type | Show values |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (DocumentCurrency): | ||
| NetPriceAmount | Price in Purchase Requisition | |
| Column Name | Description | |
|---|---|---|
| AssignedQuantityInBaseUnit | null | |
| NormalAssignedQuantityInBsUnt | null |
| Column Name | Description | |
|---|---|---|
| ProductAvailabilityDate | Item delivery date | |
| RequestedDeliveryDate | Item delivery date |
| Column Name | Description | |
|---|---|---|
| RequirementType | Requirement Type | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| SupAssgmtSource | null | ||
| PreviewAssignedQuantityInBsUnt | null | ||
| ARunTmpAssignedQuantityInBsUnt | null | ||
| CalendarYear | Calendar Year | NUM4 | |
| CalendarMonth | Calendar Month | NUM2 | |
| CalendarMonthName | Short Text for Fixed Values | DDTEXT | |
| CalendarWeek | null | ||
| CalendarDay | Calendar Day | NUM2 | |
| Customer | null | ||
| CompanyCode | null | ||
| PurchasingOrganization | null |
| Master Data Relations | Join Conditions |
|---|---|
Purchase requisition unit of measure
| |
Cross-Plant Configurable Material
| |
Distribution channel for intercompany billing
| |
Division for intercompany billing
| |
Currency Key
| |
Material Number
| |
Material Group
| |
Material type
| |
Plant
| |
Purchasing Group
| |
Sales District
| |
Sales Organization for Intercompany Billing
|