Which tables does C_PhysInvtryDocItemForPrint use?

C_PhysInvtryDocItemForPrint reads from 1 data source(s): I_PhysInvtryDocItem.

How many fields does C_PhysInvtryDocItemForPrint have?

C_PhysInvtryDocItemForPrint has 80 fields. Key fields: FiscalYear, PhysicalInventoryDocument, PhysicalInventoryDocumentItem.

C_PhysInvtryDocItemForPrint

DDL: C_PHYSINVTRYDOCITEMFORPRINT SQL: CPHINVDOCITMPRNT Type: view CONSUMPTION

Physical Inventory Doc Item for Print

C_PhysInvtryDocItemForPrint is a Consumption CDS View that provides data about "Physical Inventory Doc Item for Print" in SAP S/4HANA. It reads from 1 data source (I_PhysInvtryDocItem) and exposes 80 fields with key fields FiscalYear, PhysicalInventoryDocument, PhysicalInventoryDocumentItem. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_PhysInvtryDocItem	I_PhysInvtryDocItem	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_Batch	_Batch	`$projection.Material = _Batch.Material and $projection.Plant = _Batch.Plant and $projection.Batch = _Batch.Batch`
[0..1]	E_PhysInvtryDocumentItem	_PrintExtension	`$projection.FiscalYear = _PrintExtension.FiscalYear and $projection.PhysicalInventoryDocument = _PrintExtension.PhysicalInventoryDocument and $projection.PhysicalInventoryDocumentItem = _PrintExtension.PhysicalInventoryDocumentItem`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CPHINVDOCITMPRNT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Physical Inventory Doc Item for Print	view
VDM.viewType	#CONSUMPTION	view
VDM.private	false	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (80)

Key	Field	Source Table	Source Field
KEY	FiscalYear		FiscalYear
KEY	PhysicalInventoryDocument		PhysicalInventoryDocument
KEY	PhysicalInventoryDocumentItem		PhysicalInventoryDocumentItem
	Material		Material
	Plant		Plant
	StorageLocation		StorageLocation
	Batch		Batch
	InventorySpecialStockType		InventorySpecialStockType
	PhysicalInventoryStockType		PhysicalInventoryStockType
	SalesOrder		SalesOrder
	SalesOrderItem		SalesOrderItem
	ScheduleLine		ScheduleLine
	Supplier		Supplier
	Customer		Customer
	StockOwner		StockOwner
	LastChangedByUser		LastChangeUser
	LastChangeDate		LastChangeDate
	CountedByUser		CountedByUser
	PhysicalInventoryLastCountDate		PhysicalInventoryLastCountDate
	AdjustmentPostingMadeByUser		AdjustmentPostingMadeByUser
	PostingDate		PostingDate
	PhysInventoryReferenceNumber		PhysInventoryReferenceNumber
	PhysicalInventoryItemIsCounted		PhysicalInventoryItemIsCounted
	PhysInvtryDifferenceIsPosted		PhysInvtryDifferenceIsPosted
	PhysInvtryItemIsRecounted		PhysInvtryItemIsRecounted
	PhysInvtryItemIsDeleted		PhysInvtryItemIsDeleted
	IsHandledInAltvUnitOfMsr		IsHandledInAltvUnitOfMsr
	BookQtyBfrCountInMatlBaseUnit		BookQtyBfrCountInMatlBaseUnit
	PhysicalInventoryItemIsZero		PhysicalInventoryItemIsZero
	Quantity		Quantity
	MaterialBaseUnit		MaterialBaseUnit
	QuantityInUnitOfEntry		QuantityInUnitOfEntry
	UnitOfEntry		UnitOfEntry
	MaterialDocumentYear		MaterialDocumentYear
	MaterialDocument		MaterialDocument
	MaterialDocumentItem		MaterialDocumentItem
	PhysInvtryRecountDocument		PhysInvtryRecountDocument
	DifferenceAmountInCoCodeCrcy		DifferenceAmountInCoCodeCrcy
	Currency		Currency
	CycleCountType		CycleCountType
	SlsPrcAmtInclVATInCoCodeCrcy		SlsPrcAmtInclVATInCoCodeCrcy
	SlsPrcAmtExclVATInCoCodeCrcy		SlsPrcAmtExclVATInCoCodeCrcy
	DiffAmountOnCountEntryInCCCrcy		DiffAmountOnCountEntryInCCCrcy
	EnteredSlsAmtInCoCodeCrcy		EnteredSlsAmtInCoCodeCrcy
	SlsPriceAmountInCoCodeCrcy		SlsPriceAmountInCoCodeCrcy
	IsValueOnlyMaterial		IsValueOnlyMaterial
	PhysInvtryCtAmtInCoCodeCrcy		PhysInvtryCtAmtInCoCodeCrcy
	BookQtyAmountInCoCodeCrcy		BookQtyAmountInCoCodeCrcy
	ProductCategory		ProductCategory
	ReasonForPhysInvtryDifference		ReasonForPhysInvtryDifference
	CrossPlantConfigurableMaterial		CrossPlantConfigurableMaterial
	PhysInvtryDiffIsDistributed		PhysInvtryDiffIsDistributed
	DocItemMaterialCategory
	MaterialName
	PhysicalInventoryStatusText
	PhysicalInventoryStockTypeName
	WarehouseStorageBin	_ProductStorageLocation	WarehouseStorageBin
	StockSegment	_Batch	StockSegment
	_Customer		_Customer
	_Product		_Product
	_ProductPlant		_ProductPlant
	_Supplier		_Supplier
	_Batch		_Batch
	_PhysInvtryDocFiscalYear		_PhysInvtryDocFiscalYear
	_PhysInvtryDocHeader		_PhysInvtryDocHeader
	_Material		_Material
	_Plant		_Plant
	_StorageLocation		_StorageLocation
	_InventorySpecialStockType		_InventorySpecialStockType
	_PhysicalInventoryStockType		_PhysicalInventoryStockType
	_SalesOrder		_SalesOrder
	_SalesOrderItem		_SalesOrderItem
	_SalesOrderScheduleLine		_SalesOrderScheduleLine
	_MaterialBaseUnit		_MaterialBaseUnit
	_UnitOfEntry		_UnitOfEntry
	_Currency		_Currency
	_ProductCategory		_ProductCategory
	_CrossPlantConfigurableMatl		_CrossPlantConfigurableMatl
	_SupplierCompanyByPlant		_SupplierCompanyByPlant
	_CustomerCompanyByPlant		_CustomerCompanyByPlant

