What is C_SalesContractItemManageTP in SAP S/4HANA?

C_SalesContractItemManageTP is a consumption CDS view in SAP S/4HANA. Sales Contract Item It contains 117 fields.

Which tables does C_SalesContractItemManageTP read from?

C_SalesContractItemManageTP reads data from: R_SalesContractItemTP.

What VDM layer is C_SalesContractItemManageTP?

C_SalesContractItemManageTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SalesContractItemManageTP

DDL: C_SALESCONTRACTITEMMANAGETP Type: view_entity CONSUMPTION

117 Fields 1 Data Sources 3 Associations

Sales Contract Item

C_SalesContractItemManageTP is a Consumption CDS View that provides data about "Sales Contract Item" in SAP S/4HANA. It reads from 1 data source (R_SalesContractItemTP) and exposes 117 fields with key fields SalesContract, SalesContractItem. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
R_SalesContractItemTP	R_SalesContractItemTP	projection

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_ProductStdVH	_Product	`$projection.Product = _Product.Product`
[0..1]	I_PlantStdVH	_Plant	`$projection.Plant = _Plant.Plant`
[0..*]	C_SDDocumentPartnerCard	_SDDocumentPartnerCard	`$projection.SalesContract = _SDDocumentPartnerCard.SDDocument and $projection.SalesContractItem = _SDDocumentPartnerCard.SDDocumentItem`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.modelingPattern	#TRANSACTIONAL_QUERY	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.query.implementedBy	ABAP:CL_S4RAP_STICKY_QRY	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Sales Contract Item	view

Fields (117)

