R_PurgInfoRecdOrgPlntDataTP

DDL: R_PURGINFORECDORGPLNTDATATP Type: view_entity TRANSACTIONAL

Purchasing Info Rec Org Plant Data

R_PurgInfoRecdOrgPlntDataTP is a Transactional CDS View that provides data about "Purchasing Info Rec Org Plant Data" in SAP S/4HANA. It reads from 1 data source (I_PurgInfoRecdOrgPlantData) and exposes 62 fields with key fields PurchasingInfoRecord, PurchasingInfoRecordCategory, PurchasingOrganization, Plant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurgInfoRecdOrgPlantData I_PurgInfoRecdOrgPlantData from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_PurgInfoRecdPrcgCndnValdtyTP _PurgInfoRecdPrcgCndnValdty

Annotations (8)

NameValueLevelField
EndUserText.label Purchasing Info Rec Org Plant Data view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord PurchasingInfoRecord
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory
KEY PurchasingOrganization PurchasingOrganization
KEY Plant Plant
CreatedByUser CreatedByUser
IsMarkedForDeletion IsMarkedForDeletion
PurchasingGroup PurchasingGroup
Currency Currency
MinimumPurchaseOrderQuantity MinimumPurchaseOrderQuantity
StandardPurchaseOrderQuantity StandardPurchaseOrderQuantity
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed
LastReferencingPurchaseOrder LastReferencingPurchaseOrder
LastReferencingPurOrderItem LastReferencingPurOrderItem
NetPriceAmount NetPriceAmount
MaterialPriceUnitQty MaterialPriceUnitQty
PurchaseOrderPriceUnit PurchaseOrderPriceUnit
PriceValidityEndDate PriceValidityEndDate
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased
TaxCode TaxCode
MaterialRoundingProfile MaterialRoundingProfile
MatlMstrTxtIsNotRlvtForPOItm MatlMstrTxtIsNotRlvtForPOItm
ShippingInstruction ShippingInstruction
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsLocation1 IncotermsLocation1
MaximumOrderQuantity MaximumOrderQuantity
IsRelevantForAutomSrcg IsRelevantForAutomSrcg
SupplierQuotation SupplierQuotation
SupplierQuotationDate SupplierQuotationDate
MinRemainingShelfLife MinRemainingShelfLife
IsEvaluatedRcptSettlmtAllowed IsEvaluatedRcptSettlmtAllowed
IsPurOrderAllwdForInbDeliv IsPurOrderAllwdForInbDeliv
IsOrderAcknRqd IsOrderAcknRqd
IsRetMatlAuthznRqdBySupplier IsRetMatlAuthznRqdBySupplier
IsCashDiscountGranted IsCashDiscountGranted
MaterialConditionGroup MaterialConditionGroup
PurchasingDocumentDate PurchasingDocumentDate
ShelfLifeExpirationDatePeriod
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
SupplierConfirmationControlKey SupplierConfirmationControlKey
PricingDateControl PricingDateControl
TimeDependentTaxValidFromDate TimeDependentTaxValidFromDate
TaxCountry TaxCountry
Material _PurchasingInfoRecord Material
MaterialGroup _PurchasingInfoRecord MaterialGroup
Supplier _PurchasingInfoRecord Supplier
PurgDocOrderQuantityUnit _PurchasingInfoRecord PurgDocOrderQuantityUnit
LastChangeDateTime _PurchasingInfoRecord LastChangeDateTime
_PurgInfoRecdPrcgCndnValdty _PurgInfoRecdPrcgCndnValdty
_PurchasingInfoRecord _PurchasingInfoRecord
_Country _Country
_CreatedByUser _CreatedByUser
_Currency _Currency
_IncotermsClassification _IncotermsClassification
_Plant _Plant
_PurchaseOrderPriceUnit _PurchaseOrderPriceUnit
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_TaxCode _TaxCode

@EndUserText.label: 'Purchasing Info Rec Org Plant Data'


@AccessControl.authorizationCheck: #CHECK

@VDM.viewType : #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L

@Metadata.ignorePropagatedAnnotations: true

define view entity R_PurgInfoRecdOrgPlntDataTP 
  as select from I_PurgInfoRecdOrgPlantData
  association to parent R_PurchasingInfoRecordTP      as _PurchasingInfoRecord on $projection.PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord
 composition [0..*] of R_PurgInfoRecdPrcgCndnValdtyTP as _PurgInfoRecdPrcgCndnValdty

{
  key PurchasingInfoRecord,
  key PurchasingInfoRecordCategory,
  key PurchasingOrganization,
  key Plant,

      CreatedByUser,

      IsMarkedForDeletion,

      PurchasingGroup,

      Currency,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
      MinimumPurchaseOrderQuantity,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
      StandardPurchaseOrderQuantity,

      MaterialPlannedDeliveryDurn,

      OverdelivTolrtdLmtRatioInPct,

      UnderdelivTolrtdLmtRatioInPct,

      UnlimitedOverdeliveryIsAllowed,

      LastReferencingPurchaseOrder,

      LastReferencingPurOrderItem,

//      cast(' ' as abap.sstring(50)) as NetPriceQuantityUnit,

      @Semantics.amount.currencyCode: 'Currency'
      NetPriceAmount,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
      MaterialPriceUnitQty,

      PurchaseOrderPriceUnit,

      PriceValidityEndDate,

      InvoiceIsGoodsReceiptBased,

      TaxCode,
      
      MaterialRoundingProfile,
      
      MatlMstrTxtIsNotRlvtForPOItm,

      ShippingInstruction,
      
      IncotermsClassification,

      IncotermsTransferLocation,

      IncotermsLocation1,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
      MaximumOrderQuantity,

      @Semantics.booleanIndicator 
      IsRelevantForAutomSrcg,
      
      SupplierQuotation,

      SupplierQuotationDate,

      MinRemainingShelfLife,

      IsEvaluatedRcptSettlmtAllowed,

      IsPurOrderAllwdForInbDeliv,

      IsOrderAcknRqd,

      IsRetMatlAuthznRqdBySupplier,

      IsCashDiscountGranted,

      MaterialConditionGroup,

      PurchasingDocumentDate,

      cast (ShelfLifeExpirationDatePeriod as mm_dattp_int) as ShelfLifeExpirationDatePeriod ,

      @Semantics.booleanIndicator 
      IsEndOfPurposeBlocked,

      SupplierConfirmationControlKey,

      PricingDateControl,

      TimeDependentTaxValidFromDate,

      TaxCountry,
      
      _PurchasingInfoRecord.Material,
      _PurchasingInfoRecord.MaterialGroup,
      _PurchasingInfoRecord.Supplier,
      _PurchasingInfoRecord.PurgDocOrderQuantityUnit,
      
      _PurchasingInfoRecord.LastChangeDateTime,


      //     Composition entities

      _PurgInfoRecdPrcgCndnValdty,
      _PurchasingInfoRecord,

      //     Foriegn Entities


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


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURGINFORECDORGPLANTDATA",
"R_PURCHASINGINFORECORDTP"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_CURRENCY",
"I_INCOTERMSCLASSIFICATION",
"I_PLANT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_TAXCODE",
"I_UNITOFMEASURE",
"I_USER",
"R_PURCHASINGINFORECORDTP",
"R_PURGINFORECDPRCGCNDNVALDTYTP"
],
"BASE":
[
"I_PURGINFORECDORGPLANTDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/