Which tables does C_SalesDocOutputRequestItemTP use?

C_SalesDocOutputRequestItemTP reads from 1 data source(s): R_OutputRequestItemTP.

How many fields does C_SalesDocOutputRequestItemTP have?

C_SalesDocOutputRequestItemTP has 49 fields. Key fields: OutputRequestItemUUID.

C_SalesDocOutputRequestItemTP

DDL: C_SALESDOCOUTPUTREQUESTITEMTP Type: view_entity CONSUMPTION Package: ODATA_SD_S4H_COMMON

Output Request Item for Sales Document

C_SalesDocOutputRequestItemTP is a Consumption CDS View that provides data about "Output Request Item for Sales Document" in SAP S/4HANA. It reads from 1 data source (R_OutputRequestItemTP) and exposes 49 fields with key field OutputRequestItemUUID. It has 4 associations to related views. It is exposed through 7 OData services (C_SALESORDERMANAGE_SD, UI_CREDITMEMOREQUESTMANAGE, UI_CUSTOMERRETURNMANAGE, ...). Part of development package ODATA_SD_S4H_COMMON.

Data Sources (1)

Source	Alias	Join Type
R_OutputRequestItemTP	R_OutputRequestItemTP	projection

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_User	_CreatedByUser	`$projection.CreatedByUser = _CreatedByUser.UserID`
[0..1]	I_User	_LastChangedByUser	`$projection.LastChangedByUser = _LastChangedByUser.UserID`
[0..1]	C_PartnerFunctionUnconverted	_PartnerFunction	`$projection.RecipientRole = _PartnerFunction.PartnerFunction`
[0..1]	C_SalesDocSalesOrganizationVH	_SalesOrganization	`$projection.SenderOrganizationalCenter = _SalesOrganization.SalesOrganization`

Annotations (12)

Name	Value	Level
EndUserText.label	Output Request Item for Sales Document	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.contract.type	#NONE	view
ObjectModel.modelingPattern	#TRANSACTIONAL_QUERY	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.query.implementedBy	ABAP:CL_SD_OUTPREQ_RAP_STICKY_QRY	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
Feature	SW:Q2C_SLS_DOC_OUTPUT_CONTROL	view

OData Services (7)

Service	Binding	Version	Contract	Release
C_SALESORDERMANAGE_SD	C_SALESORDERMANAGE_SRV	V4	C1	NOT_RELEASED
UI_CREDITMEMOREQUESTMANAGE	UI_CREDITMEMOREQUESTMANAGE	V4	C1	NOT_RELEASED
UI_CUSTOMERRETURNMANAGE	UI_CUSTOMERRETURNMANAGE	V4	C1	NOT_RELEASED
UI_DEBITMEMOREQUESTMANAGE	UI_DEBITMEMOREQUESTMANAGE	V4	C1	NOT_RELEASED
UI_SALESCONTRACTMANAGE	UI_SALESCONTRACTMANAGE	V4	C1	NOT_RELEASED
UI_SALESQUOTATIONMANAGE	UI_SALESQUOTATIONMANAGE	V4	C1	NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE	UI_SLSORDERWITHOUTCHARGEMANAGE	V4	C1	NOT_RELEASED

Fields (49)

