C_InfoRecordManageSosAll_Text

DDL: C_INFORECORDMANAGESOSALL_TEXT SQL: CIRMNGALLTXT Type: view CONSUMPTION Package: ODATA_MM_PUR_SOS_MANAGE
57 Fields 1 Data Sources 2 Associations

Info Record Manage SoS All Text

C_InfoRecordManageSosAll_Text is a Consumption CDS View that provides data about "Info Record Manage SoS All Text" in SAP S/4HANA. It reads from 1 data source (P_InfoRecordManageSOSAll) and exposes 57 fields with key field Guid. It has 2 associations to related views. Part of development package ODATA_MM_PUR_SOS_MANAGE.

Data Sources (1)

SourceAliasJoin Type
P_InfoRecordManageSOSAll InfoRecord from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_MaterialText _MaterialText InfoRecord.Material = _MaterialText.Material
[1..*] I_MaterialGroupText _MaterialGroupText InfoRecord.MaterialGroup = _MaterialGroupText.MaterialGroup association[0..1] to I_PurchasingOrganization as _PurchOrg on InfoRecord.PurchasingOrganization = _PurchOrg.PurchasingOrganization

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CIRMNGALLTXT view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Info Record Manage SoS All Text 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 SupplierName Supplier Name
Material Material Vehicle Model
EditState Entitystate Single-Character Flag
MaterialGroup MaterialGroup Product Group
IsDeleted GeneralDataDeleted
PurchasingInfoRecordDesc PurchasingInfoRecordDesc Info Short Text
PurchasingOrganizationName _PurchOrg PurchasingOrganizationName Purch. Org. Name
PlantName PlantName Plant Name
PurgDocOrderQuantityUnit OrderUnit Commercial
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
SupplierRespSalesPersonName SalesPerson
SupplierPhoneNumber SupplierPhoneNumber Telephone
BaseUnit BaseUnit Unit of Measure
SupplierMaterialGroup SupplierMaterialGroup Suppl. Mat. Grp
PriorSupplier PriorSupplier Prior Supplier
AvailabilityStartDate AvailableFromDate
AvailabilityEndDate AvailableToDate
VarblPurOrdUnitIsActive vabme Var. Order Unit
IsRegularSupplier relif 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 uebtk Unlimited Tol.
LastReferencingPurchaseOrder ebeln Source PurchDoc
LastReferencingPurOrderItem ebelp Item pur. doc.
NetPriceAmount NetPriceAmount Net Price
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
PurchaseOrderPriceUnit PurchaseOrderPriceUnit Order Price Un.
PriceValidityEndDate PriceValidityEndDate Valid to
OrderPriceUnitToOrderUnitNmrtr bpumz Qty Conversion
OrdPriceUnitToOrderUnitDnmntr bpumn Qty Conversion
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
TaxCode TaxCode Tax Code
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
MaximumOrderQuantity MaximumOrderQuantity Max. Quantity
IsRelevantForAutomSrcg IsRelevantForAutomSrcg Checkbox
CreatedByUser DraftCreator User ID
CreatedByUserFullName DraftCreatorName
CreationDateTime DraftCreationDate
LastChangeDateTime DraftChangeDate
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_InfoRecordManageSosAll_Text.
-- 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: CIRMNGALLTXT

CREATE VIEW C_InfoRecordManageSosAll_Text AS
SELECT
  Guid,
  PurchasingInfoRecord,
  PurchasingOrganization,
  Plant,
  PurchasingInfoRecordCategory,
  Supplier,
  SupplierName,
  Material,
  Entitystate AS EditState,
  MaterialGroup,
  GeneralDataDeleted AS IsDeleted,
  PurchasingInfoRecordDesc,
  _PurchOrg.PurchasingOrganizationName AS PurchasingOrganizationName,
  PlantName,
  OrderUnit AS PurgDocOrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  SupplierMaterialNumber,
  SalesPerson AS SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  BaseUnit,
  SupplierMaterialGroup,
  PriorSupplier,
  AvailableFromDate AS AvailabilityStartDate,
  AvailableToDate AS AvailabilityEndDate,
  vabme AS VarblPurOrdUnitIsActive,
  relif AS IsRegularSupplier,
  IsMarkedForDeletion,
  PurchasingGroup,
  Currency,
  MinimumPurchaseOrderQuantity,
  StandardPurchaseOrderQuantity,
  MaterialPlannedDeliveryDurn,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  uebtk AS UnlimitedOverdeliveryIsAllowed,
  ebeln AS LastReferencingPurchaseOrder,
  ebelp AS LastReferencingPurOrderItem,
  NetPriceAmount,
  MaterialPriceUnitQty,
  PurchaseOrderPriceUnit,
  PriceValidityEndDate,
  bpumz AS OrderPriceUnitToOrderUnitNmrtr,
  bpumn AS OrdPriceUnitToOrderUnitDnmntr,
  InvoiceIsGoodsReceiptBased,
  TaxCode,
  IncotermsClassification,
  IncotermsTransferLocation,
  MaximumOrderQuantity,
  IsRelevantForAutomSrcg,
  DraftCreator AS CreatedByUser,
  DraftCreatorName AS CreatedByUserFullName,
  DraftCreationDate AS CreationDateTime,
  DraftChangeDate AS LastChangeDateTime,
  IsActiveEntity
FROM P_InfoRecordManageSOSAll AS InfoRecord
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON InfoRecord.Material = _MaterialText.Material  -- association [1..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON InfoRecord.MaterialGroup = _MaterialGroupText.MaterialGroup association[0..1] to I_PurchasingOrganization as _PurchOrg on InfoRecord.PurchasingOrganization = _PurchOrg.PurchasingOrganization  -- association [1..*]
;

Learn More