R_PPS_PurContractItemDraft

DDL: R_PPS_PURCONTRACTITEMDRAFT Type: view_entity BASIC
121 Fields 1 Data Sources 1 Associations

Purchase Contract Item - Draft

R_PPS_PurContractItemDraft is a Basic CDS View that provides data about "Purchase Contract Item - Draft" in SAP S/4HANA. It reads from 1 data source (pps_pc_item_d) and exposes 121 fields with key fields PurchaseContract, PurchaseContractItem, DraftUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
pps_pc_item_d pps_pc_item_d from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialGroupText _MaterialGroupText $projection.MaterialGroup = _MaterialGroupText.MaterialGroup and _MaterialGroupText.Language = $session.system_language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchase Contract Item - Draft view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (121)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract purchasecontract Purchasing Doc.
KEY PurchaseContractItem purchasecontractitem Item
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
PurchaseContractItemUUID purchasecontractitemuuid UUID
PurchaseContractItemUniqueID purchasecontractitemuniqueid Document Item
PurgConfigurableItemNumber purgconfigurableitemnumber Hierarchy Number
ProductTypeCode producttypecode Product Type Group
PurchasingDocumentItemCategory purchasingdocumentitemcategory Item Category
Material material Vehicle Model
TargetQuantity targetquantity Target Quantity
ContractNetPriceAmount contractnetpriceamount Net Price
NetPriceQuantity netpricequantity Price Unit
CompanyCode companycode Receiver Company Code
ManufacturerMaterial manufacturermaterial MPN: Material
PurchaseContractItemText purchasecontractitemtext Short Text
OrderPriceUnit orderpriceunit Order Price Un.
VolumeUnit volumeunit Volume Unit
OrderQuantityUnit orderquantityunit Sales Unit
MaterialGroup materialgroup Product Group
Customer customer Sold-to Party
Subcontractor subcontractor Supplier
ReferenceDeliveryAddressID referencedeliveryaddressid Reference Address
DeliveryAddressID deliveryaddressid Address
Plant plant Valuation Area
StorageLocation storagelocation StorageLocation
AccountAssignmentCategory accountassignmentcategory Acct Assgmt Cat
GoodsReceiptIsExpected goodsreceiptisexpected Goods Receipt
TargetAmount targetamount Target Value
DocumentCurrency documentcurrency Document Currency
OrdPriceUnitToOrderUnitDnmntr ordpriceunittoorderunitdnmntr Quantity Conversion Denominator
OrderPriceUnitToOrderUnitNmrtr orderpriceunittoorderunitnmrtr Quantity Conversion Numerator
SupplierMaterialNumber suppliermaterialnumber Supp. Mat. No.
EvaldRcptSettlmtIsAllowed evaldrcptsettlmtisallowed ERS
UnderdelivTolrtdLmtRatioInPct underdelivtolrtdlmtratioinpct Underdel. Tol.
PriceIsToBePrinted priceistobeprinted Print Price
SupplierConfirmationControlKey supplierconfirmationcontrolkey Conf. Control
OverdelivTolrtdLmtRatioInPct overdelivtolrtdlmtratioinpct Overdeliv. Tol.
UnlimitedOverdeliveryIsAllowed unlimitedoverdeliveryisallowed Unlimited Tol.
InvoiceIsExpected invoiceisexpected Invoice Receipt
InvoiceIsGoodsReceiptBased invoiceisgoodsreceiptbased GR-Based IV
PurgDocPriceDate purgdocpricedate Price Date
PurchasingInfoRecordUpdateCode purchasinginforecordupdatecode InfoUpdate
PurgDocReleaseOrderQuantity purgdocreleaseorderquantity Rel. order qty.
PurgDocOrderAcknNumber purgdocorderacknnumber Order Acknowl.
PurchasingPriceIsEstimated purchasingpriceisestimated Estimated Price
IsInfoAtRegistration isinfoatregistration InfoAtReg.
NoDaysReminder1 nodaysreminder1 1st Rem./Exped.
NoDaysReminder2 nodaysreminder2 2nd Rem./Exped.
NoDaysReminder3 nodaysreminder3 3rd Rem./Exped.
StockType stocktype Stock Type
TaxCode taxcode Tax Code
TaxCountry taxcountry Tax Ctry/Reg.
TaxDeterminationDate taxdeterminationdate Tx Determination Dte
RequirementTracking requirementtracking Tracking Number
IsOrderAcknRqd isorderacknrqd Acknowl. Reqd.
ShippingInstruction shippinginstruction Shipping Instr.
GoodsReceiptIsNonValuated goodsreceiptisnonvaluated GR Non-Valuated
ServicePerformer serviceperformer Service Performer
MaterialType materialtype Material Type
PurchaseContractItemFormatted purchasecontractitemformatted Char15
PurchasingContractDeletionCode purchasingcontractdeletioncode Del. Indicator
PurchaseRequisition purchaserequisition Requisition
PurchaseRequisitionItem purchaserequisitionitem Requisn. item
ManufacturerPartNmbr manufacturerpartnmbr Mfr Part Number
Manufacturer manufacturer Manufacturer
PurchasingCategory purchasingcategory Purchasing Category
PurgCatName purgcatname Purchasing Cat. Name
PurchaseContractType purchasecontracttype Order Type
PurchasingOrganization purchasingorganization Purchasing Organization
PurchasingGroup purchasinggroup Purchasing Group
PurgProdCmplncSupplierStatus purgprodcmplncsupplierstatus Supplier Check Sts
PurchasingIsCatalogRelevant purchasingiscatalogrelevant Ctlg Item Indicator
PlannedDeliveryDurationInDays planneddeliverydurationindays Plnd dely time
IncotermsClassification incotermsclassification Incoterms
IncotermsLocation1 incotermslocation1 Inco. Location1
IncotermsLocation2 incotermslocation2 Inco. Location2
IsDeleted isdeleted TRUE
PurchasingHierarchyNode purchasinghierarchynode Hier.node
HierarchyParentNode hierarchyparentnode Hier.node
HierarchyLevel hierarchylevel Hierarchy Level
HierarchyNodeSubTreeSize hierarchynodesubtreesize Descendant Count
HierarchyDrillState hierarchydrillstate Drill State
HierarchyNodeOrdinalNumber hierarchynodeordinalnumber Node Number
IsOutline isoutline Item Set
IsStatisticalItem isstatisticalitem Statisticl.Indicator
PurchasingParentItem purchasingparentitem Parent Item No
PurchasingParentItemForEdit purchasingparentitemforedit H-Lev. Item
PurgDocAggrgdSubitemCategory purgdocaggrgdsubitemcategory Sub-items
PurgExternalSortNumber purgexternalsortnumber External Sort No.
PPSPurContractItemIsBlocked ppspurcontractitemisblocked Boolean Variable (X = True, - = False, Space = Unknown)
IncotermsLocation1Identifier incotermslocation1identifier Location
IncotermsLocation2Identifier incotermslocation2identifier Location
IncotermsDvtgLocIdentifier incotermsdvtglocidentifier Location
IncotermsDvtgLocDescription incotermsdvtglocdescription Loc. Description
LastChangeDateTime lastchangedatetime Timestamp
PPSFieldChangeIndicatorBinary ppsfieldchangeindicatorbinary Control
PPSPerdOfPerfStartDate ppsperdofperfstartdate PeROP Start Date
PPSPerdOfPerfEndDate ppsperdofperfenddate PeROP End Date
PPSSmartNumberItem ppssmartnumberitem Smart Number
PPSSmartNumberItemIsManual ppssmartnumberitemismanual Checkbox
PPSDeliveryToleranceKey ppsdeliverytolerancekey Tolerance Key
ContractConsumptionInPct contractconsumptioninpct Consumption Pct
PurContrConsumptionUnit purcontrconsumptionunit Base Unit
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
PurchasingDocumentCategory purchasingdocumentcategory Doc. Category
ProductTypeName producttypename Description
PurgDocItemCategoryName purgdocitemcategoryname Text for ItCat.
MaterialGroupName _MaterialGroupText MaterialGroupName prod Grp Desc.
PPSConfigurableLineItemNumber ppsconfigurablelineitemnumber Config. Itm. No.
PPSPurContrItemStatus ppspurcontritemstatus Item Status
PPSPurContrItemStatusText ppspurcontritemstatustext Pur. Doc. Stat. Name
PPSIsOptionalItem ppsisoptionalitem TRUE
PPSOptionalItemStatus ppsoptionalitemstatus Optional Item Status
PPSOptionalItemStatusText ppsoptionalitemstatustext Short Description
PPSOptionExerciseStartDate ppsoptionexercisestartdate Exe Start Date
PPSOptionExerciseEndDate ppsoptionexerciseenddate Execution End Date

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 R_PPS_PurContractItemDraft.
-- 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 R_PPS_PurContractItemDraft AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  DraftUUID,
  ParentDraftUUID,
  PurchaseContractItemUUID,
  PurchaseContractItemUniqueID,
  PurgConfigurableItemNumber,
  ProductTypeCode,
  PurchasingDocumentItemCategory,
  Material,
  TargetQuantity,
  ContractNetPriceAmount,
  NetPriceQuantity,
  CompanyCode,
  ManufacturerMaterial,
  PurchaseContractItemText,
  OrderPriceUnit,
  VolumeUnit,
  OrderQuantityUnit,
  MaterialGroup,
  Customer,
  Subcontractor,
  ReferenceDeliveryAddressID,
  DeliveryAddressID,
  Plant,
  StorageLocation,
  AccountAssignmentCategory,
  GoodsReceiptIsExpected,
  TargetAmount,
  DocumentCurrency,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  SupplierMaterialNumber,
  EvaldRcptSettlmtIsAllowed,
  UnderdelivTolrtdLmtRatioInPct,
  PriceIsToBePrinted,
  SupplierConfirmationControlKey,
  OverdelivTolrtdLmtRatioInPct,
  UnlimitedOverdeliveryIsAllowed,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  PurgDocPriceDate,
  PurchasingInfoRecordUpdateCode,
  PurgDocReleaseOrderQuantity,
  PurgDocOrderAcknNumber,
  PurchasingPriceIsEstimated,
  IsInfoAtRegistration,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  StockType,
  TaxCode,
  TaxCountry,
  TaxDeterminationDate,
  RequirementTracking,
  IsOrderAcknRqd,
  ShippingInstruction,
  GoodsReceiptIsNonValuated,
  ServicePerformer,
  MaterialType,
  PurchaseContractItemFormatted,
  PurchasingContractDeletionCode,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  ManufacturerPartNmbr,
  Manufacturer,
  PurchasingCategory,
  PurgCatName,
  PurchaseContractType,
  PurchasingOrganization,
  PurchasingGroup,
  PurgProdCmplncSupplierStatus,
  PurchasingIsCatalogRelevant,
  PlannedDeliveryDurationInDays,
  IncotermsClassification,
  IncotermsLocation1,
  IncotermsLocation2,
  IsDeleted,
  PurchasingHierarchyNode,
  HierarchyParentNode,
  HierarchyLevel,
  HierarchyNodeSubTreeSize,
  HierarchyDrillState,
  HierarchyNodeOrdinalNumber,
  IsOutline,
  IsStatisticalItem,
  PurchasingParentItem,
  PurchasingParentItemForEdit,
  PurgDocAggrgdSubitemCategory,
  PurgExternalSortNumber,
  PPSPurContractItemIsBlocked,
  IncotermsLocation1Identifier,
  IncotermsLocation2Identifier,
  IncotermsDvtgLocIdentifier,
  IncotermsDvtgLocDescription,
  LastChangeDateTime,
  PPSFieldChangeIndicatorBinary,
  PPSPerdOfPerfStartDate,
  PPSPerdOfPerfEndDate,
  PPSSmartNumberItem,
  PPSSmartNumberItemIsManual,
  PPSDeliveryToleranceKey,
  ContractConsumptionInPct,
  PurContrConsumptionUnit,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  PurchasingDocumentCategory,
  ProductTypeName,
  PurgDocItemCategoryName,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  PPSConfigurableLineItemNumber,
  PPSPurContrItemStatus,
  PPSPurContrItemStatusText,
  PPSIsOptionalItem,
  PPSOptionalItemStatus,
  PPSOptionalItemStatusText,
  PPSOptionExerciseStartDate,
  PPSOptionExerciseEndDate
FROM pps_pc_item_d
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
;

Learn More