I_PurgInfoRecordWithOrgData

DDL: I_PURGINFORECORDWITHORGDATA SQL: IINFRECWITHORG Type: view BASIC
105 Fields 2 Data Sources 2 Associations

Info Record with Org Plant Data

I_PurgInfoRecordWithOrgData is a Basic CDS View that provides data about "Info Record with Org Plant Data" in SAP S/4HANA. It reads from 2 data sources (I_PurgInfoRecdOrgPlantData, I_PurchasingInfoRecord) and exposes 105 fields with key fields PurchasingInfoRecord, PurchasingOrganization, PurchasingInfoRecordCategory, Plant. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData left_outer
I_PurchasingInfoRecord eina from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_PurInfCndPeriod _PurInfCndPeriod $projection.PurchasingInfoRecord = _PurInfCndPeriod.PurchasingInfoRecord and $projection.Plant = _PurInfCndPeriod.Plant and $projection.PurchasingOrganization = _PurInfCndPeriod.PurchasingOrganization and $projection.PurchasingInfoRecordCategory = _PurInfCndPeriod.PurchasingInfoRecordCategory
[0..1] E_PurchasingInforecord _PurchasingInforecordExtension _PurchasingInforecordExtension.PurchasingInfoRecord = $projection.PurchasingInfoRecord

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINFRECWITHORG view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Info Record with Org Plant Data view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (105)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord I_PurchasingInfoRecord PurchasingInfoRecord Info Record
KEY PurchasingOrganization I_PurgInfoRecdOrgPlantData PurchasingOrganization Purchasing Organization
KEY PurchasingInfoRecordCategory I_PurgInfoRecdOrgPlantData PurchasingInfoRecordCategory Infotype
KEY Plant I_PurgInfoRecdOrgPlantData Plant Valuation Area
Supplier Supplier Supplier
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
CreationDate I_PurgInfoRecdOrgPlantData CreationDate Time Stamp
IsDeleted IsDeleted TRUE
PurchasingInfoRecordDesc PurchasingInfoRecordDesc Info Short Text
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
Manufacturer Manufacturer Manufacturer
IsRegularSupplier IsRegularSupplier Reg. Supplier
SupplierSubrange SupplierSubrange Suppl. Subrange
NoDaysReminder1 NoDaysReminder1 1st Rem./Exped.
NoDaysReminder2 NoDaysReminder2 2nd Rem./Exped.
NoDaysReminder3 NoDaysReminder3 3rd Rem./Exped.
ProductPurchasePointsQty ProductPurchasePointsQty Points
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit Points Unit
ReturnAgreement ReturnAgreement Return Agmt
SupplierCertOriginCat SupplierCertOriginCat Certif. Cat.
SupplierCertOriginNumber SupplierCertOriginNumber Certificate
SupplierCertValidityEndDate SupplierCertValidityEndDate Valid to
SupplierCertOriginCountry SupplierCertOriginCountry C/R. of Origin
SupplierCertOriginRegion SupplierCertOriginRegion Region
SuplrCertOriginClassfctnNumber SuplrCertOriginClassfctnNumber Number
SupplierSubrangeSortNumber SupplierSubrangeSortNumber SSR Sort No.
LastChangeDateTime LastChangeDateTime Timestamp
PurgInfoRecNonStockItmSortTerm PurgInfoRecNonStockItmSortTerm Sort Term
SupplierQuotation I_PurgInfoRecdOrgPlantData SupplierQuotation RFQ
SupplierQuotationDate I_PurgInfoRecdOrgPlantData SupplierQuotationDate Quotation from
MinRemainingShelfLife I_PurgInfoRecdOrgPlantData MinRemainingShelfLife Rem. Shelf Life
ShippingInstruction I_PurgInfoRecdOrgPlantData ShippingInstruction Shipping Instr.
IsEvaluatedRcptSettlmtAllowed I_PurgInfoRecdOrgPlantData IsEvaluatedRcptSettlmtAllowed No ERS
IsPurOrderAllwdForInbDeliv I_PurgInfoRecdOrgPlantData IsPurOrderAllwdForInbDeliv Create Ref Doc
IsOrderAcknRqd I_PurgInfoRecdOrgPlantData IsOrderAcknRqd Acknowl. Reqd.
SupplierConfirmationControlKey I_PurgInfoRecdOrgPlantData SupplierConfirmationControlKey Conf. Control
MaterialRoundingProfile I_PurgInfoRecdOrgPlantData MaterialRoundingProfile Rnding Profile
MaterialStagingTime I_PurgInfoRecdOrgPlantData MaterialStagingTime Staging Time
ProductUnitGroup I_PurgInfoRecdOrgPlantData ProductUnitGroup UoM Group
IsRetMatlAuthznRqdBySupplier I_PurgInfoRecdOrgPlantData IsRetMatlAuthznRqdBySupplier RMA Required
IsCashDiscountGranted I_PurgInfoRecdOrgPlantData IsCashDiscountGranted No Cash Disc.
MaterialConditionGroup I_PurgInfoRecdOrgPlantData MaterialConditionGroup Condition Group
PricingDateControl I_PurgInfoRecdOrgPlantData PricingDateControl Pr. Date Cat.
IncotermsLocation2 I_PurgInfoRecdOrgPlantData IncotermsLocation2 Inco. Location2
IncotermsVersion I_PurgInfoRecdOrgPlantData IncotermsVersion Inco. Version
PurchasingDocumentDate I_PurgInfoRecdOrgPlantData PurchasingDocumentDate Document Date
CreatedByUser I_PurgInfoRecdOrgPlantData CreatedByUser User Name
IsMarkedForDeletion I_PurgInfoRecdOrgPlantData IsMarkedForDeletion Purch.org. data
PurchasingGroup I_PurgInfoRecdOrgPlantData PurchasingGroup Purchasing Group
ShelfLifeExpirationDatePeriod I_PurgInfoRecdOrgPlantData ShelfLifeExpirationDatePeriod Period Ind.
Currency I_PurgInfoRecdOrgPlantData Currency Valuation Crcy
MinimumPurchaseOrderQuantity I_PurgInfoRecdOrgPlantData MinimumPurchaseOrderQuantity Minimum Qty
StandardPurchaseOrderQuantity I_PurgInfoRecdOrgPlantData StandardPurchaseOrderQuantity Standard Qty
MaterialPlannedDeliveryDurn I_PurgInfoRecdOrgPlantData MaterialPlannedDeliveryDurn Pl. Deliv. Time
OverdelivTolrtdLmtRatioInPct I_PurgInfoRecdOrgPlantData OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnderdelivTolrtdLmtRatioInPct I_PurgInfoRecdOrgPlantData UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
UnlimitedOverdeliveryIsAllowed I_PurgInfoRecdOrgPlantData UnlimitedOverdeliveryIsAllowed Unlimited Tol.
LastReferencingPurchaseOrder I_PurgInfoRecdOrgPlantData LastReferencingPurchaseOrder Purchasing Doc.
LastReferencingPurOrderItem I_PurgInfoRecdOrgPlantData LastReferencingPurOrderItem Item
NetPriceAmount I_PurgInfoRecdOrgPlantData NetPriceAmount Net Price
MaterialPriceUnitQty I_PurgInfoRecdOrgPlantData MaterialPriceUnitQty Price unit
PurchaseOrderPriceUnit I_PurgInfoRecdOrgPlantData PurchaseOrderPriceUnit Order Price Un.
PriceValidityEndDate I_PurgInfoRecdOrgPlantData PriceValidityEndDate Valid to
OrderPriceUnitToOrderUnitNmrtr I_PurgInfoRecdOrgPlantData OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr I_PurgInfoRecdOrgPlantData OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
InvoiceIsGoodsReceiptBased I_PurgInfoRecdOrgPlantData InvoiceIsGoodsReceiptBased GR-Based IV
TaxCode I_PurgInfoRecdOrgPlantData TaxCode Tax Code
TimeDependentTaxValidFromDate I_PurgInfoRecdOrgPlantData TimeDependentTaxValidFromDate Tax Rate Valid-From
TaxCountry I_PurgInfoRecdOrgPlantData TaxCountry Tax Ctry/Reg.
IncotermsClassification I_PurgInfoRecdOrgPlantData IncotermsClassification Incoterms
IncotermsTransferLocation I_PurgInfoRecdOrgPlantData IncotermsTransferLocation Incoterms 2
IncotermsLocation1 I_PurgInfoRecdOrgPlantData IncotermsLocation1 Inco. Location1
IncotermsSupChnLoc1AddlUUID I_PurgInfoRecdOrgPlantData IncotermsSupChnLoc1AddlUUID Location UUID
IncotermsSupChnLoc2AddlUUID I_PurgInfoRecdOrgPlantData IncotermsSupChnLoc2AddlUUID Location UUID
IncotermsSupChnDvtgLocAddlUUID I_PurgInfoRecdOrgPlantData IncotermsSupChnDvtgLocAddlUUID Location UUID
MaximumOrderQuantity I_PurgInfoRecdOrgPlantData MaximumOrderQuantity Max. Quantity
IsRelevantForAutomSrcg I_PurgInfoRecdOrgPlantData IsRelevantForAutomSrcg Checkbox
_PurInfCndPeriod _PurInfCndPeriod
_PurchasingOrganization _PurchasingOrganization
_Plant _Plant
_PurchaseOrderPriceUnit _PurchaseOrderPriceUnit
_Currency _Currency
_PurchasingGroup _PurchasingGroup
_TaxCode _TaxCode
_IncotermsClassification _IncotermsClassification
_CreatedByUser _CreatedByUser
_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData
_Material _Material
_MaterialGroup _MaterialGroup
_Supplier _Supplier
_BaseUnit _BaseUnit
_PurgDocOrderQuantityUnit _PurgDocOrderQuantityUnit
_Country _Country

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 I_PurgInfoRecordWithOrgData.
-- 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: IINFRECWITHORG