Key	Field	Source Table	Source Field
KEY	OutputRequestItemUUID	OutputRequestItem	OutputRequestItemUUID
	OutputControlApplObjectType	OutputRequestItem	OutputControlApplObjectType
	OutputControlApplicationObject	OutputRequestItem	OutputControlApplicationObject
	OutputRequestItem	OutputRequestItem	OutputRequestItem
	OutputRequestUUID	OutputRequestItem	OutputRequestUUID
	virtualMimeTypew3conttype
	rawstring
	OutputRequestItemStatus	OutputRequestItem	OutputRequestItemStatus
	DispatchTime	OutputRequestItem	DispatchTime
	OutputDocumentType	OutputRequestItem	OutputDocumentType
	OutputChannel	OutputRequestItem	OutputChannel
	RecipientRole	OutputRequestItem	RecipientRole
	Recipient	OutputRequestItem	Recipient
	FormTemplateCountry	OutputRequestItem	FormTemplateCountry
	FormTemplateLanguage	OutputRequestItem	FormTemplateLanguage
	FormTemplate	OutputRequestItem	FormTemplate
	FormTemplateType	OutputRequestItem	FormTemplateType
	IsChangeDocument	OutputRequestItem	IsChangeDocument
	CreationDateTime	OutputRequestItem	CreationDateTime
	CreatedByUser	OutputRequestItem	CreatedByUser
	LastChangeDateTime	OutputRequestItem	LastChangeDateTime
	LastChangedByUser	OutputRequestItem	LastChangedByUser
	SenderOrganizationalCenter		SenderOrganizationalCenter
	SenderOrganizationalCenterType		SenderOrganizationalCenterType
	SenderCountry		SenderCountry
	PrintQueue		PrintQueue
	PrintCopyNumber		PrintCopyNumber
	OutputQueue		OutputQueue
	OutputItemDataTransferMode		OutputItemDataTransferMode
	virtualUICT_HideLogabap_boolean
	virtualUICT_HidePrintQueueabap_boolean
	virtualUICT_HideOutputQueueabap_boolean
	_OutputControlApplObjectType	OutputRequestItem	_OutputControlApplObjectType
	_PrintQueueVH	OutputRequestItem	_PrintQueueVH
	_SalesOrganization		_SalesOrganization
	_OutputRequestItemStatus	OutputRequestItem	_OutputRequestItemStatus
	_SenderCountry	OutputRequestItem	_SenderCountry
	_DispatchTime	OutputRequestItem	_DispatchTime
	_OutputDocumentType	OutputRequestItem	_OutputDocumentType
	_OutputSenderOrgType	OutputRequestItem	_OutputSenderOrgType
	_OutputChannel	OutputRequestItem	_OutputChannel
	_PartnerFunction		_PartnerFunction
	_CreatedByUser		_CreatedByUser
	_LastChangedByUser		_LastChangedByUser
	_FormTemplate	OutputRequestItem	_FormTemplate
	_FormTemplateCountry	OutputRequestItem	_FormTemplateCountry
	_FormTemplateLanguage	OutputRequestItem	_FormTemplateLanguage
	_DataTransferMode	OutputRequestItem	_DataTransferMode
	_OutputQueueVH	OutputRequestItem	_OutputQueueVH

@EndUserText.label: 'Output Request Item for Sales Document'
@AccessControl: { authorizationCheck: #PRIVILEGED_ONLY,
                  privilegedAssociations: [ '_OutputRequest',
                                            '_OutputRequestItemLog',
                                            '_CreatedByUser',
                                            '_LastChangedByUser' ]}


