C_EWM_WhseDocumentHeaderTP

DDL: C_EWM_WHSEDOCUMENTHEADERTP Type: view_entity CONSUMPTION

Warehouse Document Header - TP

C_EWM_WhseDocumentHeaderTP is a Consumption CDS View that provides data about "Warehouse Document Header - TP" in SAP S/4HANA. It reads from 1 data source (R_EWM_WhseDocumentHeaderTP) and exposes 34 fields with key fields EWMWarehouse, EWMWarehouseDocument.

Data Sources (1)

SourceAliasJoin Type
R_EWM_WhseDocumentHeaderTP R_EWM_WhseDocumentHeaderTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Warehouse Document Header - TP view
Search.searchable true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations false view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse EWMWarehouse Warehouse No.
KEY EWMWarehouseDocument EWMWarehouseDocument
EWMNrOfWarehouseDocumentItems EWMNrOfWarehouseDocumentItems
Product Product Product Sold
ProductDescription ProductDescription Description
Batch Batch Lot No.
EWMStockType EWMStockType Stock Type
StockDocumentCategory StockDocumentCategory Special Reference Stock Type
StockDocumentNumber StockDocumentNumber
ExternalStockDocumentNumber ExternalStockDocumentNumber Special Ref. Stk Doc
EWMStockUsage EWMStockUsage Usage
StockUsageNameasStockUsageNamelocalized
EWMStockOwner EWMStockOwner Character Field with Length 10
EWMStockOwnerName EWMStockOwnerName
EntitledToDisposeParty EntitledToDisposeParty Disposal Party
EntitledToDisposePartyName EntitledToDisposePartyName
WhseTaskCrtnUTCDateTime WhseTaskCrtnUTCDateTime
WarehouseTimeZone WarehouseTimeZone Time Zone
CreatedByUser CreatedByUser User Name
CreatedByUserName CreatedByUserName Person Resp.
EWMStorageType EWMStorageType Storage Type
EWMStorageSection EWMStorageSection Storage Section
EWMStorageBin EWMStorageBin Storage Bin
HandlingUnitNumber HandlingUnitNumber
WarehouseMovementsText WarehouseMovementsText
WarehouseMovementsReason WarehouseMovementsReason
EWMWhseDocAcctAsgtCategory EWMWhseDocAcctAsgtCategory
EWMAccountAssignmentObject EWMAccountAssignmentObject
LogicalRecordTransactionCode LogicalRecordTransactionCode
virtualUICT_PostingDateabap_boolean
EWMWarehouseDocCancelableCode EWMWarehouseDocCancelableCode
WarehouseProcessCategory WarehouseProcessCategory
EWMWarehouseDocumentStatus EWMWarehouseDocumentStatus
EWMWarehouseDocumentStatusIcon EWMWarehouseDocumentStatusIcon

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_EWM_WhseDocumentHeaderTP.
-- 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.

CREATE VIEW C_EWM_WhseDocumentHeaderTP AS
SELECT
  EWMWarehouse,
  EWMWarehouseDocument,
  EWMNrOfWarehouseDocumentItems,
  Product,
  ProductDescription,
  Batch,
  EWMStockType,
  StockDocumentCategory,
  StockDocumentNumber,
  ExternalStockDocumentNumber,
  EWMStockUsage,
  _EWMStockUsageText.StockUsageName as StockUsageName : localized AS StockUsageNameasStockUsageNamelocalized,
  EWMStockOwner,
  EWMStockOwnerName,
  EntitledToDisposeParty,
  EntitledToDisposePartyName,
  WhseTaskCrtnUTCDateTime,
  WarehouseTimeZone,
  CreatedByUser,
  CreatedByUserName,
  EWMStorageType,
  EWMStorageSection,
  EWMStorageBin,
  HandlingUnitNumber,
  WarehouseMovementsText,
  WarehouseMovementsReason,
  EWMWhseDocAcctAsgtCategory,
  EWMAccountAssignmentObject,
  LogicalRecordTransactionCode,
  virtual UICT_PostingDate : abap_boolean AS virtualUICT_PostingDateabap_boolean,
  EWMWarehouseDocCancelableCode,
  WarehouseProcessCategory,
  EWMWarehouseDocumentStatus,
  EWMWarehouseDocumentStatusIcon
FROM R_EWM_WhseDocumentHeaderTP
;