C_PhysInvtryDocItmCreate

DDL: C_PHYSINVTRYDOCITMCREATE SQL: CPICREATEITM Type: view CONSUMPTION
32 Fields 1 Data Sources

CDS View for the creation of new PI documents

C_PhysInvtryDocItmCreate is a Consumption CDS View that provides data about "CDS View for the creation of new PI documents" in SAP S/4HANA. It reads from 1 data source (P_PhysInvtryDocItmCreateTP) and exposes 32 fields with key fields PhysicalInventoryDocument, FiscalYear, PhysicalInventoryDocumentItem.

Data Sources (1)

SourceAliasJoin Type
P_PhysInvtryDocItmCreateTP P_PhysInvtryDocItmCreateTP from

Annotations (18)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CPICREATEITM view
EndUserText.label CDS View for the creation of new PI documents view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
OData.entitySet.name C_PhysInvtryDocItmCreate view
VDM.private false view
VDM.viewType #CONSUMPTION view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryDocument PhysicalInventoryDocument Physical Inventory Document
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem Physical Inventory Document Item
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
InventorySpecialStockType InventorySpecialStockType Special Stock Type
PhysicalInventoryType PhysicalInventoryType
InventoryTransactionType InventoryTransactionType Trans. Ev. Type
PhysicalInventoryGroupType PhysicalInventoryGroupType Grouping Type
PhysicalInventoryGroup PhysicalInventoryGroup Grpg Crit.
PhysicalInventoryNumber PhysicalInventoryNumber Physical Inventory Number
PhysInventoryReferenceNumber PhysInventoryReferenceNumber Physical Inventory Reference
PhysicalInventoryDocumentDesc PhysicalInventoryDocumentDesc Description
PostingIsBlockedForPhysInvtry PostingIsBlockedForPhysInvtry Posting Block
PhysInvtryDocHasQtySnapshot PhysInvtryDocHasQtySnapshot Book Inventory Freeze
DocumentDate DocumentDate Journal Entry Date
PhysInventoryPlannedCountDate PhysInventoryPlannedCountDate Plan.Count date
Material Material Vehicle Model
Batch RealProductBatch
ValuationType ValuationType Valuation Type
PhysicalInventoryStockType PhysicalInventoryStockType Stock Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
Supplier Supplier Supplier
Customer Customer Sold-to Party
StockOwner StockOwner Owner of stock
WBSElement WBSElement WBS Internal ID
LinkedSAPObjectKey
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_Customer _Customer
_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_PhysInvtryDocItmCreate.
-- 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: CPICREATEITM

CREATE VIEW C_PhysInvtryDocItmCreate AS
SELECT
  PhysicalInventoryDocument,
  FiscalYear,
  PhysicalInventoryDocumentItem,
  Plant,
  StorageLocation,
  InventorySpecialStockType,
  PhysicalInventoryType,
  InventoryTransactionType,
  PhysicalInventoryGroupType,
  PhysicalInventoryGroup,
  PhysicalInventoryNumber,
  PhysInventoryReferenceNumber,
  PhysicalInventoryDocumentDesc,
  PostingIsBlockedForPhysInvtry,
  PhysInvtryDocHasQtySnapshot,
  DocumentDate,
  PhysInventoryPlannedCountDate,
  Material,
  RealProductBatch AS Batch,
  ValuationType,
  PhysicalInventoryStockType,
  SalesOrder,
  SalesOrderItem,
  Supplier,
  Customer,
  StockOwner,
  WBSElement,
  cast('' as objky) AS LinkedSAPObjectKey
FROM P_PhysInvtryDocItmCreateTP
;

Learn More