I_PURGINFORECORDWITHORGDATA

CDS View

Info Record with Org Plant Data

I_PURGINFORECORDWITHORGDATA is a CDS View in S/4HANA. Info Record with Org Plant Data. It contains 25 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 25 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_PPS_PurchaseReqnInfoRecordVH view_entity from CONSUMPTION Info record in PurReqn SoS
C_PurchaseReqnInfoRecordVH view from CONSUMPTION Info record value help in PurReqn
ESH_N_PURCHASE_INFO_REC view from
I_SourcesOfSupply view union_all COMPOSITE Sources of Supply
P_DDMaterialSOS view inner CONSUMPTION
P_PurchasingInfoRecMassUpdate view union CONSUMPTION Union of General and Org. Data
P_PurgInfoRecordWithOrgData view from COMPOSITE
P_PurInfoRecdPrHist view from CONSUMPTION Private View for Purchasing Info Record Price History
P_SourceOfSupply view union_all CONSUMPTION Source of Supply
P_SourcesOfSupply view union COMPOSITE

Fields (25)

KeyField CDS FieldsUsed in Views
KEY Material ManufacturerMaterial,Material 4
KEY Plant Plant 4
KEY PurchasingInfoRecord PurchasingInfoRecord,SourceDocument 3
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory,PurInfoRecordCat 3
KEY PurchasingOrganization PurchasingOrganization 5
AvailabilityEndDate AvailabilityEndDate,ValidityEndDate 4
AvailabilityStartDate AvailabilityStartDate,ValidityStartDate 4
CreationDate CreationDate 2
Currency Currency 2
IncotermsClassification IncotermsClassification 1
IsDeleted IsDeleted 1
Manufacturer Manufacturer 1
MaterialGroup MaterialGroup 3
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 1
NetPriceAmount NetPriceAmount 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
PricingDateControl PricingDateControl 1
PriorSupplier PriorSupplier 1
PurchasingGroup PurchasingGroup 3
PurgDocOrderQuantityUnit BaseUnit,OrderQuantityUnit 2
Supplier Supplier 4
SupplierMaterialNumber SupplierMaterialNumber 1
SupplierSubrange SupplierSubrange 1
TaxCode TaxCode 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 1 
@AbapCatalog.sqlViewName: 'IINFRECWITHORG'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Info Record with Org Plant Data'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurgInfoRecordWithOrgData
  as select from    I_PurchasingInfoRecord     as eina

    left outer join I_PurgInfoRecdOrgPlantData as _PurgInfoRecdOrgPlantData on eina.PurchasingInfoRecord = _PurgInfoRecdOrgPlantData.PurchasingInfoRecord

  association [0..*] to I_PurInfCndPeriod as _PurInfCndPeriod on  $projection.PurchasingInfoRecord         = _PurInfCndPeriod.PurchasingInfoRecord
                                                              and $projection.Plant                        = _PurInfCndPeriod.Plant
                                                              and $projection.PurchasingOrganization       = _PurInfCndPeriod.PurchasingOrganization
                                                              and $projection.PurchasingInfoRecordCategory = _PurInfCndPeriod.PurchasingInfoRecordCategory
  
  association [0..1] to E_PurchasingInforecord     as _PurchasingInforecordExtension on  _PurchasingInforecordExtension.PurchasingInfoRecord = $projection.PurchasingInfoRecord            
              
