I_MRPOUTLINEAGREEMENT
Basic Outline Agreement SOS
I_MRPOUTLINEAGREEMENT is a CDS View in S/4HANA. Basic Outline Agreement SOS. It contains 30 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MRPOutlineAgreementMPN | view | from | COMPOSITE | Outline Agreement with MPN |
Fields (30)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| AccountAssignmentCategory | AccountAssignmentCategory | 1 | |
| ConsumptionPosting | ConsumptionPosting | 1 | |
| GoodsReceiptDuration | GoodsReceiptDuration | 1 | |
| IssgOrRcvgStkIdfgSpclStkType | IssgOrRcvgStkIdfgSpclStkType | 1 | |
| IssuingOrReceivingStorageLoc | IssuingOrReceivingStorageLoc | 1 | |
| LeadingSalesOrder | LeadingSalesOrder | 1 | |
| LeadingSalesOrderItem | LeadingSalesOrderItem | 1 | |
| ManufacturerMaterial | ManufacturerMaterial | 1 | |
| Material | Material | 1 | |
| PlannedDeliveryDuration | PlannedDeliveryDuration | 1 | |
| PlndOrderReplnmtElmntType | PlndOrderReplnmtElmntType | 1 | |
| PreferredSupplier | PreferredSupplier | 1 | |
| ProductVariantGroup | ProductVariantGroup | 1 | |
| PurchasingDocument | PurchasingDocument | 1 | |
| PurchasingDocumentItem | PurchasingDocumentItem | 1 | |
| PurchasingDocumentItemCategory | PurchasingDocumentItemCategory | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingObjectCategory | PurchasingObjectCategory | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| PurchasingProcessingStatus | PurchasingProcessingStatus | 1 | |
| PurgDocHasPlant | PurgDocHasPlant | 1 | |
| PurgDocReceivingSupplier | PurgDocReceivingSupplier | 1 | |
| PurgDocSupplyingPlant | PurgDocSupplyingPlant | 1 | |
| RoundingProfile | RoundingProfile | 1 | |
| ScheduleAgreementHasReleaseDoc | ScheduleAgreementHasReleaseDoc | 1 | |
| StorageLocation | StorageLocation | 1 | |
| SupplierIsSubcontractor | SupplierIsSubcontractor | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 | |
| WBSElementInternalID | WBSElementInternalID | 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.
-- Basic Outline Agreement SOS
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPOUTLINEAGREEMENT (
ACCOUNTASSIGNMENTCATEGORY,
CONSUMPTIONPOSTING,
GOODSRECEIPTDURATION,
ISSGORRCVGSTKIDFGSPCLSTKTYPE,
ISSUINGORRECEIVINGSTORAGELOC,
LEADINGSALESORDER,
LEADINGSALESORDERITEM,
MANUFACTURERMATERIAL,
MATERIAL,
PLANNEDDELIVERYDURATION,
PLNDORDERREPLNMTELMNTTYPE,
PREFERREDSUPPLIER,
PRODUCTVARIANTGROUP,
PURCHASINGDOCUMENT,
PURCHASINGDOCUMENTITEM,
PURCHASINGDOCUMENTITEMCATEGORY,
PURCHASINGGROUP,
PURCHASINGOBJECTCATEGORY,
PURCHASINGORGANIZATION,
PURCHASINGPROCESSINGSTATUS,
PURGDOCHASPLANT,
PURGDOCRECEIVINGSUPPLIER,
PURGDOCSUPPLYINGPLANT,
ROUNDINGPROFILE,
SCHEDULEAGREEMENTHASRELEASEDOC,
STORAGELOCATION,
SUPPLIERISSUBCONTRACTOR,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
WBSELEMENTINTERNALID
);
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