P_PurchaseContractItem

DDL: P_PURCHASECONTRACTITEM SQL: PPURCONTRITM Type: view COMPOSITE

P_PurchaseContractItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 98 fields with key fields PurchaseContract, PurchaseContractItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractItem I_PurchaseContractItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchasingCategoryMatlGroup _PurchasingCategoryMatlGroup $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPURCONTRITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (98)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY PurchaseContractItem PurchaseContractItem
CompanyCode CompanyCode
PurchaseContractType PurchaseContractType
Material Material
PurchaseContractItemText PurchaseContractItemText
ContractNetPriceAmount ContractNetPriceAmount
OrderPriceUnit OrderPriceUnit
VolumeUnit VolumeUnit
OrderQuantityUnit OrderQuantityUnit
MaterialGroup MaterialGroup
Customer Customer
Subcontractor Subcontractor
ReferenceDeliveryAddressID ReferenceDeliveryAddressID
ManualDeliveryAddressID ManualDeliveryAddressID
DeliveryAddressID DeliveryAddressID
Plant Plant
StorageLocation StorageLocation
AccountAssignmentCategory AccountAssignmentCategory
GoodsReceiptIsExpected GoodsReceiptIsExpected
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin
NetPriceQuantity NetPriceQuantity
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution
PartialInvoiceDistribution PartialInvoiceDistribution
TargetQuantity TargetQuantity
TargetAmount TargetAmount
DocumentCurrency DocumentCurrency
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr
PurchasingDocumentItemCategory PurchasingDocumentItemCategory
SupplierMaterialNumber SupplierMaterialNumber
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct
PriceIsToBePrinted PriceIsToBePrinted
ConfirmationControl ConfirmationControl
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed
IncotermsClassification IncotermsClassification
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
IncotermsSupChnLoc1AddlUUID IncotermsSupChnLoc1AddlUUID
IncotermsSupChnLoc2AddlUUID IncotermsSupChnLoc2AddlUUID
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID
InvoiceIsExpected InvoiceIsExpected
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased
PurgDocPriceDate PurgDocPriceDate
IsInfoRecordUpdated IsInfoRecordUpdated
PurchasingInfoRecord PurchasingInfoRecord
PurgDocReleaseOrderQuantity PurgDocReleaseOrderQuantity
PurgDocOrderAcknNumber PurgDocOrderAcknNumber
PurgDocEstimatedPrice PurgDocEstimatedPrice
IsInfoAtRegistration IsInfoAtRegistration
NoDaysReminder1 NoDaysReminder1
NoDaysReminder2 NoDaysReminder2
NoDaysReminder3 NoDaysReminder3
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays
StockType StockType
TaxCode TaxCode
TaxCountry TaxCountry
TaxDeterminationDate TaxDeterminationDate
RequirementTracking RequirementTracking
IsOrderAcknRqd IsOrderAcknRqd
ShippingInstruction ShippingInstruction
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated
ServicePerformer ServicePerformer
ProductType ProductType
MaterialType MaterialType
FormattedPurchaseContractItem FormattedPurchaseContractItem
PurchasingContractDeletionCode PurchasingContractDeletionCode
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
PurchasingCategory
PurgCatName
PurchasingParentItem PurchasingParentItem
IsStatisticalItem IsStatisticalItem
IsActiveEntity
PurgConfigurableItemNumber PurgConfigurableItemNumber
PurgDocAggrgdSubitemCategory PurgDocAggrgdSubitemCategory
PurgExternalSortNumber PurgExternalSortNumber
PurContractItmReplnmtElmntType PurContractItmReplnmtElmntType
PurgProdCmplncSupplierStatus PurgProdCmplncSupplierStatus
PurgProductMarketabilityStatus PurgProductMarketabilityStatus
PurgSafetyDataSheetStatus PurgSafetyDataSheetStatus
PurgProdCmplncDngrsGoodsStatus PurgProdCmplncDngrsGoodsStatus
Associations_PurchaseContract
_PurCtrAccount _PurCtrAccount
_PurCtrAddress _PurCtrAddress
_Purctritnotes _Purctritnotes
_PurCtrCndItem _PurCtrCndItem
_PurchaseContractHistory _PurchaseContractHistory
_MaterialGroup _MaterialGroup
_Plant _Plant
_StorageLocation _StorageLocation
_Material _Material
_OrderQuantityUnit _OrderQuantityUnit
_VolumeUnit _VolumeUnit
_OrderPriceUnit _OrderPriceUnit
_DocumentCurrency _DocumentCurrency
@AbapCatalog.sqlViewName: 'PPURCONTRITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.semanticKey:['PurchaseContract', 'PurchasecontractItem']

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