@VDM: {
  viewType: #CONSUMPTION,
  lifecycle.contract.type: #NONE,
  usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
}
@ObjectModel: {
   modelingPattern:       #TRANSACTIONAL_QUERY,
   supportedCapabilities: [#TRANSACTIONAL_PROVIDER],
   usageType: {
    serviceQuality: #C,
    sizeCategory: #XL,
    dataClass: #MIXED },
    query.implementedBy: 'ABAP:CL_SD_OUTPREQ_RAP_STICKY_QRY'
}

@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@Feature: 'SW:Q2C_SLS_DOC_OUTPUT_CONTROL'

define view entity C_SalesDocOutputRequestItemTP
  as projection on R_OutputRequestItemTP as OutputRequestItem

  association [0..1] to I_User                        as _CreatedByUser     on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                        as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID
  association [0..1] to C_PartnerFunctionUnconverted  as _PartnerFunction   on $projection.RecipientRole = _PartnerFunction.PartnerFunction
  association [0..1] to C_SalesDocSalesOrganizationVH as _SalesOrganization on $projection.SenderOrganizationalCenter = _SalesOrganization.SalesOrganization
{

  key     OutputRequestItem.OutputRequestItemUUID,
          OutputRequestItem.OutputControlApplObjectType,
          OutputRequestItem.OutputControlApplicationObject,
          OutputRequestItem.OutputRequestItem,
          OutputRequestItem.OutputRequestUUID,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_APOC_ITM_STD_MIME_TYPE'
  virtual MimeType                       : w3conttype,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_APOC_ITM_STD_BIN_DATA'
          @Semantics.largeObject.contentDispositionPreference: #INLINE
          @Semantics.largeObject.mimeType: 'MimeType'
  virtual OutputBinaryData               : abap.rawstring,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_APOC_ITM_STD_BIN_DATA_AVAIL'
  virtual OutputBinaryDataIsNotAvailable : boole_d,

          @ObjectModel.foreignKey.association: '_OutputRequestItemStatus'
          OutputRequestItem.OutputRequestItemStatus,

          @ObjectModel.foreignKey.association: '_DispatchTime'
          OutputRequestItem.DispatchTime,

          @ObjectModel.foreignKey.association: '_OutputDocumentType'
          OutputRequestItem.OutputDocumentType,

          @ObjectModel.foreignKey.association: '_OutputChannel'
          OutputRequestItem.OutputChannel,

          @ObjectModel.foreignKey.association: '_PartnerFunction'
          OutputRequestItem.RecipientRole,
          OutputRequestItem.Recipient,

          @ObjectModel.foreignKey.association: '_FormTemplateCountry'
          OutputRequestItem.FormTemplateCountry,
          @ObjectModel.foreignKey.association: '_FormTemplateLanguage'
          OutputRequestItem.FormTemplateLanguage,
          @ObjectModel.foreignKey.association: '_FormTemplate'
          OutputRequestItem.FormTemplate,
          OutputRequestItem.FormTemplateType,

          OutputRequestItem.IsChangeDocument,
          @Semantics.nullValueIndicatorFor: 'IsChangeDocument'
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_SD_S4H_SDOC_ODATA_UTIL'
          @Consumption.hidden: true
  virtual IsChangeDocument_H             : rap_null_value_indicator,

          OutputRequestItem.CreationDateTime,
          @ObjectModel.foreignKey.association: '_CreatedByUser'
          OutputRequestItem.CreatedByUser,
          OutputRequestItem.LastChangeDateTime,
          @ObjectModel.foreignKey.association: '_LastChangedByUser'
          OutputRequestItem.LastChangedByUser,

          @ObjectModel.foreignKey.association: '_SalesOrganization'
          SenderOrganizationalCenter,

          @ObjectModel.foreignKey.association: '_OutputSenderOrgType'
          SenderOrganizationalCenterType,

          @ObjectModel.foreignKey.association: '_SenderCountry'
          SenderCountry,

          @ObjectModel.foreignKey.association: '_PrintQueueVH'
          PrintQueue,

          PrintCopyNumber,

          @ObjectModel.foreignKey.association: '_OutputQueueVH'
          OutputQueue,

          @ObjectModel.foreignKey.association: '_DataTransferMode'
          OutputItemDataTransferMode,

          @ObjectModel: { virtualElement:             true,
                          virtualElementCalculatedBy: 'ABAP:CL_APOC_ITM_STD_VIRTUAL_FIELDS' }
  virtual OutputItemStatusCriticality    : apoc_criticality,

          @ObjectModel: { virtualElement:             true,
                          virtualElementCalculatedBy: 'ABAP:CL_APOC_ITM_STD_VIRTUAL_FIELDS' }
  virtual UICT_HideLog                   : abap_boolean,

          @ObjectModel: { virtualElement:             true,
                          virtualElementCalculatedBy: 'ABAP:CL_APOC_ITM_STD_VIRTUAL_FIELDS' }
  virtual UICT_HidePrintQueue            : abap_boolean,

          @ObjectModel: { virtualElement:             true,
                          virtualElementCalculatedBy: 'ABAP:CL_APOC_ITM_STD_VIRTUAL_FIELDS' }
  virtual UICT_HideOutputQueue           : abap_boolean,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _OutputRequest        : redirected to parent C_SalesDocumentOutputRequestTP,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _OutputRequestItemLog : redirected to composition child C_SlsDocOutputRequestItemLogTP,

          /* Associations */
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._OutputControlApplObjectType,
          @ObjectModel.sort.enabled: false
          @ObjectModel.filter.enabled: false
          OutputRequestItem._PrintQueueVH,
          @ObjectModel.sort.enabled: false
          @ObjectModel.filter.enabled: false
          _SalesOrganization,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._OutputRequestItemStatus,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._SenderCountry,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._DispatchTime,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._OutputDocumentType,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._OutputSenderOrgType,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._OutputChannel,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _PartnerFunction,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _CreatedByUser,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _LastChangedByUser,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._FormTemplate,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._FormTemplateCountry,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._FormTemplateLanguage,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._DataTransferMode,
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          OutputRequestItem._OutputQueueVH
}
where
  OutputControlApplObjectType = 'SALES_DOCUMENT'

Depth:

C_SalesDocOutputRequestItemTP view_entity

R_OutputRequestItemTP view_entity