R_PURGDOCSUBCONTRGCOMPONENT
Internal Basic View for Subcontracting Components
R_PURGDOCSUBCONTRGCOMPONENT is a CDS View in S/4HANA. Internal Basic View for Subcontracting Components. It contains 59 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SchedgAgrmtSubcontrgComp | view | from | BASIC | Internal Basic View for SA Subcontracting Components |
| R_POSubcontractingComponent | view | from | BASIC | Internal Basic View for PO Subcontracting Components |
| R_STOSubcontractingComponent | view_entity | from | BASIC | Subcontracting Component for STO |
Fields (59)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | RecordType | RecordType | 1 |
| KEY | ReservationItem | ReservationItem | 1 |
| KEY | ScheduleLine | ScheduleLine | 1 |
| _BaseUnit | _BaseUnit | 1 | |
| _EntryUnit | _EntryUnit | 1 | |
| _Material | _Material | 1 | |
| _Product | _Product | 1 | |
| _VariableSize1To3Unit | _VariableSize1To3Unit | 1 | |
| _VariableSizeCompUnit | _VariableSizeCompUnit | 1 | |
| AccountAssignmentCategory | AccountAssignmentCategory | 1 | |
| BaseUnit | BaseUnit | 1 | |
| Batch | Batch | 1 | |
| BOMItemCategory | BOMItemCategory | 1 | |
| BOMItemDescription | BOMItemDescription | 1 | |
| BOMItemText2 | BOMItemText2 | 1 | |
| ChangeNumber | ChangeNumber | 1 | |
| ComponentScrapInPercent | ComponentScrapInPercent | 1 | |
| ConsumptionPosting | ConsumptionPosting | 1 | |
| DebitCreditCode | DebitCreditCode | 1 | |
| EntryUnit | EntryUnit | 1 | |
| FormulaKey | FormulaKey | 1 | |
| InventorySpecialStockType | InventorySpecialStockType | 1 | |
| InventorySpecialStockValnType | InventorySpecialStockValnType | 1 | |
| IsBulkMaterialComponent | IsBulkMaterialComponent | 1 | |
| IsNetScrap | IsNetScrap | 1 | |
| LatestRequirementDate | LatestRequirementDate | 1 | |
| LeadTimeOffset | LeadTimeOffset | 1 | |
| Material | Product | 1 | |
| MaterialCompIsVariableSized | MaterialCompIsVariableSized | 1 | |
| MaterialComponentIsPhantomItem | MaterialComponentIsPhantomItem | 1 | |
| MaterialProvisionType | MaterialProvisionType | 1 | |
| MaterialQtyToBaseQtyDnmntr | MaterialQtyToBaseQtyDnmntr | 1 | |
| MaterialQtyToBaseQtyNmrtr | MaterialQtyToBaseQtyNmrtr | 1 | |
| MatlCompFreeDefinedAttribute | MatlCompFreeDefinedAttribute | 1 | |
| OperationScrapInPercent | OperationScrapInPercent | 1 | |
| OrderLevelValue | OrderLevelValue | 1 | |
| OrderPathValue | OrderPathValue | 1 | |
| Plant | Plant | 1 | |
| ProductionSupplyArea | ProductionSupplyArea | 1 | |
| QuantityDistributionKey | QuantityDistributionKey | 1 | |
| QuantityInEntryUnit | QuantityInEntryUnit | 1 | |
| QuantityIsFixed | QuantityIsFixed | 1 | |
| RequiredQuantity | RequiredQuantity | 1 | |
| RequirementDate | RequirementDate | 1 | |
| RequirementTime | RequirementTime | 1 | |
| Reservation | Reservation | 1 | |
| ReservationIsFinallyIssued | ReservationIsFinallyIssued | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| Size1 | Size1 | 1 | |
| Size2 | Size2 | 1 | |
| Size3 | Size3 | 1 | |
| StorageLocation | StorageLocation | 1 | |
| UnitOfMeasureForSize1To3 | UnitOfMeasureForSize1To3 | 1 | |
| VariableSizeComponentQuantity | VariableSizeComponentQuantity | 1 | |
| VariableSizeComponentUnit | VariableSizeComponentUnit | 1 | |
| VariableSizeItemQuantity | VariableSizeItemQuantity | 1 | |
| VariableSizeItemUnit | VariableSizeItemUnit | 1 | |
| WithdrawnQuantity | WithdrawnQuantity | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Internal Basic View for Subcontracting Components
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_PURGDOCSUBCONTRGCOMPONENT (
RECORDTYPE,
RESERVATIONITEM,
SCHEDULELINE,
_BASEUNIT,
_ENTRYUNIT,
_MATERIAL,
_PRODUCT,
_VARIABLESIZE1TO3UNIT,
_VARIABLESIZECOMPUNIT,
ACCOUNTASSIGNMENTCATEGORY,
BASEUNIT,
BATCH,
BOMITEMCATEGORY,
BOMITEMDESCRIPTION,
BOMITEMTEXT2,
CHANGENUMBER,
COMPONENTSCRAPINPERCENT,
CONSUMPTIONPOSTING,
DEBITCREDITCODE,
ENTRYUNIT,
FORMULAKEY,
INVENTORYSPECIALSTOCKTYPE,
INVENTORYSPECIALSTOCKVALNTYPE,
ISBULKMATERIALCOMPONENT,
ISNETSCRAP,
LATESTREQUIREMENTDATE,
LEADTIMEOFFSET,
MATERIAL,
MATERIALCOMPISVARIABLESIZED,
MATERIALCOMPONENTISPHANTOMITEM,
MATERIALPROVISIONTYPE,
MATERIALQTYTOBASEQTYDNMNTR,
MATERIALQTYTOBASEQTYNMRTR,
MATLCOMPFREEDEFINEDATTRIBUTE,
OPERATIONSCRAPINPERCENT,
ORDERLEVELVALUE,
ORDERPATHVALUE,
PLANT,
PRODUCTIONSUPPLYAREA,
QUANTITYDISTRIBUTIONKEY,
QUANTITYINENTRYUNIT,
QUANTITYISFIXED,
REQUIREDQUANTITY,
REQUIREMENTDATE,
REQUIREMENTTIME,
RESERVATION,
RESERVATIONISFINALLYISSUED,
SALESORDER,
SALESORDERITEM,
SIZE1,
SIZE2,
SIZE3,
STORAGELOCATION,
UNITOFMEASUREFORSIZE1TO3,
VARIABLESIZECOMPONENTQUANTITY,
VARIABLESIZECOMPONENTUNIT,
VARIABLESIZEITEMQUANTITY,
VARIABLESIZEITEMUNIT,
WITHDRAWNQUANTITY,
PRIMARY KEY (RECORDTYPE, RESERVATIONITEM, SCHEDULELINE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA