I_TrdgContrScheduleLine

DDL: I_TRDGCONTRSCHEDULELINE Type: view_entity COMPOSITE
21 Fields 1 Data Sources 3 Associations

Trading Contract Schedule Line

I_TrdgContrScheduleLine (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

I_TrdgContrScheduleLine is a Composite CDS View that provides data about "Trading Contract Schedule Line" in SAP S/4HANA. It reads from 1 data source (R_TrdgContrScheduleLine) and exposes 21 fields with key fields TradingContract, TradingContractItem, TradingContractScheduleLine. It has 3 associations to related views.

SAP Help Documentation

CategoryGlobal Trade Management
Purpose
This CDS view contains information about the schedule line data of a trading contract on item level. This CDS view provides the data to answer the following business questions: What are the schedule lines for the given trading contract item? What are the delivered and ordered quantities of the trading contract item? What is the delivery date and what is the ordered date? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: W_WBHK_TCT (Trading Contract: Authorization for Trading Contract Type) W_WBHK_ORG (Trading Contract: Authorization for Organizational Data) V_KNA1_BRG (Customer: Account Authorization for Sales Areas) F_LFA1_BEK (Vendor: Account Authorization)

Structure
Fields Used for Filtering The main filters are as follows: TradingContract : This field is used to filter for the number of the trading contract. TradingContractItem : This field is used to filter for the number of a trading contract item. TradingContractScheduleLine : This field is used to filter for the schedule line number in a trading contract.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-GT
CapabilitiesData Source for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view contains information about the schedule line data of a trading contract on item level.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the schedule lines for the given trading contract item?</p></li> <li><p>What are the delivered and ordered quantities of the trading contract item?</p></li> <li><p>What is the delivery date and what is the ordered date?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_TrdgContrScheduleLine TrdgContrScheduleLine from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_TrdgContr _TrdgContr $projection.TradingContract = _TrdgContr.TradingContract
[1..1] I_TrdgContrItem _TrdgContrItem $projection.TradingContract = _TrdgContrItem.TradingContract and $projection.TradingContractItem = _TrdgContrItem.TradingContractItem
[0..1] E_TradingDocumentScheduleLine _TradingDocumentScheduleLine $projection.TradingContract = _TradingDocumentScheduleLine.TradingDocument and $projection.TradingContractItem = _TradingDocumentScheduleLine.TradingDocumentItem and $projection.TradingContractScheduleLine = _TradingDocumentScheduleLine.TradingDocumentScheduleLine

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Trading Contract Schedule Line view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.representativeKey TradingContractScheduleLine view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY TradingContract TradingContract Trading Contract
KEY TradingContractItem TradingContractItem Item Number of Trading Contract
KEY TradingContractScheduleLine TradingContractScheduleLine Schedule Line Number in Trading Contract
CreatedByUser R_TrdgContrScheduleLine CreatedByUser Name of Person Responsible for Creating the Object
CreationDate CreationDate Record Created On
CreationTime CreationTime Time of Change
TrdgContrSalesQuantity TrdgContrSalesQuantity Cumulative Order Quantity in Sales Units
TrdgContrSlsQuantityUnit TrdgContrSlsQuantityUnit Sales Unit
TrdgContrPurgQuantity TrdgContrPurgQuantity Quantity ordered against this purchase requisition
TrdgContrPurgQuantityUnit TrdgContrPurgQuantityUnit Purchase Order Unit of Measure
TrdgContrSlsSchedLineDelivDte TrdgContrSlsSchedLineDelivDte Sales Schedule Line Delivery Date
TrdgContrPurgSchedLineDelivDte TrdgContrPurgSchedLineDelivDte Purchasing Schedule line delivery date
TrdgContrSlsDelivDteCat TrdgContrSlsDelivDteCat Sales Delivery Date Category
TrdgContrPurgDelivDteCat TrdgContrPurgDelivDteCat Purchasing Delivery Date Category
TrdgContrSlsReqdDelivTme TrdgContrSlsReqdDelivTme Sales Requested Delivery Time
TrdgContrPurgReqdDelivTme TrdgContrPurgReqdDelivTme Purchasing Requested Delivery Time
TrdgContrInbLglCtrlChkSts TrdgContrInbLglCtrlChkSts Legal Control Check Status (Inbound)
TrdgContrOutbLglCtrlChkSts TrdgContrOutbLglCtrlChkSts Legal Control Check Status (Outbound)
_TrdgContr _TrdgContr
_TrdgContrItem _TrdgContrItem
_CreatedByUser _CreatedByUser

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_TrdgContrScheduleLine.
-- 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 I_TrdgContrScheduleLine AS
SELECT
  TradingContract,
  TradingContractItem,
  TradingContractScheduleLine,
  TrdgContrScheduleLine.CreatedByUser AS CreatedByUser,
  CreationDate,
  CreationTime,
  TrdgContrSalesQuantity,
  TrdgContrSlsQuantityUnit,
  TrdgContrPurgQuantity,
  TrdgContrPurgQuantityUnit,
  TrdgContrSlsSchedLineDelivDte,
  TrdgContrPurgSchedLineDelivDte,
  TrdgContrSlsDelivDteCat,
  TrdgContrPurgDelivDteCat,
  TrdgContrSlsReqdDelivTme,
  TrdgContrPurgReqdDelivTme,
  TrdgContrInbLglCtrlChkSts,
  TrdgContrOutbLglCtrlChkSts
FROM R_TrdgContrScheduleLine AS TrdgContrScheduleLine
LEFT OUTER JOIN I_TrdgContr AS _TrdgContr ON TradingContract = _TrdgContr.TradingContract  -- association [1..1]
LEFT OUTER JOIN I_TrdgContrItem AS _TrdgContrItem ON TradingContract = _TrdgContrItem.TradingContract AND TradingContractItem = _TrdgContrItem.TradingContractItem  -- association [1..1]
LEFT OUTER JOIN E_TradingDocumentScheduleLine AS _TradingDocumentScheduleLine ON TradingContract = _TradingDocumentScheduleLine.TradingDocument AND TradingContractItem = _TradingDocumentScheduleLine.TradingDocumentItem AND TradingContractScheduleLine = _TradingDocumentScheduleLine.TradingDocumentScheduleLine  -- association [0..1]
;

Learn More