C_InfoRecordManageSosOverview

DDL: C_INFORECORDMANAGESOSOVERVIEW SQL: CIRMNGSOSOVW Type: view CONSUMPTION
57 Fields 1 Data Sources 4 Associations

Info Record Manage SoS Overview

C_InfoRecordManageSosOverview is a Consumption CDS View that provides data about "Info Record Manage SoS Overview" in SAP S/4HANA. It reads from 1 data source (C_InfoRecordManageSosAll_Text) and exposes 57 fields with key field Guid. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
C_InfoRecordManageSosAll_Text InfoRecords from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_PurchasingInforecord _PurchasingInforecordExtension $projection.PurchasingInfoRecord = _PurchasingInforecordExtension .PurchasingInfoRecord
[0..1] E_Inforecordmanagesosdraft _InforecorddraftExtension $projection.Guid = _InforecorddraftExtension.PurchasingInfoRecordDraftUUID
[0..1] E_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantExtension $projection.PurchasingInfoRecord = _PurgInfoRecdOrgPlantExtension.PurchasingInfoRecord and $projection.PurchasingOrganization = _PurgInfoRecdOrgPlantExtension.PurchasingOrganization and $projection.Plant = _PurgInfoRecdOrgPlantExtension.Plant and $projection.PurchasingInfoRecordCategory = _PurgInfoRecdOrgPlantExtension.PurchasingInfoRecordCategory
[0..1] E_PurgInfoRecdOrgPlantDatadrft _PurgInfoRecdOrgPlantDrftExt $projection.Guid = _PurgInfoRecdOrgPlantDrftExt.PurgInfoRecdOrgPlantDraftUUID

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CIRMNGSOSOVW view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Info Record Manage SoS Overview view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY Guid Guid UUID 22 char.
PurchasingInfoRecord PurchasingInfoRecord Info Record
PurchasingOrganization PurchasingOrganization Purchasing Organization
Plant Plant Valuation Area
PurchasingInfoRecordCategory PurchasingInfoRecordCategory Infotype
Supplier Supplier Supplier
SupplierName Supplier Name
Material Material Vehicle Model
EditState EditState Single-Character Flag
MaterialGroup MaterialGroup Product Group
IsDeleted IsDeleted TRUE
PurchasingInfoRecordDesc PurchasingInfoRecordDesc Info Short Text
PurchasingOrganizationName Purch. Org. Name
PlantName PlantName Plant Name
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
SupplierRespSalesPersonName SupplierRespSalesPersonName Salesperson
SupplierPhoneNumber SupplierPhoneNumber Telephone
BaseUnit BaseUnit Unit of Measure
SupplierMaterialGroup SupplierMaterialGroup Suppl. Mat. Grp
PriorSupplier PriorSupplier Prior Supplier
AvailabilityStartDate AvailabilityStartDate Available from
AvailabilityEndDate AvailabilityEndDate Available to
VarblPurOrdUnitIsActive VarblPurOrdUnitIsActive Var. Order Unit
IsRegularSupplier IsRegularSupplier Reg. Supplier
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
PurchasingGroup PurchasingGroup Purchasing Group
Currency Currency Valuation Crcy
MinimumPurchaseOrderQuantity MinimumPurchaseOrderQuantity Minimum Qty
StandardPurchaseOrderQuantity StandardPurchaseOrderQuantity Standard Qty
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn Pl. Deliv. Time
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed Unlimited Tol.
LastReferencingPurchaseOrder LastReferencingPurchaseOrder Purchasing Doc.
LastReferencingPurOrderItem LastReferencingPurOrderItem Item
NetPriceAmount NetPriceAmount Net Price
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
PurchaseOrderPriceUnit PurchaseOrderPriceUnit Order Price Un.
PriceValidityEndDate PriceValidityEndDate Valid to
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
TaxCode TaxCode Tax Code
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
MaximumOrderQuantity MaximumOrderQuantity Max. Quantity
IsRelevantForAutomSrcg IsRelevantForAutomSrcg Checkbox
CreatedByUser CreatedByUser User Name
CreatedByUserFullName CreatedByUserFullName Description
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
IsActiveEntity IsActiveEntity Is active
_MaterialText _MaterialText
_MaterialGroupText _MaterialGroupText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_InfoRecordManageSosOverview.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CIRMNGSOSOVW

CREATE VIEW C_InfoRecordManageSosOverview AS
SELECT
  Guid,
  PurchasingInfoRecord,
  PurchasingOrganization,
  Plant,
  PurchasingInfoRecordCategory,
  Supplier,
  cast (SupplierName as mm_sos_supplier_name) AS SupplierName,
  Material,
  EditState,
  MaterialGroup,
  IsDeleted,
  PurchasingInfoRecordDesc,
  cast (PurchasingOrganizationName as mm_sos_purg_org_name) AS PurchasingOrganizationName,
  PlantName,
  PurgDocOrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  SupplierMaterialNumber,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  BaseUnit,
  SupplierMaterialGroup,
  PriorSupplier,
  AvailabilityStartDate,
  AvailabilityEndDate,
  VarblPurOrdUnitIsActive,
  IsRegularSupplier,
  IsMarkedForDeletion,
  PurchasingGroup,
  Currency,
  MinimumPurchaseOrderQuantity,
  StandardPurchaseOrderQuantity,
  MaterialPlannedDeliveryDurn,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  LastReferencingPurchaseOrder,
  LastReferencingPurOrderItem,
  NetPriceAmount,
  MaterialPriceUnitQty,
  PurchaseOrderPriceUnit,
  PriceValidityEndDate,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  InvoiceIsGoodsReceiptBased,
  TaxCode,
  IncotermsClassification,
  IncotermsTransferLocation,
  MaximumOrderQuantity,
  IsRelevantForAutomSrcg,
  CreatedByUser,
  CreatedByUserFullName,
  CreationDateTime,
  LastChangeDateTime,
  IsActiveEntity
FROM C_InfoRecordManageSosAll_Text AS InfoRecords
LEFT OUTER JOIN E_PurchasingInforecord AS _PurchasingInforecordExtension ON PurchasingInfoRecord = _PurchasingInforecordExtension .PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN E_Inforecordmanagesosdraft AS _InforecorddraftExtension ON Guid = _InforecorddraftExtension.PurchasingInfoRecordDraftUUID  -- association [0..1]
LEFT OUTER JOIN E_PurgInfoRecdOrgPlantData AS _PurgInfoRecdOrgPlantExtension ON PurchasingInfoRecord = _PurgInfoRecdOrgPlantExtension.PurchasingInfoRecord AND PurchasingOrganization = _PurgInfoRecdOrgPlantExtension.PurchasingOrganization AND Plant = _PurgInfoRecdOrgPlantExtension.Plant AND PurchasingInfoRecordCategory = _PurgInfoRecdOrgPlantExtension.PurchasingInfoRecordCategory  -- association [0..1]
LEFT OUTER JOIN E_PurgInfoRecdOrgPlantDatadrft AS _PurgInfoRecdOrgPlantDrftExt ON Guid = _PurgInfoRecdOrgPlantDrftExt.PurgInfoRecdOrgPlantDraftUUID  -- association [0..1]
;

Learn More