R_SlsOrdWithoutChrgSchedLineTP

DDL: R_SLSORDWITHOUTCHRGSCHEDLINETP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_SOWC
32 Fields 1 Data Sources 1 Associations

Sls Ord Without Chrg Schedule Line - TP

R_SlsOrdWithoutChrgSchedLineTP is a Transactional CDS View that provides data about "Sls Ord Without Chrg Schedule Line - TP" in SAP S/4HANA. It reads from 1 data source (I_SlsOrdWthoutChrgSchedLine) and exposes 32 fields with key fields SalesOrderWithoutCharge, SalesOrderWithoutChargeItem, ScheduleLine. It has 1 association to related views. Part of development package RAP_SD_SLS_SOWC.

Data Sources (1)

SourceAliasJoin Type
I_SlsOrdWthoutChrgSchedLine SlsOrdWithoutChrgScheduleLine from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SalesOrderWithoutChargeTP _SalesOrderWithoutCharge $projection.SalesOrderWithoutCharge = _SalesOrderWithoutCharge.SalesOrderWithoutCharge

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Sls Ord Without Chrg Schedule Line - TP view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderWithoutCharge I_SlsOrdWthoutChrgSchedLine SalesOrderWithoutCharge
KEY SalesOrderWithoutChargeItem I_SlsOrdWthoutChrgSchedLine SalesOrderWithoutChargeItem
KEY ScheduleLine I_SlsOrdWthoutChrgSchedLine ScheduleLine Schedule Line
ScheduleLineForEdit I_SlsOrdWthoutChrgSchedLine ScheduleLine Schedule Line
ScheduleLineCategory I_SlsOrdWthoutChrgSchedLine ScheduleLineCategory Sched.Line Cat.
OrderQuantityUnit OrderQuantityUnit Sales Unit
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit
OpenConfdDelivQtyInOrdQtyUnit OpenConfdDelivQtyInOrdQtyUnit
CorrectedQtyInOrderQtyUnit CorrectedQtyInOrderQtyUnit
DeliveryDate DeliveryDate Delivery Date
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
ConfirmedDeliveryDate ConfirmedDeliveryDate Confirmed Delivery Date
ProductAvailabilityDate ProductAvailabilityDate Mat.Avail.Date
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
GoodsIssueDate GoodsIssueDate Goods Issue Date CCD
LoadingDate LoadingDate Loading Date
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine Delivery Block
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
GoodsMovementType I_SlsOrdWthoutChrgSchedLine GoodsMovementType Movement Type
_Item _Item
_SalesOrderWithoutCharge _SalesOrderWithoutCharge
SalesOrderWithoutChargeType _SalesOrderWithoutCharge SalesOrderWithoutChargeType
OrganizationDivision _SalesOrderWithoutCharge OrganizationDivision Org. Division
SalesOrganization _SalesOrderWithoutCharge SalesOrganization Sales Organization
DistributionChannel _SalesOrderWithoutCharge DistributionChannel RefDistCh-Cust/Mat.
_OrderQuantityUnit I_SlsOrdWthoutChrgSchedLine _OrderQuantityUnit
_DelivBlockReasonForSchedLine I_SlsOrdWthoutChrgSchedLine _DelivBlockReasonForSchedLine
_ScheduleLineCategory I_SlsOrdWthoutChrgSchedLine _ScheduleLineCategory
_GoodsMovementType I_SlsOrdWthoutChrgSchedLine _GoodsMovementType

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 R_SlsOrdWithoutChrgSchedLineTP.
-- 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 R_SlsOrdWithoutChrgSchedLineTP AS
SELECT
  SlsOrdWithoutChrgScheduleLine.SalesOrderWithoutCharge AS SalesOrderWithoutCharge,
  SlsOrdWithoutChrgScheduleLine.SalesOrderWithoutChargeItem AS SalesOrderWithoutChargeItem,
  SlsOrdWithoutChrgScheduleLine.ScheduleLine AS ScheduleLine,
  SlsOrdWithoutChrgScheduleLine.ScheduleLine AS ScheduleLineForEdit,
  SlsOrdWithoutChrgScheduleLine.ScheduleLineCategory AS ScheduleLineCategory,
  OrderQuantityUnit,
  ScheduleLineOrderQuantity,
  ConfdOrderQtyByMatlAvailCheck,
  DeliveredQtyInOrderQtyUnit,
  OpenConfdDelivQtyInOrdQtyUnit,
  CorrectedQtyInOrderQtyUnit,
  DeliveryDate,
  RequestedDeliveryDate,
  ConfirmedDeliveryDate,
  ProductAvailabilityDate,
  TransportationPlanningDate,
  GoodsIssueDate,
  LoadingDate,
  DelivBlockReasonForSchedLine,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SlsOrdWithoutChrgScheduleLine.GoodsMovementType AS GoodsMovementType,
  _SalesOrderWithoutCharge.SalesOrderWithoutChargeType AS SalesOrderWithoutChargeType,
  _SalesOrderWithoutCharge.OrganizationDivision AS OrganizationDivision,
  _SalesOrderWithoutCharge.SalesOrganization AS SalesOrganization,
  _SalesOrderWithoutCharge.DistributionChannel AS DistributionChannel,
  SlsOrdWithoutChrgScheduleLine._OrderQuantityUnit AS _OrderQuantityUnit,
  SlsOrdWithoutChrgScheduleLine._DelivBlockReasonForSchedLine AS _DelivBlockReasonForSchedLine,
  SlsOrdWithoutChrgScheduleLine._ScheduleLineCategory AS _ScheduleLineCategory,
  SlsOrdWithoutChrgScheduleLine._GoodsMovementType AS _GoodsMovementType
FROM I_SlsOrdWthoutChrgSchedLine AS SlsOrdWithoutChrgScheduleLine
LEFT OUTER JOIN R_SalesOrderWithoutChargeTP AS _SalesOrderWithoutCharge ON SalesOrderWithoutCharge = _SalesOrderWithoutCharge.SalesOrderWithoutCharge  -- association [1..1]
;

Learn More