Key	Field	Source Table	Source Field	Description
KEY	SalesContract	SalesContractItem	SalesContract	Sales Document
KEY	SalesContractItem	SalesContractItem	SalesContractItem	Item
	SalesContractItemCategory	SalesContractItem	SalesContractItemCategory
	SalesContractItemText	SalesContractItem	SalesContractItemText
	Product	SalesContractItem	Product	Product Sold
	ProductGroup	SalesContractItem	ProductGroup	Product Sold Group
	MaterialByCustomer	SalesContractItem	MaterialByCustomer	Customer Mat.
	Batch	SalesContractItem	Batch	Lot No.
	PurchaseOrderByCustomer	SalesContractItem	PurchaseOrderByCustomer	Purchase Order Number
	ReferenceSDDocument		ReferenceSDDocument	Reference Doc.
	TargetQuantity	SalesContractItem	TargetQuantity	Target Quantity
	TargetQuantityUnit	SalesContractItem	TargetQuantityUnit	Target Qty UoM
	RequestedQuantity	SalesContractItem	RequestedQuantity	Requested Quantity
	RequestedQuantityUnit	SalesContractItem	RequestedQuantityUnit	Requested Quantity Unit
	ItemGrossWeight	SalesContractItem	ItemGrossWeight	Gross Weight
	ItemNetWeight	SalesContractItem	ItemNetWeight	Net Weight
	ItemWeightUnit	SalesContractItem	ItemWeightUnit	Unit of Weight
	ItemVolume	SalesContractItem	ItemVolume	Volume
	ItemVolumeUnit	SalesContractItem	ItemVolumeUnit	Volume Unit
	PricingDate	SalesContractItem	PricingDate	Pricing Date
	Plant	SalesContractItem	Plant	Valuation Area
	StorageLocation	SalesContractItem	StorageLocation	StorageLocation
	ShippingType	SalesContractItem	ShippingType	Shipping Type
	ShippingPoint	SalesContractItem	ShippingPoint	Shipping Point
	Route	SalesContractItem	Route	Vehicle route
	CustomerPriceGroup	SalesContractItem	CustomerPriceGroup	CustPrice Group
	IncotermsClassification	SalesContractItem	IncotermsClassification	Incoterms
	IncotermsLocation1	SalesContractItem	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	SalesContractItem	IncotermsLocation2	Inco. Location2
	IncotermsVersion	SalesContractItem	IncotermsVersion	Inco. Version
	CustomerPaymentTerms	SalesContractItem	CustomerPaymentTerms	Pyt Terms
	MaterialPricingGroup	SalesContractItem	MaterialPricingGroup
	ItemBillingBlockReason	SalesContractItem	ItemBillingBlockReason	Billing Block
	BillingDocumentDate	SalesContractItem	BillingDocumentDate	Billing Date
	SalesDocumentRjcnReason	SalesContractItem	SalesDocumentRjcnReason	RejectionReason
	TransactionCurrency	SalesContractItem	TransactionCurrency	Transaction Currency
	NetAmount	SalesContractItem	NetAmount	Stated Amount
	TaxAmount	SalesContractItem	TaxAmount	Tax Amt in Rptg Crcy
	BusinessArea	SalesContractItem	BusinessArea	Business Area
	ProfitCenter	SalesContractItem	ProfitCenter	Profit Center
	OutlineAgreementTargetAmount	SalesContractItem	OutlineAgreementTargetAmount
	SalesContractReleasedAmount	SalesContractItem	SalesContractReleasedAmount
	virtualUICT_ValueContractItemboole_d
	virtualUICT_QuantityContractItemboole_d
	virtualUICT_BillingPlanTypeboole_d
	ControllingArea	SalesContractItem	ControllingArea	Controlling Area
	SDPricingProcedure	SalesContractItem	SDPricingProcedure	Pric. Procedure
	ItemCategoryGroup	SalesContractItem	ItemCategoryGroup	Item Cat. Group
	SDDocumentItemUsage	SalesContractItem	SDDocumentItemUsage
	HigherLevelItemCategory	SalesContractItem	HigherLevelItemCategory
	SDProcessStatus	SalesContractItem	SDProcessStatus
	SDDocumentRejectionStatus	SalesContractItem	SDDocumentRejectionStatus
	virtualSDDocRejectionStsCriticalityint1
	BillingBlockStatus	SalesContractItem	BillingBlockStatus
	virtualBillingBlockStatusCriticalityint1
	ItemGeneralIncompletionStatus	SalesContractItem	ItemGeneralIncompletionStatus
	virtualItmGenIncompltnStsCriticalityint1
	ItemBillingIncompletionStatus	SalesContractItem	ItemBillingIncompletionStatus
	PricingIncompletionStatus	SalesContractItem	PricingIncompletionStatus
	ItemDeliveryIncompletionStatus	SalesContractItem	ItemDeliveryIncompletionStatus
	TotalSDDocReferenceStatus	SalesContractItem	TotalSDDocReferenceStatus
	SDDocReferenceStatus	SalesContractItem	SDDocReferenceStatus
	ContractItemDownPaymentStatus	SalesContractItem	ContractItemDownPaymentStatus
	ChmlCmplncStatus	SalesContractItem	ChmlCmplncStatus
	virtualChmlCmplncStsCriticalityint1
	DangerousGoodsStatus	SalesContractItem	DangerousGoodsStatus
	virtualDngrsGdsStsCriticalityint1
	SafetyDataSheetStatus	SalesContractItem	SafetyDataSheetStatus
	virtualSftyDataShtStatCriticalityint1
	TrdCmplncEmbargoSts	SalesContractItem	TrdCmplncEmbargoSts	Embargo Status
	virtualTrdCmplncEmbargoStsCritltyint1
	TrdCmplncSnctndListChkSts	SalesContractItem	TrdCmplncSnctndListChkSts	Screening Status
	virtualTrdCmplncSnctndListCritltyint1
	OvrlTrdCmplncLegalCtrlChkSts	SalesContractItem	OvrlTrdCmplncLegalCtrlChkSts
	SalesContractType	SalesContractItem	SalesContractType
	SalesOrganization	SalesContractItem	SalesOrganization	Sales Organization
	DistributionChannel	SalesContractItem	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	SalesContractItem	OrganizationDivision	Org. Division
	_Product		_Product
	_ProductGroup	SalesContractItem	_ProductGroup
	_TargetQuantityUnit	SalesContractItem	_TargetQuantityUnit
	_ItemVolumeUnit	SalesContractItem	_ItemVolumeUnit
	_Plant		_Plant
	_StorageLocation	SalesContractItem	_StorageLocation
	_ShippingPoint	SalesContractItem	_ShippingPoint
	_IncotermsClassification	SalesContractItem	_IncotermsClassification
	_CustomerPaymentTerms	SalesContractItem	_CustomerPaymentTerms
	_ItemBillingBlockReason	SalesContractItem	_ItemBillingBlockReason
	_SalesDocumentRjcnReason	SalesContractItem	_SalesDocumentRjcnReason
	_BusinessArea	SalesContractItem	_BusinessArea
	_SDProcessStatus	SalesContractItem	_SDProcessStatus
	_SDDocumentRejectionStatus	SalesContractItem	_SDDocumentRejectionStatus
	_ProductPricingGroup	SalesContractItem	_ProductPricingGroup
	_BillingBlockStatus	SalesContractItem	_BillingBlockStatus
	_SDDocumentPartnerCard		_SDDocumentPartnerCard
	_ItemGeneralIncompletionStatus	SalesContractItem	_ItemGeneralIncompletionStatus
	_ItemBillingIncompletionStatus	SalesContractItem	_ItemBillingIncompletionStatus
	_PricingIncompletionStatus	SalesContractItem	_PricingIncompletionStatus
	_ItemDelivIncompletionSts	SalesContractItem	_ItemDelivIncompletionSts
	_TotalSDDocReferenceStatus	SalesContractItem	_TotalSDDocReferenceStatus
	_SDDocReferenceStatus	SalesContractItem	_SDDocReferenceStatus
	_ContractItemDownPaymentStatus	SalesContractItem	_ContractItemDownPaymentStatus
	_ItemCategory	SalesContractItem	_ItemCategory
	_ReferenceSDDocument	SalesContractItem	_ReferenceSDDocument
	_RequestedQuantityUnit	SalesContractItem	_RequestedQuantityUnit
	_IncotermsVersion	SalesContractItem	_IncotermsVersion
	_CustomerPriceGroup	SalesContractItem	_CustomerPriceGroup
	_Route	SalesContractItem	_Route
	_ShippingType	SalesContractItem	_ShippingType
	_ChmlCmplncStatus	SalesContractItem	_ChmlCmplncStatus
	_DangerousGoodsStatus	SalesContractItem	_DangerousGoodsStatus
	_SafetyDataSheetStatus	SalesContractItem	_SafetyDataSheetStatus
	_TrdCmplncEmbargoSts	SalesContractItem	_TrdCmplncEmbargoSts
	_TrdCmplncSnctndListChkSts	SalesContractItem	_TrdCmplncSnctndListChkSts
	_OvrlTrdCmplncLegalCtrlChkSts	SalesContractItem	_OvrlTrdCmplncLegalCtrlChkSts
	_SDPricingProcedure		_SDPricingProcedure
	_ControllingArea	SalesContractItem	_ControllingArea

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 C_SalesContractItemManageTP.
-- 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 C_SalesContractItemManageTP AS
SELECT
  SalesContractItem.SalesContract AS SalesContract,
  SalesContractItem.SalesContractItem AS SalesContractItem,
  SalesContractItem.SalesContractItemCategory AS SalesContractItemCategory,
  SalesContractItem.SalesContractItemText AS SalesContractItemText,
  SalesContractItem.Product AS Product,
  SalesContractItem.ProductGroup AS ProductGroup,
  SalesContractItem.MaterialByCustomer AS MaterialByCustomer,
  SalesContractItem.Batch AS Batch,
  SalesContractItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  ReferenceSDDocument,
  SalesContractItem.TargetQuantity AS TargetQuantity,
  SalesContractItem.TargetQuantityUnit AS TargetQuantityUnit,
  SalesContractItem.RequestedQuantity AS RequestedQuantity,
  SalesContractItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  SalesContractItem.ItemGrossWeight AS ItemGrossWeight,
  SalesContractItem.ItemNetWeight AS ItemNetWeight,
  SalesContractItem.ItemWeightUnit AS ItemWeightUnit,
  SalesContractItem.ItemVolume AS ItemVolume,
  SalesContractItem.ItemVolumeUnit AS ItemVolumeUnit,
  SalesContractItem.PricingDate AS PricingDate,
  SalesContractItem.Plant AS Plant,
  SalesContractItem.StorageLocation AS StorageLocation,
  SalesContractItem.ShippingType AS ShippingType,
  SalesContractItem.ShippingPoint AS ShippingPoint,
  SalesContractItem.Route AS Route,
  SalesContractItem.CustomerPriceGroup AS CustomerPriceGroup,
  SalesContractItem.IncotermsClassification AS IncotermsClassification,
  SalesContractItem.IncotermsLocation1 AS IncotermsLocation1,
  SalesContractItem.IncotermsLocation2 AS IncotermsLocation2,
  SalesContractItem.IncotermsVersion AS IncotermsVersion,
  SalesContractItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesContractItem.MaterialPricingGroup AS MaterialPricingGroup,
  SalesContractItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  SalesContractItem.BillingDocumentDate AS BillingDocumentDate,
  SalesContractItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SalesContractItem.TransactionCurrency AS TransactionCurrency,
  SalesContractItem.NetAmount AS NetAmount,
  SalesContractItem.TaxAmount AS TaxAmount,
  SalesContractItem.BusinessArea AS BusinessArea,
  SalesContractItem.ProfitCenter AS ProfitCenter,
  SalesContractItem.OutlineAgreementTargetAmount AS OutlineAgreementTargetAmount,
  SalesContractItem.SalesContractReleasedAmount AS SalesContractReleasedAmount,
  virtual UICT_ValueContractItem : boole_d AS virtualUICT_ValueContractItemboole_d,
  virtual UICT_QuantityContractItem : boole_d AS virtualUICT_QuantityContractItemboole_d,
  virtual UICT_BillingPlanType : boole_d AS virtualUICT_BillingPlanTypeboole_d,
  SalesContractItem.ControllingArea AS ControllingArea,
  SalesContractItem.SDPricingProcedure AS SDPricingProcedure,
  SalesContractItem.ItemCategoryGroup AS ItemCategoryGroup,
  SalesContractItem.SDDocumentItemUsage AS SDDocumentItemUsage,
  SalesContractItem.HigherLevelItemCategory AS HigherLevelItemCategory,
  SalesContractItem.SDProcessStatus AS SDProcessStatus,
  SalesContractItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  virtual SDDocRejectionStsCriticality : int1 AS virtualSDDocRejectionStsCriticalityint1,
  SalesContractItem.BillingBlockStatus AS BillingBlockStatus,
  virtual BillingBlockStatusCriticality : int1 AS virtualBillingBlockStatusCriticalityint1,
  SalesContractItem.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  virtual ItmGenIncompltnStsCriticality : int1 AS virtualItmGenIncompltnStsCriticalityint1,
  SalesContractItem.ItemBillingIncompletionStatus AS ItemBillingIncompletionStatus,
  SalesContractItem.PricingIncompletionStatus AS PricingIncompletionStatus,
  SalesContractItem.ItemDeliveryIncompletionStatus AS ItemDeliveryIncompletionStatus,
  SalesContractItem.TotalSDDocReferenceStatus AS TotalSDDocReferenceStatus,
  SalesContractItem.SDDocReferenceStatus AS SDDocReferenceStatus,
  SalesContractItem.ContractItemDownPaymentStatus AS ContractItemDownPaymentStatus,
  SalesContractItem.ChmlCmplncStatus AS ChmlCmplncStatus,
  virtual ChmlCmplncStsCriticality : int1 AS virtualChmlCmplncStsCriticalityint1,
  SalesContractItem.DangerousGoodsStatus AS DangerousGoodsStatus,
  virtual DngrsGdsStsCriticality : int1 AS virtualDngrsGdsStsCriticalityint1,
  SalesContractItem.SafetyDataSheetStatus AS SafetyDataSheetStatus,
  virtual SftyDataShtStatCriticality : int1 AS virtualSftyDataShtStatCriticalityint1,
  SalesContractItem.TrdCmplncEmbargoSts AS TrdCmplncEmbargoSts,
  virtual TrdCmplncEmbargoStsCritlty : int1 AS virtualTrdCmplncEmbargoStsCritltyint1,
  SalesContractItem.TrdCmplncSnctndListChkSts AS TrdCmplncSnctndListChkSts,
  virtual TrdCmplncSnctndListCritlty : int1 AS virtualTrdCmplncSnctndListCritltyint1,
  SalesContractItem.OvrlTrdCmplncLegalCtrlChkSts AS OvrlTrdCmplncLegalCtrlChkSts,
  SalesContractItem.SalesContractType AS SalesContractType,
  SalesContractItem.SalesOrganization AS SalesOrganization,
  SalesContractItem.DistributionChannel AS DistributionChannel,
  SalesContractItem.OrganizationDivision AS OrganizationDivision,
  SalesContractItem._ProductGroup AS _ProductGroup,
  SalesContractItem._TargetQuantityUnit AS _TargetQuantityUnit,
  SalesContractItem._ItemVolumeUnit AS _ItemVolumeUnit,
  SalesContractItem._StorageLocation AS _StorageLocation,
  SalesContractItem._ShippingPoint AS _ShippingPoint,
  SalesContractItem._IncotermsClassification AS _IncotermsClassification,
  SalesContractItem._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SalesContractItem._ItemBillingBlockReason AS _ItemBillingBlockReason,
  SalesContractItem._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  SalesContractItem._BusinessArea AS _BusinessArea,
  SalesContractItem._SDProcessStatus AS _SDProcessStatus,
  SalesContractItem._SDDocumentRejectionStatus AS _SDDocumentRejectionStatus,
  SalesContractItem._ProductPricingGroup AS _ProductPricingGroup,
  SalesContractItem._BillingBlockStatus AS _BillingBlockStatus,
  SalesContractItem._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
  SalesContractItem._ItemBillingIncompletionStatus AS _ItemBillingIncompletionStatus,
  SalesContractItem._PricingIncompletionStatus AS _PricingIncompletionStatus,
  SalesContractItem._ItemDelivIncompletionSts AS _ItemDelivIncompletionSts,
  SalesContractItem._TotalSDDocReferenceStatus AS _TotalSDDocReferenceStatus,
  SalesContractItem._SDDocReferenceStatus AS _SDDocReferenceStatus,
  SalesContractItem._ContractItemDownPaymentStatus AS _ContractItemDownPaymentStatus,
  SalesContractItem._ItemCategory AS _ItemCategory,
  SalesContractItem._ReferenceSDDocument AS _ReferenceSDDocument,
  SalesContractItem._RequestedQuantityUnit AS _RequestedQuantityUnit,
  SalesContractItem._IncotermsVersion AS _IncotermsVersion,
  SalesContractItem._CustomerPriceGroup AS _CustomerPriceGroup,
  SalesContractItem._Route AS _Route,
  SalesContractItem._ShippingType AS _ShippingType,
  SalesContractItem._ChmlCmplncStatus AS _ChmlCmplncStatus,
  SalesContractItem._DangerousGoodsStatus AS _DangerousGoodsStatus,
  SalesContractItem._SafetyDataSheetStatus AS _SafetyDataSheetStatus,
  SalesContractItem._TrdCmplncEmbargoSts AS _TrdCmplncEmbargoSts,
  SalesContractItem._TrdCmplncSnctndListChkSts AS _TrdCmplncSnctndListChkSts,
  SalesContractItem._OvrlTrdCmplncLegalCtrlChkSts AS _OvrlTrdCmplncLegalCtrlChkSts,
  SalesContractItem._ControllingArea AS _ControllingArea
FROM R_SalesContractItemTP
LEFT OUTER JOIN I_ProductStdVH AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _SDDocumentPartnerCard ON SalesContract = _SDDocumentPartnerCard.SDDocument AND SalesContractItem = _SDDocumentPartnerCard.SDDocumentItem  -- association [0..*]
;

Depth:

C_SalesContractItemManageTP view_entity

R_SalesContractItemTP view_entity