How many fields does P_PurOrdItmAcctAssgmtDualStack have?

P_PurOrdItmAcctAssgmtDualStack has 80 fields. Key fields: PurchaseOrder, PurchaseOrderItem, PurchaseOrderItem.

P_PurOrdItmAcctAssgmtDualStack

Q: Which tables does P_PurOrdItmAcctAssgmtDualStack use?

P_PurOrdItmAcctAssgmtDualStack reads from 4 data source(s): I_PurOrdScheduleLineEnhanced, I_PurgAnalyticsConfiguration, I_PurgAnalyticsConfiguration, I_PurchaseOrderItem.

DDL: P_PURORDITMACCTASSGMTDUALSTACK SQL: PMMPOIDSTACK Type: view CONSUMPTION

Purchase order item from Dual stack

P_PurOrdItmAcctAssgmtDualStack is a Consumption CDS View that provides data about "Purchase order item from Dual stack" in SAP S/4HANA. It reads from 4 data sources (I_PurOrdScheduleLineEnhanced, I_PurgAnalyticsConfiguration, I_PurgAnalyticsConfiguration, I_PurchaseOrderItem) and exposes 80 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderItem.

Data Sources (4)

Source	Alias	Join Type
I_PurOrdScheduleLineEnhanced	I_PurOrdScheduleLineEnhanced	inner
I_PurgAnalyticsConfiguration	MigrationStatus	from
I_PurgAnalyticsConfiguration	MigrationStatus	union_all
I_PurchaseOrderItem	PurchaseOrderItem	inner

Parameters (2)

Name	Type	Default
P_StartDate	bedat
P_EndDate	bedat

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	PMMPOIDSTACK	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Purchase order item from Dual stack	view
VDM.viewType	#CONSUMPTION	view
VDM.private	true	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view

Fields (80)

Key	Field	Source Table	Source Field
KEY	PurchaseOrder		PurchaseOrder
KEY	PurchaseOrderItem
	PurchaseRequisition		PurchaseRequisition
	PurchaseRequisitionItem		PurchaseRequisitionItem
	Supplier		Supplier
	PurchasingOrganization		PurchasingOrganization
	PurchasingGroup		PurchasingGroup
	CompanyCode		CompanyCode
	PurchaseOrderType		PurchaseOrderType
	PurchaseOrderDate		PurchaseOrderDate
	CreatedByUser		CreatedByUser
	Currency		DocumentCurrency
	MaterialGroup		MaterialGroup
	Material		Material
	Plant		Plant
	PurchaseOrderItemCategory		PurchaseOrderItemCategory
	PurchaseOrderCategory		PurchaseOrderCategory
	PurchaseContract		PurchaseContract
	PurchaseContractItem		PurchaseContractItem
	ProductType		ProductTypeCode
	ServicePerformer		ServicePerformer
	MultipleAcctAssgmtDistribution		MultipleAcctAssgmtDistribution
	AccountAssignmentCategory		AccountAssignmentCategory
	PurchaseOrderQuantityUnit		PurchaseOrderQuantityUnit
	DocumentCurrency		DocumentCurrency
	NetAmount
	NetAmountInReportingCurrency		NetAmountInReportingCurrency
	NetAmountInReportingCurrency2		NetAmountInReportingCurrency2
	NetAmountInCoCodeCurrency		NetAmountInCoCodeCurrency
	NetPriceAmount
	NetPriceInReportingCurrency		NetPriceInReportingCurrency
	NetPriceInReportingCurrency2		NetPriceInReportingCurrency2
	NetPriceInCompanyCodeCrcy		NetPriceInCompanyCodeCrcy
	IsReturnsItem		IsReturnsItem
	PurchasingDocumentDeletionCode		PurchasingDocumentDeletionCode
	ReleaseIsNotCompleted		ReleaseIsNotCompleted
	PurchasingCompletenessStatus		PurchasingCompletenessStatus
	OrderQuantity		OrderQuantity
	AnalyticalReportingCurrency		AnalyticalReportingCurrency
	AnalyticalReportingCurrency2		AnalyticalReportingCurrency2
