I_PhysInvtryDocSrlNmbr

DDL: I_PHYSINVTRYDOCSRLNMBR SQL: IPIDOCSN Type: view COMPOSITE
21 Fields 4 Data Sources

Physical Inventory Doc Serial Number

I_PhysInvtryDocSrlNmbr is a Composite CDS View that provides data about "Physical Inventory Doc Serial Number" in SAP S/4HANA. It reads from 4 data sources (P_PhysInvtryDocSrlNmbr, P_PhysInvtryDocSrlNmbr, P_PhysInvtryDocSrlNmbr, P_PhysInvtryDocSrlNmbr) and exposes 21 fields with key fields PhysicalInventoryDocument, FiscalYear, PhysicalInventoryDocumentItem, SerialNumber, FiscalYear.

Data Sources (4)

SourceAliasJoin Type
P_PhysInvtryDocSrlNmbr act left_outer
P_PhysInvtryDocSrlNmbr act union
P_PhysInvtryDocSrlNmbr exp from
P_PhysInvtryDocSrlNmbr exp left_outer

Annotations (11)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IPIDOCSN view
EndUserText.label Physical Inventory Doc Serial Number view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryDocument P_PhysInvtryDocSrlNmbr PhysicalInventoryDocument Physical Inventory Document
KEY FiscalYear P_PhysInvtryDocSrlNmbr FiscalYear G/L Fiscal Year
KEY PhysicalInventoryDocumentItem P_PhysInvtryDocSrlNmbr PhysicalInventoryDocumentItem Physical Inventory Document Item
KEY SerialNumber P_PhysInvtryDocSrlNmbr SerialNumber Serial Number
Equipment P_PhysInvtryDocSrlNmbr Equipment Equipment check
Material P_PhysInvtryDocSrlNmbr Material Vehicle Model
Plant P_PhysInvtryDocSrlNmbr Plant Valuation Area
DocumentDate P_PhysInvtryDocSrlNmbr DocumentDate Journal Entry Date
DocumentType
SerialNumberIsInBooks
PhysicalInventoryDocument Physical Inventory Document
KEY FiscalYear P_PhysInvtryDocSrlNmbr FiscalYear G/L Fiscal Year
KEY PhysicalInventoryDocumentItem P_PhysInvtryDocSrlNmbr PhysicalInventoryDocumentItem Physical Inventory Document Item
KEY SerialNumber P_PhysInvtryDocSrlNmbr SerialNumber Serial Number
Equipment P_PhysInvtryDocSrlNmbr Equipment Equipment check
Material P_PhysInvtryDocSrlNmbr Material Vehicle Model
Plant P_PhysInvtryDocSrlNmbr Plant Valuation Area
DocumentDate P_PhysInvtryDocSrlNmbr DocumentDate Journal Entry Date
DocumentType
SerialNumberIsInBooks
SerialNumberIsCounted

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 I_PhysInvtryDocSrlNmbr.
-- 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: IPIDOCSN

CREATE VIEW I_PhysInvtryDocSrlNmbr AS
SELECT
  exp.PhysicalInventoryDocument AS PhysicalInventoryDocument,
  exp.FiscalYear AS FiscalYear,
  exp.PhysicalInventoryDocumentItem AS PhysicalInventoryDocumentItem,
  exp.SerialNumber AS SerialNumber,
  exp.Equipment AS Equipment,
  exp.Material AS Material,
  exp.Plant AS Plant,
  exp.DocumentDate AS DocumentDate,
  cast( 'I' as sn_history_doc_type preserving type ) AS DocumentType,
  'X' AS SerialNumberIsInBooks,
  'X' AS SerialNumberIsCounted
FROM P_PhysInvtryDocSrlNmbr AS exp
LEFT OUTER JOIN P_PhysInvtryDocSrlNmbr AS act ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PhysInvtryDocSrlNmbr AS exp ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): P_PhysInvtryDocSrlNmbr
;

Learn More