P_SupFrtInReqTranspChrgItmElm

DDL: P_SUPFRTINREQTRANSPCHRGITMELM SQL: PSFTCELE Type: view BASIC Package: VDM_TM_STLMNT_MIGR
6 Fields 1 Data Sources

SFIR Transportation Charge Elements

P_SupFrtInReqTranspChrgItmElm is a Basic CDS View that provides data about "SFIR Transportation Charge Elements" in SAP S/4HANA. It reads from 1 data source (/scmtms/d_tchrge) and exposes 6 fields with key field TranspChargeItemElementUUID. Part of development package VDM_TM_STLMNT_MIGR.

Data Sources (1)

SourceAliasJoin Type
/scmtms/d_tchrge _TranspChargeItemElement from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSFTCELE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 (6)

KeyFieldSource TableSource FieldDescription
KEY TranspChargeItemElementUUID db_key UUID
mandt mandt Editing Client
TransportationChargesObjUUID root_key UUID
SuplrFrtInvcReqUUID _TranspChargeObject host_key UUID
TranspChargeCalcReslnBase clcresbas036 Calc. Res. Base
TranspChrgItmElmntResBaseKey node_idrb NodeID

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_SupFrtInReqTranspChrgItmElm.
-- 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: PSFTCELE

CREATE VIEW P_SupFrtInReqTranspChrgItmElm AS
SELECT
  db_key AS TranspChargeItemElementUUID,
  mandt,
  root_key AS TransportationChargesObjUUID,
  _TranspChargeObject.host_key AS SuplrFrtInvcReqUUID,
  clcresbas036 AS TranspChargeCalcReslnBase,
  node_idrb AS TranspChrgItmElmntResBaseKey
FROM /scmtms/d_tchrge AS _TranspChargeItemElement
;

Learn More