I_PurgInfoRecdOrgPlntDataTP

DDL: I_PURGINFORECDORGPLNTDATATP Type: view_entity TRANSACTIONAL
57 Fields 1 Data Sources

Purchase Info Record Org Plnt Data - TP

I_PurgInfoRecdOrgPlntDataTP is a Transactional CDS View that provides data about "Purchase Info Record Org Plnt Data - TP" in SAP S/4HANA. It reads from 1 data source (R_PurgInfoRecdOrgPlntDataTP) and exposes 57 fields with key fields PurchasingInfoRecord, PurchasingInfoRecordCategory, PurchasingOrganization, Plant.

Data Sources (1)

SourceAliasJoin Type
R_PurgInfoRecdOrgPlntDataTP R_PurgInfoRecdOrgPlntDataTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Purchase Info Record Org Plnt Data - TP view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name PurgInfoRecdOrgPlantData view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord PurchasingInfoRecord Info Record
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory Infotype
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
KEY Plant Plant Valuation Area
CreatedByUser CreatedByUser User Name
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
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
TaxCode TaxCode Tax Code
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
MaximumOrderQuantity MaximumOrderQuantity Max. Quantity
IsRelevantForAutomSrcg IsRelevantForAutomSrcg Checkbox
SupplierQuotation SupplierQuotation RFQ
SupplierQuotationDate SupplierQuotationDate Quotation from
MinRemainingShelfLife MinRemainingShelfLife Rem. Shelf Life
IsEvaluatedRcptSettlmtAllowed IsEvaluatedRcptSettlmtAllowed No ERS
IsPurOrderAllwdForInbDeliv IsPurOrderAllwdForInbDeliv Create Ref Doc
IsOrderAcknRqd IsOrderAcknRqd Acknowl. Reqd.
IsRetMatlAuthznRqdBySupplier IsRetMatlAuthznRqdBySupplier RMA Required
IsCashDiscountGranted IsCashDiscountGranted No Cash Disc.
MaterialConditionGroup MaterialConditionGroup Condition Group
PurchasingDocumentDate PurchasingDocumentDate Document Date
ShelfLifeExpirationDatePeriod ShelfLifeExpirationDatePeriod Period Ind.
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
SupplierConfirmationControlKey SupplierConfirmationControlKey Conf. Control
PricingDateControl PricingDateControl Pr. Date Cat.
TimeDependentTaxValidFromDate TimeDependentTaxValidFromDate Tax Rate Valid-From
TaxCountry TaxCountry Tax Ctry/Reg.
Material Material Vehicle Model
Supplier Supplier Supplier
MaterialGroup MaterialGroup Product Group
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
LastChangeDateTime LastChangeDateTime Timestamp
_Country _Country
_CreatedByUser _CreatedByUser
_Currency _Currency
_IncotermsClassification _IncotermsClassification
_Plant _Plant
_PurchaseOrderPriceUnit _PurchaseOrderPriceUnit
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_TaxCode _TaxCode

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_PurgInfoRecdOrgPlntDataTP.
-- 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.

CREATE VIEW I_PurgInfoRecdOrgPlntDataTP AS
SELECT
  PurchasingInfoRecord,
  PurchasingInfoRecordCategory,
  PurchasingOrganization,
  Plant,
  CreatedByUser,
  IsMarkedForDeletion,
  PurchasingGroup,
  Currency,
  MinimumPurchaseOrderQuantity,
  StandardPurchaseOrderQuantity,
  MaterialPlannedDeliveryDurn,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  LastReferencingPurchaseOrder,
  LastReferencingPurOrderItem,
  NetPriceAmount,
  MaterialPriceUnitQty,
  PurchaseOrderPriceUnit,
  PriceValidityEndDate,
  InvoiceIsGoodsReceiptBased,
  TaxCode,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  MaximumOrderQuantity,
  IsRelevantForAutomSrcg,
  SupplierQuotation,
  SupplierQuotationDate,
  MinRemainingShelfLife,
  IsEvaluatedRcptSettlmtAllowed,
  IsPurOrderAllwdForInbDeliv,
  IsOrderAcknRqd,
  IsRetMatlAuthznRqdBySupplier,
  IsCashDiscountGranted,
  MaterialConditionGroup,
  PurchasingDocumentDate,
  ShelfLifeExpirationDatePeriod,
  IsEndOfPurposeBlocked,
  SupplierConfirmationControlKey,
  PricingDateControl,
  TimeDependentTaxValidFromDate,
  TaxCountry,
  Material,
  Supplier,
  MaterialGroup,
  PurgDocOrderQuantityUnit,
  LastChangeDateTime
FROM R_PurgInfoRecdOrgPlntDataTP
;

Learn More