CREATE VIEW I_PurgInfoRecordWithOrgData AS
SELECT
  eina.PurchasingInfoRecord AS PurchasingInfoRecord,
  _PurgInfoRecdOrgPlantData.PurchasingOrganization AS PurchasingOrganization,
  _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  _PurgInfoRecdOrgPlantData.Plant AS Plant,
  Supplier,
  Material,
  MaterialGroup,
  _PurgInfoRecdOrgPlantData.CreationDate AS CreationDate,
  IsDeleted,
  PurchasingInfoRecordDesc,
  PurgDocOrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  SupplierMaterialNumber,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  BaseUnit,
  SupplierMaterialGroup,
  PriorSupplier,
  AvailabilityStartDate,
  AvailabilityEndDate,
  VarblPurOrdUnitIsActive,
  Manufacturer,
  IsRegularSupplier,
  SupplierSubrange,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  ProductPurchasePointsQty,
  ProductPurchasePointsQtyUnit,
  ReturnAgreement,
  SupplierCertOriginCat,
  SupplierCertOriginNumber,
  SupplierCertValidityEndDate,
  SupplierCertOriginCountry,
  SupplierCertOriginRegion,
  SuplrCertOriginClassfctnNumber,
  SupplierSubrangeSortNumber,
  LastChangeDateTime,
  PurgInfoRecNonStockItmSortTerm,
  _PurgInfoRecdOrgPlantData.SupplierQuotation AS SupplierQuotation,
  _PurgInfoRecdOrgPlantData.SupplierQuotationDate AS SupplierQuotationDate,
  _PurgInfoRecdOrgPlantData.MinRemainingShelfLife AS MinRemainingShelfLife,
  _PurgInfoRecdOrgPlantData.ShippingInstruction AS ShippingInstruction,
  _PurgInfoRecdOrgPlantData.IsEvaluatedRcptSettlmtAllowed AS IsEvaluatedRcptSettlmtAllowed,
  _PurgInfoRecdOrgPlantData.IsPurOrderAllwdForInbDeliv AS IsPurOrderAllwdForInbDeliv,
  _PurgInfoRecdOrgPlantData.IsOrderAcknRqd AS IsOrderAcknRqd,
  _PurgInfoRecdOrgPlantData.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  _PurgInfoRecdOrgPlantData.MaterialRoundingProfile AS MaterialRoundingProfile,
  _PurgInfoRecdOrgPlantData.MaterialStagingTime AS MaterialStagingTime,
  _PurgInfoRecdOrgPlantData.ProductUnitGroup AS ProductUnitGroup,
  _PurgInfoRecdOrgPlantData.IsRetMatlAuthznRqdBySupplier AS IsRetMatlAuthznRqdBySupplier,
  _PurgInfoRecdOrgPlantData.IsCashDiscountGranted AS IsCashDiscountGranted,
  _PurgInfoRecdOrgPlantData.MaterialConditionGroup AS MaterialConditionGroup,
  _PurgInfoRecdOrgPlantData.PricingDateControl AS PricingDateControl,
  _PurgInfoRecdOrgPlantData.IncotermsLocation2 AS IncotermsLocation2,
  _PurgInfoRecdOrgPlantData.IncotermsVersion AS IncotermsVersion,
  _PurgInfoRecdOrgPlantData.PurchasingDocumentDate AS PurchasingDocumentDate,
  _PurgInfoRecdOrgPlantData.CreatedByUser AS CreatedByUser,
  _PurgInfoRecdOrgPlantData.IsMarkedForDeletion AS IsMarkedForDeletion,
  _PurgInfoRecdOrgPlantData.PurchasingGroup AS PurchasingGroup,
  _PurgInfoRecdOrgPlantData.ShelfLifeExpirationDatePeriod AS ShelfLifeExpirationDatePeriod,
  _PurgInfoRecdOrgPlantData.Currency AS Currency,
  _PurgInfoRecdOrgPlantData.MinimumPurchaseOrderQuantity AS MinimumPurchaseOrderQuantity,
  _PurgInfoRecdOrgPlantData.StandardPurchaseOrderQuantity AS StandardPurchaseOrderQuantity,
  _PurgInfoRecdOrgPlantData.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  _PurgInfoRecdOrgPlantData.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  _PurgInfoRecdOrgPlantData.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  _PurgInfoRecdOrgPlantData.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  _PurgInfoRecdOrgPlantData.LastReferencingPurchaseOrder AS LastReferencingPurchaseOrder,
  _PurgInfoRecdOrgPlantData.LastReferencingPurOrderItem AS LastReferencingPurOrderItem,
  _PurgInfoRecdOrgPlantData.NetPriceAmount AS NetPriceAmount,
  _PurgInfoRecdOrgPlantData.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  _PurgInfoRecdOrgPlantData.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  _PurgInfoRecdOrgPlantData.PriceValidityEndDate AS PriceValidityEndDate,
  _PurgInfoRecdOrgPlantData.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  _PurgInfoRecdOrgPlantData.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  _PurgInfoRecdOrgPlantData.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  _PurgInfoRecdOrgPlantData.TaxCode AS TaxCode,
  _PurgInfoRecdOrgPlantData.TimeDependentTaxValidFromDate AS TimeDependentTaxValidFromDate,
  _PurgInfoRecdOrgPlantData.TaxCountry AS TaxCountry,
  _PurgInfoRecdOrgPlantData.IncotermsClassification AS IncotermsClassification,
  _PurgInfoRecdOrgPlantData.IncotermsTransferLocation AS IncotermsTransferLocation,
  _PurgInfoRecdOrgPlantData.IncotermsLocation1 AS IncotermsLocation1,
  _PurgInfoRecdOrgPlantData.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  _PurgInfoRecdOrgPlantData.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  _PurgInfoRecdOrgPlantData.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  _PurgInfoRecdOrgPlantData.MaximumOrderQuantity AS MaximumOrderQuantity,
  _PurgInfoRecdOrgPlantData.IsRelevantForAutomSrcg AS IsRelevantForAutomSrcg
FROM I_PurchasingInfoRecord AS eina
LEFT OUTER JOIN I_PurgInfoRecdOrgPlantData AS _PurgInfoRecdOrgPlantData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurInfCndPeriod AS _PurInfCndPeriod ON PurchasingInfoRecord = _PurInfCndPeriod.PurchasingInfoRecord AND Plant = _PurInfCndPeriod.Plant AND PurchasingOrganization = _PurInfCndPeriod.PurchasingOrganization AND PurchasingInfoRecordCategory = _PurInfCndPeriod.PurchasingInfoRecordCategory  -- association [0..*]
LEFT OUTER JOIN E_PurchasingInforecord AS _PurchasingInforecordExtension ON _PurchasingInforecordExtension.PurchasingInfoRecord = PurchasingInfoRecord  -- association [0..1]
;

Learn More