Which tables does R_SlsOrderWithoutChargeItemTP use?

R_SlsOrderWithoutChargeItemTP reads from 1 data source(s): I_SalesOrderWithoutChargeItem.

How many fields does R_SlsOrderWithoutChargeItemTP have?

R_SlsOrderWithoutChargeItemTP has 85 fields. Key fields: SalesOrderWithoutCharge, SalesOrderWithoutChargeItem.

R_SlsOrderWithoutChargeItemTP

DDL: R_SLSORDERWITHOUTCHARGEITEMTP Type: view_entity TRANSACTIONAL

Sales Order Without Charge Item - TP

R_SlsOrderWithoutChargeItemTP is a Transactional CDS View that provides data about "Sales Order Without Charge Item - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderWithoutChargeItem) and exposes 85 fields with key fields SalesOrderWithoutCharge, SalesOrderWithoutChargeItem. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_SalesOrderWithoutChargeItem	SalesOrderWithoutChargeItem	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_SlsDocItemEnhancedFields	_ItemEnhancedFields	`$projection.SalesOrderWithoutCharge = _ItemEnhancedFields.SalesDocument and $projection.SalesOrderWithoutChargeItem = _ItemEnhancedFields.SalesDocumentItem`
[0..1]	I_Batch	_Batch	`$projection.Plant = _Batch.Plant and $projection.Product = _Batch.Material and $projection.Batch = _Batch.Batch`
[0..1]	I_ProductPricingGroup	_ProductPricingGroup	`$projection.MaterialPricingGroup = _ProductPricingGroup.ProductPricingGroup`
[0..1]	I_ControllingArea	_ControllingArea	`$projection.ControllingArea = _ControllingArea.ControllingArea`
[0..1]	I_WBSElementByExternalID	_WBSElementExternalID	`$projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID`

Annotations (8)

Name	Value	Level
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
VDM.viewType	#TRANSACTIONAL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Sales Order Without Charge Item - TP	view

Fields (85)