{
  key eina.PurchasingInfoRecord                              as PurchasingInfoRecord,

  key _PurgInfoRecdOrgPlantData.PurchasingOrganization       as PurchasingOrganization,

  key _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory as PurchasingInfoRecordCategory,

  key _PurgInfoRecdOrgPlantData.Plant,

      Supplier,

      Material,

      MaterialGroup,

//      @Semantics.businessDate.createdAt

      CreationDate,

      IsDeleted,

      PurchasingInfoRecordDesc,

      @Semantics.unitOfMeasure: true
      PurgDocOrderQuantityUnit,

      OrderItemQtyToBaseQtyNmrtr,

      OrderItemQtyToBaseQtyDnmntr,

      SupplierMaterialNumber,

      SupplierRespSalesPersonName,

      SupplierPhoneNumber,

      @Semantics.unitOfMeasure: true
      BaseUnit,

      SupplierMaterialGroup,

      PriorSupplier,

      @Semantics.businessDate.from
      AvailabilityStartDate,

//      @Semantics.businessDate.to

      AvailabilityEndDate,

      VarblPurOrdUnitIsActive,

      Manufacturer,

      IsRegularSupplier,

      SupplierSubrange,

      NoDaysReminder1,

      NoDaysReminder2,

      NoDaysReminder3,

      ProductPurchasePointsQty,

      ProductPurchasePointsQtyUnit,

      ReturnAgreement,

      SupplierCertOriginCat,

      SupplierCertOriginNumber,

      SupplierCertValidityEndDate,

      SupplierCertOriginCountry,

      SupplierCertOriginRegion,

      SuplrCertOriginClassfctnNumber,

      SupplierSubrangeSortNumber,

      LastChangeDateTime,
      
      //Sort Term

      PurgInfoRecNonStockItmSortTerm,

      _PurgInfoRecdOrgPlantData.SupplierQuotation,

      _PurgInfoRecdOrgPlantData.SupplierQuotationDate,

      _PurgInfoRecdOrgPlantData.MinRemainingShelfLife,

      _PurgInfoRecdOrgPlantData.ShippingInstruction,

      _PurgInfoRecdOrgPlantData.IsEvaluatedRcptSettlmtAllowed,

      _PurgInfoRecdOrgPlantData.IsPurOrderAllwdForInbDeliv,

      _PurgInfoRecdOrgPlantData.IsOrderAcknRqd,

      _PurgInfoRecdOrgPlantData.SupplierConfirmationControlKey,

      _PurgInfoRecdOrgPlantData.MaterialRoundingProfile,

      _PurgInfoRecdOrgPlantData.MaterialStagingTime,

      _PurgInfoRecdOrgPlantData.ProductUnitGroup,

      _PurgInfoRecdOrgPlantData.IsRetMatlAuthznRqdBySupplier,

      _PurgInfoRecdOrgPlantData.IsCashDiscountGranted,

      _PurgInfoRecdOrgPlantData.MaterialConditionGroup,

      _PurgInfoRecdOrgPlantData.PricingDateControl,

      _PurgInfoRecdOrgPlantData.IncotermsLocation2,

      _PurgInfoRecdOrgPlantData.IncotermsVersion,

      _PurgInfoRecdOrgPlantData.PurchasingDocumentDate,

      _PurgInfoRecdOrgPlantData.CreatedByUser,

      _PurgInfoRecdOrgPlantData.IsMarkedForDeletion,

      _PurgInfoRecdOrgPlantData.PurchasingGroup,

      _PurgInfoRecdOrgPlantData.ShelfLifeExpirationDatePeriod,

      @Semantics.currencyCode:true
      _PurgInfoRecdOrgPlantData.Currency,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.MinimumPurchaseOrderQuantity,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.StandardPurchaseOrderQuantity,

      _PurgInfoRecdOrgPlantData.MaterialPlannedDeliveryDurn,

      _PurgInfoRecdOrgPlantData.OverdelivTolrtdLmtRatioInPct,

      _PurgInfoRecdOrgPlantData.UnderdelivTolrtdLmtRatioInPct,

      _PurgInfoRecdOrgPlantData.UnlimitedOverdeliveryIsAllowed,

      _PurgInfoRecdOrgPlantData.LastReferencingPurchaseOrder,

      _PurgInfoRecdOrgPlantData.LastReferencingPurOrderItem,

      @Semantics.amount.currencyCode: 'Currency'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.NetPriceAmount,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.MaterialPriceUnitQty,

      @Semantics.unitOfMeasure: true
      _PurgInfoRecdOrgPlantData.PurchaseOrderPriceUnit,

      //      @Semantics.businessDate.to

      _PurgInfoRecdOrgPlantData.PriceValidityEndDate,

      _PurgInfoRecdOrgPlantData.OrderPriceUnitToOrderUnitNmrtr,

      _PurgInfoRecdOrgPlantData.OrdPriceUnitToOrderUnitDnmntr,

      _PurgInfoRecdOrgPlantData.InvoiceIsGoodsReceiptBased,

      _PurgInfoRecdOrgPlantData.TaxCode,
      
      _PurgInfoRecdOrgPlantData.TimeDependentTaxValidFromDate,
      
      _PurgInfoRecdOrgPlantData.TaxCountry,

      _PurgInfoRecdOrgPlantData.IncotermsClassification,

      _PurgInfoRecdOrgPlantData.IncotermsTransferLocation,

      _PurgInfoRecdOrgPlantData.IncotermsLocation1,
      
  //    _PurgInfoRecdOrgPlantData.PurgInfoRecordIncotermsLocID1,

      _PurgInfoRecdOrgPlantData.IncotermsSupChnLoc1AddlUUID,
      _PurgInfoRecdOrgPlantData.IncotermsSupChnLoc2AddlUUID,
      _PurgInfoRecdOrgPlantData.IncotermsSupChnDvtgLocAddlUUID,
  //    _PurgInfoRecdOrgPlantData.PurgInfoRecordIncotermsLocID2,

      
   //   _PurgInfoRecdOrgPlantData.PurgInfoRecordDvtgDestID,

      
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
//      @DefaultAggregation: #NONE

      _PurgInfoRecdOrgPlantData.MaximumOrderQuantity,

      _PurgInfoRecdOrgPlantData.IsRelevantForAutomSrcg,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD ]
      _PurInfCndPeriod,

      _PurchasingOrganization,
      _Plant,
      _PurchaseOrderPriceUnit,
      _Currency,
      _PurchasingGroup,
      _TaxCode,
     
      _IncotermsClassification,
      _CreatedByUser,

      _PurgInfoRecdOrgPlantData,
      _Material,
      _MaterialGroup,
      _Supplier,
      _BaseUnit,
      _PurgDocOrderQuantityUnit,
      _Country
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGINFORECORD",
"I_PURGINFORECDORGPLANTDATA"
],
"ASSOCIATED":
[
"E_PURCHASINGINFORECORD",
"I_COUNTRY",
"I_CURRENCY",
"I_INCOTERMSCLASSIFICATION",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_PURGINFORECDORGPLANTDATA",
"I_PURINFCNDPERIOD",
"I_SUPPLIER",
"I_TAXCODE",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_PURCHASINGINFORECORD",
"I_PURGINFORECDORGPLANTDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More