KEY	PurchaseOrderItem
	PurchaseRequisition	I_PurchaseOrderItem	PurchaseRequisition
	PurchaseRequisitionItem	I_PurchaseOrderItem	PurchaseRequisitionItem
	Supplier
	PurchasingOrganization
	PurchasingGroup
	CompanyCode
	PurchaseOrderType
	PurchaseOrderDate
	CreatedByUser
	Currency
	MaterialGroup	I_PurchaseOrderItem	MaterialGroup
	Material	I_PurchaseOrderItem	Material
	Plant	I_PurchaseOrderItem	Plant
	PurchaseOrderItemCategory	I_PurchaseOrderItem	PurchaseOrderItemCategory
	PurchaseOrderCategory	I_PurchaseOrderItem	PurchaseOrderCategory
	PurchaseContract	I_PurchaseOrderItem	PurchaseContract
	PurchaseContractItem	I_PurchaseOrderItem	PurchaseContractItem
	ProductType	I_PurchaseOrderItem	ProductType
	ServicePerformer	I_PurchaseOrderItem	ServicePerformer
	MultipleAcctAssgmtDistribution	I_PurchaseOrderItem	MultipleAcctAssgmtDistribution
	AccountAssignmentCategory	I_PurchaseOrderItem	AccountAssignmentCategory
	PurchaseOrderQuantityUnit	I_PurchaseOrderItem	PurchaseOrderQuantityUnit
	DocumentCurrency
	NetAmount	I_PurchaseOrderItem	NetAmount
	NetAmountInReportingCurrency
	NetAmountInReportingCurrency2
	NetAmountInCoCodeCurrency
	NetPriceAmount	I_PurchaseOrderItem	NetPriceAmount
	NetPriceInReportingCurrency
	NetPriceInReportingCurrency2
	NetPriceInCompanyCodeCrcy
	IsReturnsItem		IsReturnsItem
	PurchasingDocumentDeletionCode	I_PurchaseOrderItem	PurchasingDocumentDeletionCode
	ReleaseIsNotCompleted
	PurchasingCompletenessStatus
	OrderQuantity	I_PurchaseOrderItem	OrderQuantity
	AnalyticalReportingCurrency
	AnalyticalReportingCurrency2
	_Plant	I_PurchaseOrderItem	_Plant

@AbapCatalog.sqlViewName: 'PMMPOIDSTACK'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase order item from Dual stack'

@VDM.viewType : #CONSUMPTION
@VDM.private: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_PurOrdItmAcctAssgmtDualStack
  with parameters
    P_StartDate : bedat,
    P_EndDate   : bedat
  //  as

  as select from I_PurgAnalyticsConfiguration as MigrationStatus

    inner join   I_PurOrdScheduleLineEnhanced on MigrationStatus.IsIntrastatReportingRelevant = 'X'

{
  key  PurchaseOrder                                      as PurchaseOrder,
  key  cast( PurchaseOrderItem as vdm_purchaseorderitem ) as PurchaseOrderItem,
       PurchaseRequisition,
       PurchaseRequisitionItem,
       Supplier,
       PurchasingOrganization,
       PurchasingGroup,
       CompanyCode,
       PurchaseOrderType,
       PurchaseOrderDate,
       CreatedByUser,
       DocumentCurrency                                   as Currency,
       MaterialGroup,
       Material,
       Plant,
       PurchaseOrderItemCategory,
       PurchaseOrderCategory,
       PurchaseContract,
       PurchaseContractItem,
       ProductTypeCode                                    as ProductType,
       ServicePerformer,
       MultipleAcctAssgmtDistribution,
       AccountAssignmentCategory,
       PurchaseOrderQuantityUnit,
       DocumentCurrency,
       cast(NetAmount as abap.curr( 21, 5 ) )             as NetAmount,
       NetAmountInReportingCurrency,
       NetAmountInReportingCurrency2,
       NetAmountInCoCodeCurrency,
       cast(NetPriceAmount as abap.curr( 21, 5 ) )        as NetPriceAmount,
       NetPriceInReportingCurrency,
       NetPriceInReportingCurrency2,
       NetPriceInCompanyCodeCrcy,
       IsReturnsItem,
       PurchasingDocumentDeletionCode,
       ReleaseIsNotCompleted,
       PurchasingCompletenessStatus,
       OrderQuantity,
       AnalyticalReportingCurrency,
       AnalyticalReportingCurrency2,
       _Plant

}
where
      PurgDocumentItemDeletionCode   = ''
  and ReleaseIsNotCompleted          = ''
  and PurchasingCompletenessStatus   = ''
  and PurchasingDocumentDeletionCode = ''
  and DocumentCurrency != ''
  and PurchaseOrderDate              <= $parameters.P_EndDate
  and PurchaseOrderDate              >= $parameters.P_StartDate

group by
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseOrderDate,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  PurchaseOrderType,
  PurchaseOrderDate,
  CreatedByUser,
  DocumentCurrency,
  MaterialGroup,
  Material,
  Plant,
  PurchaseOrderItemCategory,
  PurchaseOrderCategory,
  PurchaseContract,
  PurchaseContractItem,
  ProductTypeCode,
  ServicePerformer,
  MultipleAcctAssgmtDistribution,
  AccountAssignmentCategory,
  PurchaseOrderQuantityUnit,
  DocumentCurrency,
  NetAmount,
  NetAmountInReportingCurrency,
  NetAmountInReportingCurrency2,
  NetAmountInCoCodeCurrency,
  NetPriceAmount,
  NetPriceInReportingCurrency,
  NetPriceInReportingCurrency2,
  NetPriceInCompanyCodeCrcy,
  IsReturnsItem,
  PurchasingDocumentDeletionCode,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  OrderQuantity,
  AnalyticalReportingCurrency,
  AnalyticalReportingCurrency2