Key	Field	Source Table	Source Field
KEY	SalesOrderWithoutCharge	I_SalesOrderWithoutChargeItem	SalesOrderWithoutCharge
KEY	SalesOrderWithoutChargeItem	I_SalesOrderWithoutChargeItem	SalesOrderWithoutChargeItem
	HigherLevelItem	I_SalesOrderWithoutChargeItem	HigherLevelItem
	SlsOrdWthoutChrgItemCategory	I_SalesOrderWithoutChargeItem	SlsOrdWthoutChrgItemCategory
	SalesOrderWthoutChrgItemText	I_SalesOrderWithoutChargeItem	SalesOrderWthoutChrgItemText
	PurchaseOrderByCustomer	I_SalesOrderWithoutChargeItem	PurchaseOrderByCustomer
	RequestedDeliveryDate
	ConfirmedDeliveryDate
	SDDocumentRejectionStatus	I_SalesOrderWithoutChargeItem	SDDocumentRejectionStatus
	ItemGeneralIncompletionStatus	I_SalesOrderWithoutChargeItem	ItemGeneralIncompletionStatus
	DeliveryBlockStatus	I_SalesOrderWithoutChargeItem	DeliveryBlockStatus
	PricingDate	I_SalesOrderWithoutChargeItem	PricingDate
	ServicesRenderedDate	I_SalesOrderWithoutChargeItem	ServicesRenderedDate
	BillingDocumentDate	I_SalesOrderWithoutChargeItem	BillingDocumentDate
	FixedValueDate	I_SalesOrderWithoutChargeItem	FixedValueDate
	CustomerGroup	I_SalesOrderWithoutChargeItem	CustomerGroup
	Route	I_SalesOrderWithoutChargeItem	Route
	PartialDeliveryIsAllowed	I_SalesOrderWithoutChargeItem	PartialDeliveryIsAllowed
	MaxNmbrOfPartialDelivery	I_SalesOrderWithoutChargeItem	MaxNmbrOfPartialDelivery
	DeliveryGroup	I_SalesOrderWithoutChargeItem	DeliveryGroup
	CustomerPaymentTerms	I_SalesOrderWithoutChargeItem	CustomerPaymentTerms
	RequestedQuantity	I_SalesOrderWithoutChargeItem	RequestedQuantity
	RequestedQuantityUnit	I_SalesOrderWithoutChargeItem	RequestedQuantityUnit
	ItemGrossWeight	I_SalesOrderWithoutChargeItem	ItemGrossWeight
	ItemNetWeight	I_SalesOrderWithoutChargeItem	ItemNetWeight
	ItemWeightUnit	I_SalesOrderWithoutChargeItem	ItemWeightUnit
	ItemVolume	I_SalesOrderWithoutChargeItem	ItemVolume
	ItemVolumeUnit	I_SalesOrderWithoutChargeItem	ItemVolumeUnit
	TransactionCurrency	I_SalesOrderWithoutChargeItem	TransactionCurrency
	NetAmount	I_SalesOrderWithoutChargeItem	NetAmount
	Product	I_SalesOrderWithoutChargeItem	Product
	ProductGroup	I_SalesOrderWithoutChargeItem	ProductGroup
	MaterialByCustomer	I_SalesOrderWithoutChargeItem	MaterialByCustomer
	MaterialPricingGroup
	Batch	I_SalesOrderWithoutChargeItem	Batch
	Plant	I_SalesOrderWithoutChargeItem	Plant
	StorageLocation	I_SalesOrderWithoutChargeItem	StorageLocation
	ShippingPoint	I_SalesOrderWithoutChargeItem	ShippingPoint
	ShippingType	I_SalesOrderWithoutChargeItem	ShippingType
	DeliveryPriority	I_SalesOrderWithoutChargeItem	DeliveryPriority
	DeliveryDateTypeRule	I_SalesOrderWithoutChargeItem	DeliveryDateTypeRule
	IncotermsClassification	I_SalesOrderWithoutChargeItem	IncotermsClassification
	IncotermsLocation1	I_SalesOrderWithoutChargeItem	IncotermsLocation1
	IncotermsLocation2	I_SalesOrderWithoutChargeItem	IncotermsLocation2
	SalesDocumentRjcnReason	I_SalesOrderWithoutChargeItem	SalesDocumentRjcnReason
	WBSElementInternalID	I_SalesOrderWithoutChargeItem	WBSElementInternalID
	WBSElementExternalID
	ProfitCenter	I_SalesOrderWithoutChargeItem	ProfitCenter
	ControllingArea	I_SalesOrderWithoutChargeItem	ControllingArea
	SDProcessStatus	I_SalesOrderWithoutChargeItem	SDProcessStatus
	DeliveryStatus	I_SalesOrderWithoutChargeItem	DeliveryStatus
	SalesOrderWithoutChargeType	_SalesOrderWithoutCharge	SalesOrderWithoutChargeType
	OrganizationDivision	_SalesOrderWithoutCharge	OrganizationDivision
	SalesOrganization	_SalesOrderWithoutCharge	SalesOrganization
	DistributionChannel	_SalesOrderWithoutCharge	DistributionChannel
	_SalesOrderWithoutCharge		_SalesOrderWithoutCharge
	_SDProcessStatus	I_SalesOrderWithoutChargeItem	_SDProcessStatus
	_DeliveryStatus	I_SalesOrderWithoutChargeItem	_DeliveryStatus
	_ProfitCenter	I_SalesOrderWithoutChargeItem	_ProfitCenter
	_Plant	I_SalesOrderWithoutChargeItem	_Plant
	_StorageLocation	I_SalesOrderWithoutChargeItem	_StorageLocation
	_Product	I_SalesOrderWithoutChargeItem	_Product
	_ProductGroup	I_SalesOrderWithoutChargeItem	_ProductGroup
	_SalesDocumentRjcnReason	I_SalesOrderWithoutChargeItem	_SalesDocumentRjcnReason
	_IncotermsClassification	I_SalesOrderWithoutChargeItem	_IncotermsClassification
	_ItemWeightUnit	I_SalesOrderWithoutChargeItem	_ItemWeightUnit
	_ItemVolumeUnit	I_SalesOrderWithoutChargeItem	_ItemVolumeUnit
	_RequestedQuantityUnit	I_SalesOrderWithoutChargeItem	_RequestedQuantityUnit
	_TransactionCurrency	I_SalesOrderWithoutChargeItem	_TransactionCurrency
	_ItemCategory	I_SalesOrderWithoutChargeItem	_ItemCategory
	_ShippingPoint	I_SalesOrderWithoutChargeItem	_ShippingPoint
	_ShippingType	I_SalesOrderWithoutChargeItem	_ShippingType
	_DeliveryPriority	I_SalesOrderWithoutChargeItem	_DeliveryPriority
	_DeliveryDateTypeRule	I_SalesOrderWithoutChargeItem	_DeliveryDateTypeRule
	_SDDocumentRejectionStatus	I_SalesOrderWithoutChargeItem	_SDDocumentRejectionStatus
	_ItemGeneralIncompletionStatus	I_SalesOrderWithoutChargeItem	_ItemGeneralIncompletionStatus
	_DeliveryBlockStatus	I_SalesOrderWithoutChargeItem	_DeliveryBlockStatus
	_CustomerGroup	I_SalesOrderWithoutChargeItem	_CustomerGroup
	_Route	I_SalesOrderWithoutChargeItem	_Route
	_PartialDeliveryItem	I_SalesOrderWithoutChargeItem	_PartialDeliveryItem
	_CustomerPaymentTerms	I_SalesOrderWithoutChargeItem	_CustomerPaymentTerms
	_ControllingArea		_ControllingArea
	_Batch		_Batch
	_ProductPricingGroup		_ProductPricingGroup
	_WBSElementExternalID		_WBSElementExternalID

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}