@AbapCatalog.sqlViewName: 'CPHINVDOCITMPRNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Physical Inventory Doc Item for Print'

@VDM:
      {
        viewType: #CONSUMPTION,
        private: false
      }
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking:#REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_PhysInvtryDocItemForPrint 
  as select from I_PhysInvtryDocItem 
                                                                                    
  association [0..1] to I_Batch                     as _Batch                       on  $projection.Material = _Batch.Material         
                                                                                    and $projection.Plant = _Batch.Plant                                                                                                                                                 
                                                                                    and $projection.Batch = _Batch.Batch                                                                                    
  // Custom Fields extensibility  

  association [0..1] to E_PhysInvtryDocumentItem    as _PrintExtension              on  $projection.FiscalYear = _PrintExtension.FiscalYear
                                                                                    and $projection.PhysicalInventoryDocument = _PrintExtension.PhysicalInventoryDocument
                                                                                    and $projection.PhysicalInventoryDocumentItem = _PrintExtension.PhysicalInventoryDocumentItem                                             

{
  key FiscalYear,
  key PhysicalInventoryDocument,
  key PhysicalInventoryDocumentItem,
  Material,
  Plant,
  StorageLocation,
  Batch,
  InventorySpecialStockType,
  PhysicalInventoryStockType,
  SalesOrder,
  SalesOrderItem,
  ScheduleLine,
  Supplier,
  Customer,
  StockOwner,
  LastChangeUser as LastChangedByUser,
  LastChangeDate,
  CountedByUser,
  PhysicalInventoryLastCountDate,
  AdjustmentPostingMadeByUser,
  PostingDate,
  PhysInventoryReferenceNumber,
  PhysicalInventoryItemIsCounted,
  PhysInvtryDifferenceIsPosted,
  PhysInvtryItemIsRecounted,
  PhysInvtryItemIsDeleted,
  IsHandledInAltvUnitOfMsr,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  @DefaultAggregation: #NONE
  BookQtyBfrCountInMatlBaseUnit,
  PhysicalInventoryItemIsZero,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  @DefaultAggregation: #NONE
  Quantity,
  @Semantics.unitOfMeasure: true
  MaterialBaseUnit,
  @Semantics.quantity.unitOfMeasure: 'UnitOfEntry'
  @DefaultAggregation: #NONE
  QuantityInUnitOfEntry,
  @Semantics.unitOfMeasure: true
  UnitOfEntry,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  PhysInvtryRecountDocument,
  @Semantics.amount.currencyCode: 'Currency'
  @DefaultAggregation: #NONE
  DifferenceAmountInCoCodeCrcy,
  @Semantics.currencyCode: true
  Currency,
  CycleCountType,
  @Semantics.amount.currencyCode: 'Currency'
  @DefaultAggregation: #NONE
  SlsPrcAmtInclVATInCoCodeCrcy,
  @Semantics.amount.currencyCode: 'Currency'
  @DefaultAggregation: #NONE
  SlsPrcAmtExclVATInCoCodeCrcy,
  @Semantics.amount.currencyCode: 'Currency'
  @DefaultAggregation: #NONE
  DiffAmountOnCountEntryInCCCrcy,
  @Semantics.amount.currencyCode: 'Currency'
  @DefaultAggregation: #NONE
  EnteredSlsAmtInCoCodeCrcy,
  @Semantics.amount.currencyCode: 'Currency'
  @DefaultAggregation: #NONE
  SlsPriceAmountInCoCodeCrcy,
  IsValueOnlyMaterial,
  @Semantics.amount.currencyCode: 'Currency'
  @DefaultAggregation: #NONE
  PhysInvtryCtAmtInCoCodeCrcy,
  @Semantics.amount.currencyCode: 'Currency'
  @DefaultAggregation: #NONE
  BookQtyAmountInCoCodeCrcy,
  ProductCategory,
  ReasonForPhysInvtryDifference,
  CrossPlantConfigurableMaterial,
  PhysInvtryDiffIsDistributed,
    
  cast( '' as abap.char(1) )  as DocItemMaterialCategory,
  _Material._Text[1: Language=$session.system_language].MaterialName,
  _PhysInvtryStatusT[1: Language=$session.system_language].PhysicalInventoryStatusText,
  _PhysicalInventoryStockType._Text[1: Language=$session.system_language].PhysicalInventoryStockTypeName,
  _ProductStorageLocation.WarehouseStorageBin,
  _Batch.StockSegment,
  
  
  /* Associations */
  _Customer,
  _Product,
  _ProductPlant,
  _Supplier,
  _Batch,
  
  //Exposed foreign key associations

  _PhysInvtryDocFiscalYear,
  _PhysInvtryDocHeader,
  _Material,
  _Plant,
  _StorageLocation,
  _InventorySpecialStockType,
  _PhysicalInventoryStockType,
  _SalesOrder,
  _SalesOrderItem,
  _SalesOrderScheduleLine,
  _MaterialBaseUnit,
  _UnitOfEntry,
  _Currency,
  _ProductCategory,
  _CrossPlantConfigurableMatl,
  
  //Exposed for Access controle

   _SupplierCompanyByPlant,
   _CustomerCompanyByPlant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BATCH",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_PHYSINVTRYDOCITEM",
"I_PHYSINVTRYSTATUST",
"I_PHYSINVTRYSTOCKTYPE",
"I_PHYSINVTRYSTOCKTYPETEXT",
"I_PRODUCTSTORAGELOCATION"
],
"ASSOCIATED":
[
"E_PHYSINVTRYDOCUMENTITEM",
"I_BATCH",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERCOMPANYBYPLANT",
"I_INVENTORYSPECIALSTOCKTYPE",
"I_MATERIAL",
"I_PHYSINVTRYDOCFISCALYEAR",
"I_PHYSINVTRYDOCHEADER",
"I_PHYSINVTRYSTOCKTYPE",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTCATEGORY",
"I_PRODUCTPLANT",
"I_SALESORDER",
"I_SALESORDERITEM",
"I_SALESORDERSCHEDULELINE",
"I_STORAGELOCATION",
"I_SUPPLIER",
"I_SUPPLIERCOMPANYBYPLANT",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_PHYSINVTRYDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_PhysInvtryDocItemForPrint view

I_PhysInvtryDocItem view