P_Tbat_Basis_DeliveryPeriods

DDL: P_TBAT_BASIS_DELIVERYPERIODS SQL: PTBATBDLVPER Type: view BASIC Package: LOG_CMM_RUNTIME_VALUATION
15 Fields 2 Data Sources

Provides the per delivery period the most current record

P_Tbat_Basis_DeliveryPeriods is a Basic CDS View that provides data about "Provides the per delivery period the most current record" in SAP S/4HANA. It reads from 2 data sources (P_Tbat_Basis_Quot_Max, tbact_bas_quot) and exposes 15 fields with key fields basis_type, basis_id, dcsid, mic, delivery_to. Part of development package LOG_CMM_RUNTIME_VALUATION.

Data Sources (2)

SourceAliasJoin Type
P_Tbat_Basis_Quot_Max bas_quot_current from
tbact_bas_quot bas_quot_single inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PTBATBDLVPER view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MASTER view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY basis_type P_Tbat_Basis_Quot_Max basis_type Basis Type
KEY basis_id P_Tbat_Basis_Quot_Max basis_id Strategy
KEY dcsid P_Tbat_Basis_Quot_Max dcsid DCSID
KEY mic P_Tbat_Basis_Quot_Max mic MIC
KEY delivery_to P_Tbat_Basis_Quot_Max delivery_to Delivery End Date
KEY pricetype P_Tbat_Basis_Quot_Max pricetype Price Type
KEY pricedate P_Tbat_Basis_Quot_Max pricedate Price Date
KEY pricetime P_Tbat_Basis_Quot_Max pricetime Price Time
KEY validfrom P_Tbat_Basis_Quot_Max validfrom Vers.Valid From
keydate tbact_bas_quot keydate Maturity Key Date
price tbact_bas_quot price RVP f.PricePro.
uom tbact_bas_quot uom UoM: Conv. to
currency tbact_bas_quot currency Valuation Crcy
createdby tbact_bas_quot createdby User Name
deletion_ind tbact_bas_quot deletion_ind Quotation Deleted

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_Tbat_Basis_DeliveryPeriods.
-- 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: PTBATBDLVPER

CREATE VIEW P_Tbat_Basis_DeliveryPeriods AS
SELECT
  bas_quot_current.basis_type AS basis_type,
  bas_quot_current.basis_id AS basis_id,
  bas_quot_current.dcsid AS dcsid,
  bas_quot_current.mic AS mic,
  bas_quot_current.delivery_to AS delivery_to,
  bas_quot_current.pricetype AS pricetype,
  bas_quot_current.pricedate AS pricedate,
  bas_quot_current.pricetime AS pricetime,
  bas_quot_current.validfrom AS validfrom,
  bas_quot_single.keydate AS keydate,
  bas_quot_single.price AS price,
  bas_quot_single.uom AS uom,
  bas_quot_single.currency AS currency,
  bas_quot_single.createdby AS createdby,
  bas_quot_single.deletion_ind AS deletion_ind
FROM P_Tbat_Basis_Quot_Max AS bas_quot_current
INNER JOIN tbact_bas_quot AS bas_quot_single ON /* join condition not captured in parsed metadata */
;

Learn More