define view P_PurchaseContractItem
  as select from I_PurchaseContractItem
  association [1..1] to I_PurchasingCategoryMatlGroup as _PurchasingCategoryMatlGroup on $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup
{
  key PurchaseContract,
  key PurchaseContractItem,
      CompanyCode,
      PurchaseContractType,
      Material,
      PurchaseContractItemText,
      ContractNetPriceAmount,
      OrderPriceUnit,
      VolumeUnit,
      OrderQuantityUnit,
      MaterialGroup,
      Customer,
      Subcontractor,
      ReferenceDeliveryAddressID,
      ManualDeliveryAddressID,
      DeliveryAddressID,
      Plant,
      StorageLocation,
      AccountAssignmentCategory,
      GoodsReceiptIsExpected,
      IsToBeAcceptedAtOrigin,
      NetPriceQuantity,
      MultipleAcctAssgmtDistribution,
      PartialInvoiceDistribution,
      TargetQuantity,
      TargetAmount,
      DocumentCurrency,
      OrdPriceUnitToOrderUnitDnmntr, // price conversion from

      OrderPriceUnitToOrderUnitNmrtr, // price conversion to

      PurchasingDocumentItemCategory,
      SupplierMaterialNumber,
      EvaldRcptSettlmtIsAllowed,
      UnderdelivTolrtdLmtRatioInPct,
      PriceIsToBePrinted,
      ConfirmationControl,
      //SupplierConfirmationControlKey,

      OverdelivTolrtdLmtRatioInPct,
      UnlimitedOverdeliveryIsAllowed,
      IncotermsClassification,
      IncotermsLocation1,
      IncotermsLocation2,  
      IncotermsSupChnLoc1AddlUUID,     
      IncotermsSupChnLoc2AddlUUID,      
      IncotermsSupChnDvtgLocAddlUUID,      
      InvoiceIsExpected,
      InvoiceIsGoodsReceiptBased,
      PurgDocPriceDate,
      IsInfoRecordUpdated,
      PurchasingInfoRecord,
      PurgDocReleaseOrderQuantity,
      PurgDocOrderAcknNumber,
      PurgDocEstimatedPrice,
      IsInfoAtRegistration,
      NoDaysReminder1,
      NoDaysReminder2,
      NoDaysReminder3,
      PlannedDeliveryDurationInDays,
      StockType,
      TaxCode,
      TaxCountry,
      TaxDeterminationDate,
      RequirementTracking,
      IsOrderAcknRqd,
      ShippingInstruction,
      GoodsReceiptIsNonValuated,
      ServicePerformer,
      ProductType,
      MaterialType,
      FormattedPurchaseContractItem,
      PurchasingContractDeletionCode,
      PurchaseRequisition,
      PurchaseRequisitionItem,
      @ObjectModel.text.element: ['PurgCatName']
      @Consumption.labelElement: 'PurgCatName'
      _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory,
      @Semantics.text: true
      _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName,
      //Added for complex service hierarchy

      PurchasingParentItem,
      IsStatisticalItem,

      cast( 'X' as sdraft_is_active preserving type ) as IsActiveEntity,

      // Additional Fields for hierarchy implementation

      PurgConfigurableItemNumber,
      PurgDocAggrgdSubitemCategory,
      PurgExternalSortNumber,
      PurContractItmReplnmtElmntType,

      // fields from product compliance

      PurgProdCmplncSupplierStatus,
      PurgProductMarketabilityStatus,
      PurgSafetyDataSheetStatus,
      PurgProdCmplncDngrsGoodsStatus,
      
      --- Associations
      _PurchaseContract,
      _PurCtrAccount,
      _PurCtrAddress,
      _Purctritnotes,
      _PurCtrCndItem,
      _PurchaseContractHistory,
      _MaterialGroup,
      _Plant,
      _StorageLocation,
      _Material,
      _OrderQuantityUnit,
      _VolumeUnit,
      _OrderPriceUnit,
      _DocumentCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTITEM",
"I_PURCHASINGCATEGORY",
"I_PURCHASINGCATEGORYMATLGROUP"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTHISTORY",
"I_PURCHASINGCATEGORYMATLGROUP",
"I_PURCTRACCOUNT",
"I_PURCTRADDRESS",
"I_PURCTRCNDITEM",
"I_PURCTRITNOTES",
"I_STORAGELOCATION",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_PURCHASECONTRACTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/