C_PhysInvtryDocItemForPrint

DDL: C_PHYSINVTRYDOCITEMFORPRINT SQL: CPHINVDOCITMPRNT Type: view CONSUMPTION
80 Fields 1 Data Sources 2 Associations

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)

SourceAliasJoin Type
I_PhysInvtryDocItem I_PhysInvtryDocItem from

Associations (2)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY PhysicalInventoryDocument PhysicalInventoryDocument Physical Inventory Document
KEY PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem Physical Inventory Document Item
Material Material Vehicle Model
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
InventorySpecialStockType InventorySpecialStockType Special Stock Type
PhysicalInventoryStockType PhysicalInventoryStockType Stock Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
ScheduleLine ScheduleLine Schedule Line
Supplier Supplier Supplier
Customer Customer Sold-to Party
StockOwner StockOwner Owner of stock
LastChangedByUser LastChangeUser User Name
LastChangeDate LastChangeDate Time Stamp
CountedByUser CountedByUser Counted By
PhysicalInventoryLastCountDate PhysicalInventoryLastCountDate Count Date
AdjustmentPostingMadeByUser AdjustmentPostingMadeByUser Adjustment Posting Made By
PostingDate PostingDate Posting Date for GR
PhysInventoryReferenceNumber PhysInventoryReferenceNumber Physical Inventory Reference
PhysicalInventoryItemIsCounted PhysicalInventoryItemIsCounted Is Counted
PhysInvtryDifferenceIsPosted PhysInvtryDifferenceIsPosted Is Difference Posted
PhysInvtryItemIsRecounted PhysInvtryItemIsRecounted Is Recounted
PhysInvtryItemIsDeleted PhysInvtryItemIsDeleted Is Deleted
IsHandledInAltvUnitOfMsr IsHandledInAltvUnitOfMsr Without Unit of Measure Proposal
BookQtyBfrCountInMatlBaseUnit BookQtyBfrCountInMatlBaseUnit Book Quantity
PhysicalInventoryItemIsZero PhysicalInventoryItemIsZero Zero Counted
Quantity Quantity Value
MaterialBaseUnit MaterialBaseUnit Valuation Unit
QuantityInUnitOfEntry QuantityInUnitOfEntry Quantity in UnE
UnitOfEntry UnitOfEntry Unit of Entry
MaterialDocumentYear MaterialDocumentYear Material Document Year
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentItem MaterialDocumentItem Material Document Item
PhysInvtryRecountDocument PhysInvtryRecountDocument Recount Doc.
DifferenceAmountInCoCodeCrcy DifferenceAmountInCoCodeCrcy Difference Val.
Currency Currency Valuation Crcy
CycleCountType CycleCountType Cycle Count Type
SlsPrcAmtInclVATInCoCodeCrcy SlsPrcAmtInclVATInCoCodeCrcy SalVal inc. VAT
SlsPrcAmtExclVATInCoCodeCrcy SlsPrcAmtExclVATInCoCodeCrcy SalVal w/o VAT
DiffAmountOnCountEntryInCCCrcy DiffAmountOnCountEntryInCCCrcy Diff. Value
EnteredSlsAmtInCoCodeCrcy EnteredSlsAmtInCoCodeCrcy Sales Price Counted Value
SlsPriceAmountInCoCodeCrcy SlsPriceAmountInCoCodeCrcy Sales Price Book Value
IsValueOnlyMaterial IsValueOnlyMaterial Is Value-Only Material
PhysInvtryCtAmtInCoCodeCrcy PhysInvtryCtAmtInCoCodeCrcy Counted Quantity Value
BookQtyAmountInCoCodeCrcy BookQtyAmountInCoCodeCrcy Book Value
ProductCategory ProductCategory Prod Category
ReasonForPhysInvtryDifference ReasonForPhysInvtryDifference Difference Reason
CrossPlantConfigurableMaterial CrossPlantConfigurableMaterial Cross-Plant Configurable Material
PhysInvtryDiffIsDistributed PhysInvtryDiffIsDistributed Difference Distributed
DocItemMaterialCategory
MaterialName
PhysicalInventoryStatusText
PhysicalInventoryStockTypeName
WarehouseStorageBin _ProductStorageLocation WarehouseStorageBin Storage Bin
StockSegment _Batch StockSegment Stock Segment
_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

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_PhysInvtryDocItemForPrint.
-- 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.
-- SQL view name: CPHINVDOCITMPRNT

CREATE VIEW C_PhysInvtryDocItemForPrint AS
SELECT
  FiscalYear,
  PhysicalInventoryDocument,
  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,
  BookQtyBfrCountInMatlBaseUnit,
  PhysicalInventoryItemIsZero,
  Quantity,
  MaterialBaseUnit,
  QuantityInUnitOfEntry,
  UnitOfEntry,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  PhysInvtryRecountDocument,
  DifferenceAmountInCoCodeCrcy,
  Currency,
  CycleCountType,
  SlsPrcAmtInclVATInCoCodeCrcy,
  SlsPrcAmtExclVATInCoCodeCrcy,
  DiffAmountOnCountEntryInCCCrcy,
  EnteredSlsAmtInCoCodeCrcy,
  SlsPriceAmountInCoCodeCrcy,
  IsValueOnlyMaterial,
  PhysInvtryCtAmtInCoCodeCrcy,
  BookQtyAmountInCoCodeCrcy,
  ProductCategory,
  ReasonForPhysInvtryDifference,
  CrossPlantConfigurableMaterial,
  PhysInvtryDiffIsDistributed,
  cast( '' as abap.char(1) ) AS DocItemMaterialCategory,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  _PhysInvtryStatusT[1: Language=$session.system_language].PhysicalInventoryStatusText AS PhysicalInventoryStatusText,
  _PhysicalInventoryStockType._Text[1: Language=$session.system_language].PhysicalInventoryStockTypeName AS PhysicalInventoryStockTypeName,
  _ProductStorageLocation.WarehouseStorageBin AS WarehouseStorageBin,
  _Batch.StockSegment AS StockSegment
FROM I_PhysInvtryDocItem
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Plant = _Batch.Plant AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN E_PhysInvtryDocumentItem AS _PrintExtension ON FiscalYear = _PrintExtension.FiscalYear AND PhysicalInventoryDocument = _PrintExtension.PhysicalInventoryDocument AND PhysicalInventoryDocumentItem = _PrintExtension.PhysicalInventoryDocumentItem  -- association [0..1]
;

Learn More