union all select from I_PurgAnalyticsConfiguration as MigrationStatus

  inner join          I_PurchaseOrderItem          as PurchaseOrderItem on MigrationStatus.IsIntrastatReportingRelevant = ''

{
  key PurchaseOrder,
  key cast( PurchaseOrderItem.PurchaseOrderItem as vdm_purchaseorderitem ) as PurchaseOrderItem,
      PurchaseOrderItem.PurchaseRequisition,
      PurchaseOrderItem.PurchaseRequisitionItem,
      PurchaseOrderItem._PurchaseOrder.Supplier,
      PurchaseOrderItem._PurchaseOrder.PurchasingOrganization,
      PurchaseOrderItem._PurchaseOrder.PurchasingGroup,
      PurchaseOrderItem._PurchaseOrder.CompanyCode,
      PurchaseOrderItem._PurchaseOrder.PurchaseOrderType,
      PurchaseOrderItem._PurchaseOrder.PurchaseOrderDate,
      PurchaseOrderItem._PurchaseOrder.CreatedByUser,
      PurchaseOrderItem._PurchaseOrder.DocumentCurrency                    as Currency,
      PurchaseOrderItem.MaterialGroup,
      PurchaseOrderItem.Material,
      PurchaseOrderItem.Plant,
      PurchaseOrderItem.PurchaseOrderItemCategory,
      PurchaseOrderItem.PurchaseOrderCategory,
      PurchaseOrderItem.PurchaseContract,
      PurchaseOrderItem.PurchaseContractItem,
      PurchaseOrderItem.ProductType,
      PurchaseOrderItem.ServicePerformer,
      PurchaseOrderItem.MultipleAcctAssgmtDistribution,
      PurchaseOrderItem.AccountAssignmentCategory,
      PurchaseOrderItem.PurchaseOrderQuantityUnit,
      PurchaseOrderItem._PurchaseOrder.DocumentCurrency,
      PurchaseOrderItem.NetAmount,
      cast ( 0 as obmng_repcurr1 )                                         as NetAmountInReportingCurrency, // Open Quantity Amount in Reporting Currency 1,

      cast ( 0 as obmng_repcurr2 )                                         as NetAmountInReportingCurrency2, // Open Quantity Amount in Reporting Currency 2

      cast ( 0 as obmng_basecurr )                                         as NetAmountInCoCodeCurrency, // Open Amount in Company Code Currency

      PurchaseOrderItem.NetPriceAmount,
      cast ( 0 as netpr_repcrcy1 )                                         as NetPriceInReportingCurrency,  // Open Quantity Amount in Reporting Currency 1,

      cast ( 0 as netpr_repcrcy2)                                          as NetPriceInReportingCurrency2, // Open Quantity Amount in Reporting Currency 2

      cast ( 0 as netpr_basecurr )                                         as NetPriceInCompanyCodeCrcy,
      IsReturnsItem,
      PurchaseOrderItem.PurchasingDocumentDeletionCode,
      PurchaseOrderItem._PurchaseOrder.ReleaseIsNotCompleted,
      PurchaseOrderItem._PurchaseOrder.PurchasingCompletenessStatus,
      PurchaseOrderItem.OrderQuantity,
      cast ( '' as abap.cuky(5) )                                          as AnalyticalReportingCurrency, // Reporting Currency 1

      cast ( '' as abap.cuky(5) )                                          as AnalyticalReportingCurrency2, // Reporting Currency 2

      PurchaseOrderItem._Plant
}
where
      PurchaseOrderItem._PurchaseOrder.PurchasingDocumentDeletionCode = ''
  and PurchaseOrderItem._PurchaseOrder.ReleaseIsNotCompleted          = ''
  and PurchaseOrderItem._PurchaseOrder.PurchasingCompletenessStatus   = ''
  and PurchaseOrderItem.PurchasingDocumentDeletionCode                = ''
  and PurchaseOrderItem._PurchaseOrder.DocumentCurrency != ''
  and PurchaseOrderItem._PurchaseOrder.PurchaseOrderDate              <= $parameters.P_EndDate
  and PurchaseOrderItem._PurchaseOrder.PurchaseOrderDate              >= $parameters.P_StartDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM",
"I_PURGANALYTICSCONFIGURATION",
"I_PURORDSCHEDULELINEENHANCED"
],
"ASSOCIATED":
[
"I_PLANT"
],
"BASE":
[
"I_PURORDSCHEDULELINEENHANCED"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_PurOrdItmAcctAssgmtDualStack view

P_PurgSpndComprnAcctAssgmt view
P_PurgSpndComprnAcctAssgmt view