P_SupFrtInReqTrnChgItElmMigrtn

DDL: P_SUPFRTINREQTRNCHGITELMMIGRTN SQL: PSFTCELEMIGR Type: view BASIC Package: VDM_TM_STLMNT_MIGR
14 Fields 1 Data Sources

SFIR TrChrgEle with SFIR Root and PO item attr for migrtn

P_SupFrtInReqTrnChgItElmMigrtn is a Basic CDS View that provides data about "SFIR TrChrgEle with SFIR Root and PO item attr for migrtn" in SAP S/4HANA. It reads from 1 data source (P_SupFrtInReqTrnChgItElmPurItm) and exposes 14 fields with key field TranspChargeItemElementUUID. Part of development package VDM_TM_STLMNT_MIGR.

Data Sources (1)

SourceAliasJoin Type
P_SupFrtInReqTrnChgItElmPurItm P_SupFrtInReqTrnChgItElmPurItm from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PSFTCELEMIGR view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view
VDM.private true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY TranspChargeItemElementUUID P_SupFrtInReqTrnChgItElmPurItm TranspChargeItemElementUUID
mandt P_SupFrtInReqTrnChgItElmPurItm mandt Editing Client
TransportationChargesObjUUID P_SupFrtInReqTrnChgItElmPurItm TransportationChargesObjUUID
SuplrFrtInvcReqUUID P_SupFrtInReqTrnChgItElmPurItm SuplrFrtInvcReqUUID
TranspChargeCalcReslnBase P_SupFrtInReqTrnChgItElmPurItm TranspChargeCalcReslnBase
TranspChrgItmElmntResBaseKey P_SupFrtInReqTrnChgItElmPurItm TranspChrgItmElmntResBaseKey
PurgDocExternalReference P_SupFrtInReqTrnChgItElmPurItm PurgDocExternalReference Ext. Reference ID
SupplierFreightInvoiceRequest P_SupFrtInReqTrnChgItElmPurItm SupplierFreightInvoiceRequest
Carrier P_SupFrtInReqTrnChgItElmPurItm Carrier Service Agent
TranspOrdLogicalSystem P_SupFrtInReqTrnChgItElmPurItm TranspOrdLogicalSystem
TranspOrdInvoicingParty P_SupFrtInReqTrnChgItElmPurItm TranspOrdInvoicingParty
PurchaseOrder P_SupFrtInReqTrnChgItElmPurItm PurchaseOrder Purchasing Document
PurchaseOrderItem P_SupFrtInReqTrnChgItElmPurItm PurchaseOrderItem Purchasing Document Item
SDM_STATUS 00

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 P_SupFrtInReqTrnChgItElmMigrtn.
-- 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: PSFTCELEMIGR

CREATE VIEW P_SupFrtInReqTrnChgItElmMigrtn AS
SELECT
  P_SupFrtInReqTrnChgItElmPurItm.TranspChargeItemElementUUID AS TranspChargeItemElementUUID,
  P_SupFrtInReqTrnChgItElmPurItm.mandt AS mandt,
  P_SupFrtInReqTrnChgItElmPurItm.TransportationChargesObjUUID AS TransportationChargesObjUUID,
  P_SupFrtInReqTrnChgItElmPurItm.SuplrFrtInvcReqUUID AS SuplrFrtInvcReqUUID,
  P_SupFrtInReqTrnChgItElmPurItm.TranspChargeCalcReslnBase AS TranspChargeCalcReslnBase,
  P_SupFrtInReqTrnChgItElmPurItm.TranspChrgItmElmntResBaseKey AS TranspChrgItmElmntResBaseKey,
  P_SupFrtInReqTrnChgItElmPurItm.PurgDocExternalReference AS PurgDocExternalReference,
  P_SupFrtInReqTrnChgItElmPurItm.SupplierFreightInvoiceRequest AS SupplierFreightInvoiceRequest,
  P_SupFrtInReqTrnChgItElmPurItm.Carrier AS Carrier,
  P_SupFrtInReqTrnChgItElmPurItm.TranspOrdLogicalSystem AS TranspOrdLogicalSystem,
  P_SupFrtInReqTrnChgItElmPurItm.TranspOrdInvoicingParty AS TranspOrdInvoicingParty,
  P_SupFrtInReqTrnChgItElmPurItm.PurchaseOrder AS PurchaseOrder,
  P_SupFrtInReqTrnChgItElmPurItm.PurchaseOrderItem AS PurchaseOrderItem,
  00 AS SDM_STATUS
FROM P_SupFrtInReqTrnChgItElmPurItm
;

Learn More