@ObjectModel: {
    usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #C,
        sizeCategory:   #L
    },
    semanticKey: ['SalesOrderWithoutCharge', 'SalesOrderWithoutChargeItem']
}

@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Sales Order Without Charge Item - TP'

define view entity R_SlsOrderWithoutChargeItemTP
  as select from I_SalesOrderWithoutChargeItem as SalesOrderWithoutChargeItem

  association        to parent R_SalesOrderWithoutChargeTP as _SalesOrderWithoutCharge on  $projection.SalesOrderWithoutCharge = _SalesOrderWithoutCharge.SalesOrderWithoutCharge
  association [0..1] to I_SlsDocItemEnhancedFields         as _ItemEnhancedFields      on  $projection.SalesOrderWithoutCharge     = _ItemEnhancedFields.SalesDocument
                                                                                       and $projection.SalesOrderWithoutChargeItem = _ItemEnhancedFields.SalesDocumentItem

  association [0..1] to I_Batch                            as _Batch                   on  $projection.Plant   = _Batch.Plant
                                                                                       and $projection.Product = _Batch.Material
                                                                                       and $projection.Batch   = _Batch.Batch
  association [0..1] to I_ProductPricingGroup              as _ProductPricingGroup     on  $projection.MaterialPricingGroup = _ProductPricingGroup.ProductPricingGroup
  association [0..1] to I_ControllingArea                  as _ControllingArea         on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1] to I_WBSElementByExternalID           as _WBSElementExternalID    on  $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID
{
  key SalesOrderWithoutChargeItem.SalesOrderWithoutCharge,
  key SalesOrderWithoutChargeItem.SalesOrderWithoutChargeItem,

      SalesOrderWithoutChargeItem.HigherLevelItem,

      @ObjectModel.foreignKey.association: '_ItemCategory'
      SalesOrderWithoutChargeItem.SlsOrdWthoutChrgItemCategory,

      @Semantics.text: true
      SalesOrderWithoutChargeItem.SalesOrderWthoutChrgItemText,

      SalesOrderWithoutChargeItem.PurchaseOrderByCustomer,
      _ItemEnhancedFields._RequestedDeliveryDate.RequestedDeliveryDate,

      _ItemEnhancedFields._ConfirmedDeliveryDate.ConfirmedDeliveryDate,

      @ObjectModel.foreignKey.association: '_SDDocumentRejectionStatus'
      SalesOrderWithoutChargeItem.SDDocumentRejectionStatus,

      @ObjectModel.foreignKey.association: '_ItemGeneralIncompletionStatus'
      SalesOrderWithoutChargeItem.ItemGeneralIncompletionStatus,

      @ObjectModel.foreignKey.association: '_DeliveryBlockStatus'
      SalesOrderWithoutChargeItem.DeliveryBlockStatus,

      SalesOrderWithoutChargeItem.PricingDate,
      SalesOrderWithoutChargeItem.ServicesRenderedDate,
      SalesOrderWithoutChargeItem.BillingDocumentDate,
      SalesOrderWithoutChargeItem.FixedValueDate,

      @ObjectModel.foreignKey.association: '_CustomerGroup'
      SalesOrderWithoutChargeItem.CustomerGroup,

      @ObjectModel.foreignKey.association: '_Route'
      SalesOrderWithoutChargeItem.Route,

      @ObjectModel.foreignKey.association: '_PartialDeliveryItem'
      SalesOrderWithoutChargeItem.PartialDeliveryIsAllowed,

      @Semantics.valueRange.minimum: '0'
      SalesOrderWithoutChargeItem.MaxNmbrOfPartialDelivery,

      @Semantics.valueRange.minimum: '0'
      SalesOrderWithoutChargeItem.DeliveryGroup,

      //@ObjectModel.foreignKey.association: '_IncotermsVersion'

      //SalesOrderWithoutChargeItem.IncotermsVersion,


      @ObjectModel.foreignKey.association: '_CustomerPaymentTerms'
      SalesOrderWithoutChargeItem.CustomerPaymentTerms,

      //@ObjectModel.foreignKey.association: '_CustomerPriceGroup'

      //CustomerPriceGroup,


      @Semantics.quantity.unitOfMeasure: 'RequestedQuantityUnit'
      @Semantics.valueRange.minimum: '0'
      SalesOrderWithoutChargeItem.RequestedQuantity,

      @ObjectModel.foreignKey.association: '_RequestedQuantityUnit'
      SalesOrderWithoutChargeItem.RequestedQuantityUnit,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      SalesOrderWithoutChargeItem.ItemGrossWeight,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      SalesOrderWithoutChargeItem.ItemNetWeight,

      @ObjectModel.foreignKey.association: '_ItemWeightUnit'
      SalesOrderWithoutChargeItem.ItemWeightUnit,

      @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
      SalesOrderWithoutChargeItem.ItemVolume,

      @ObjectModel.foreignKey.association: '_ItemVolumeUnit'
      SalesOrderWithoutChargeItem.ItemVolumeUnit,

      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      SalesOrderWithoutChargeItem.TransactionCurrency,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      SalesOrderWithoutChargeItem.NetAmount,

      @ObjectModel.foreignKey.association: '_Product'
      SalesOrderWithoutChargeItem.Product,

      @ObjectModel.foreignKey.association: '_ProductGroup'
      SalesOrderWithoutChargeItem.ProductGroup,

      SalesOrderWithoutChargeItem.MaterialByCustomer,

      @ObjectModel.foreignKey.association: '_ProductPricingGroup'
      cast (MaterialPricingGroup as productpricinggroup preserving type )     as MaterialPricingGroup,

      @ObjectModel.foreignKey.association: '_Batch'
      SalesOrderWithoutChargeItem.Batch,

      @ObjectModel.foreignKey.association: '_Plant'
      SalesOrderWithoutChargeItem.Plant,

      @ObjectModel.foreignKey.association: '_StorageLocation'
      SalesOrderWithoutChargeItem.StorageLocation,
      
      @ObjectModel.foreignKey.association: '_ShippingPoint'
      SalesOrderWithoutChargeItem.ShippingPoint,
      
      @ObjectModel.foreignKey.association: '_ShippingType'
      SalesOrderWithoutChargeItem.ShippingType,
      
      @ObjectModel.foreignKey.association: '_DeliveryPriority'
      SalesOrderWithoutChargeItem.DeliveryPriority,
      
      @ObjectModel.foreignKey.association: '_DeliveryDateTypeRule'
      SalesOrderWithoutChargeItem.DeliveryDateTypeRule,

      @ObjectModel.foreignKey.association: '_IncotermsClassification'
      SalesOrderWithoutChargeItem.IncotermsClassification,
      
      // IncotermsTransferLocation,

      SalesOrderWithoutChargeItem.IncotermsLocation1,
      SalesOrderWithoutChargeItem.IncotermsLocation2,

      @ObjectModel.foreignKey.association: '_SalesDocumentRjcnReason'
      SalesOrderWithoutChargeItem.SalesDocumentRjcnReason,

      SalesOrderWithoutChargeItem.WBSElementInternalID,
      @ObjectModel.foreignKey.association: '_WBSElementExternalID'
      SalesOrderWithoutChargeItem._WBSElementBasicData_2.WBSElementExternalID as WBSElementExternalID,

      @ObjectModel.foreignKey.association: '_ProfitCenter'
      SalesOrderWithoutChargeItem.ProfitCenter,
      
      @ObjectModel.foreignKey.association: '_ControllingArea'
      SalesOrderWithoutChargeItem.ControllingArea,

      @ObjectModel.foreignKey.association: '_SDProcessStatus'
      SalesOrderWithoutChargeItem.SDProcessStatus,
      
      @ObjectModel.foreignKey.association: '_DeliveryStatus'
      SalesOrderWithoutChargeItem.DeliveryStatus,

      // For Access control

      @Consumption.hidden: true
      _SalesOrderWithoutCharge.SalesOrderWithoutChargeType,
      @Consumption.hidden: true
      _SalesOrderWithoutCharge.OrganizationDivision,
      @Consumption.hidden: true
      _SalesOrderWithoutCharge.SalesOrganization,
      @Consumption.hidden: true
      _SalesOrderWithoutCharge.DistributionChannel,

      // Parent

      _SalesOrderWithoutCharge,

      // Associations

      SalesOrderWithoutChargeItem._SDProcessStatus,
      SalesOrderWithoutChargeItem._DeliveryStatus,
      @Consumption.filter.businessDate.at: true
      SalesOrderWithoutChargeItem._ProfitCenter,
      SalesOrderWithoutChargeItem._Plant,
      SalesOrderWithoutChargeItem._StorageLocation,
      SalesOrderWithoutChargeItem._Product,
      SalesOrderWithoutChargeItem._ProductGroup,
      SalesOrderWithoutChargeItem._SalesDocumentRjcnReason,
      SalesOrderWithoutChargeItem._IncotermsClassification,
      SalesOrderWithoutChargeItem._ItemWeightUnit,
      SalesOrderWithoutChargeItem._ItemVolumeUnit,
      SalesOrderWithoutChargeItem._RequestedQuantityUnit,
      SalesOrderWithoutChargeItem._TransactionCurrency,
      SalesOrderWithoutChargeItem._ItemCategory,
      SalesOrderWithoutChargeItem._ShippingPoint,
      SalesOrderWithoutChargeItem._ShippingType,
      SalesOrderWithoutChargeItem._DeliveryPriority,
      SalesOrderWithoutChargeItem._DeliveryDateTypeRule,
      SalesOrderWithoutChargeItem._SDDocumentRejectionStatus,
      SalesOrderWithoutChargeItem._ItemGeneralIncompletionStatus,
      SalesOrderWithoutChargeItem._DeliveryBlockStatus,
      SalesOrderWithoutChargeItem._CustomerGroup,
      SalesOrderWithoutChargeItem._Route,
      SalesOrderWithoutChargeItem._PartialDeliveryItem,
      SalesOrderWithoutChargeItem._CustomerPaymentTerms,
      _ControllingArea,
      _Batch,
      _ProductPricingGroup,
      _WBSElementExternalID

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESORDERWITHOUTCHARGEITEM",
"I_SLSDOCITEMCONFDELIVERYDATE",
"I_SLSDOCITEMENHANCEDFIELDS",
"I_SLSDOCITEMREQDDELIVERYDATE",
"I_WBSELEMENTBASICDATA",
"R_SALESORDERWITHOUTCHARGETP"
],
"ASSOCIATED":
[
"I_BATCH",
"I_CONTROLLINGAREA",
"I_CURRENCY",
"I_CUSTOMERGROUP",
"I_CUSTOMERPAYMENTTERMS",
"I_DELIVERYBLOCKSTATUS",
"I_DELIVERYDATETYPERULE",
"I_DELIVERYPRIORITY",
"I_DELIVERYSTATUS",
"I_INCOTERMSCLASSIFICATION",
"I_ITEMGENINCOMPLETIONSTATUS",
"I_PARTIALDELIVERYITEM",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTGROUP_2",
"I_PRODUCTPRICINGGROUP",
"I_PROFITCENTER",
"I_ROUTE",
"I_SALESDOCUMENTITEMCATEGORY",
"I_SALESDOCUMENTRJCNREASON",
"I_SDDOCUMENTREJECTIONSTATUS",
"I_SDPROCESSSTATUS",
"I_SHIPPINGPOINT",
"I_SHIPPINGTYPE",
"I_STORAGELOCATION",
"I_UNITOFMEASURE",
"I_WBSELEMENTBYEXTERNALID",
"R_SALESORDERWITHOUTCHARGETP"
],
"BASE":
[
"I_SALESORDERWITHOUTCHARGEITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

R_SlsOrderWithoutChargeItemTP view_entity

I_SalesOrderWithoutChargeItem view