I_OutboundDeliveryTP

DDL: I_OUTBOUNDDELIVERYTP Type: view_entity TRANSACTIONAL

Outbound Delivery - TP

I_OutboundDeliveryTP is a Transactional CDS View that provides data about "Outbound Delivery - TP" in SAP S/4HANA. It reads from 1 data source (R_OutboundDeliveryTP) and exposes 101 fields with key field OutboundDelivery.

Data Sources (1)

SourceAliasJoin Type
R_OutboundDeliveryTP R_OutboundDeliveryTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Outbound Delivery - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name OutboundDelivery view
ObjectModel.representativeKey OutboundDelivery view
Metadata.ignorePropagatedAnnotations true view

Fields (101)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery OutboundDelivery LE Delivery
ShipToParty ShipToParty Ship-To Party (obsolete)
SoldToParty SoldToParty Sold-to Party
Supplier Supplier Supplier
ReceivingPlant ReceivingPlant Receiving Plant
CustomerGroup CustomerGroup Customer Group
Warehouse Warehouse Warehouse No.
WarehouseGate WarehouseGate
WarehouseStagingArea WarehouseStagingArea
HandlingUnitInStock HandlingUnitInStock
TotalNumberOfPackage TotalNumberOfPackage
RouteSchedule RouteSchedule Route Schedule
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
BillOfLading BillOfLading
GoodsMovementSlipNumber GoodsMovementSlipNumber
TransportationGroup TransportationGroup Trans. Group
ShipmentBlockReason ShipmentBlockReason
ShippingCondition ShippingCondition Shipping Conditions
ShippingType ShippingType Shipping Type
SpecialProcessingCode SpecialProcessingCode
MeansOfTransport MeansOfTransport
MeansOfTransportType MeansOfTransportType
MeansOfTransportRefMaterial MeansOfTransportRefMaterial
ExternalTransportSystem ExternalTransportSystem
FactoryCalendarByCustomer FactoryCalendarByCustomer
HeaderGrossWeight HeaderGrossWeight
HeaderNetWeight HeaderNetWeight
HeaderWeightUnit HeaderWeightUnit
HeaderVolume HeaderVolume
HeaderVolumeUnit HeaderVolumeUnit
IsExportDelivery IsExportDelivery
HeaderBillingBlockReason HeaderBillingBlockReason Billing Block
InternalFinancialDocument InternalFinancialDocument
DepreciationInPercent DepreciationInPercent
PaymentGuaranteeProcedure PaymentGuaranteeProcedure
TransactionCurrency TransactionCurrency Transaction Currency
StatisticsCurrency StatisticsCurrency
DeliveryDocumentBySupplier DeliveryDocumentBySupplier
ExternalIdentificationType ExternalIdentificationType
ShippingPoint ShippingPoint Shipping Point
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesDistrict SalesDistrict Sales District
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
DeliveryVersion DeliveryVersion
DeliveryPriority DeliveryPriority Delivery Prior.
DeliveryBlockReason DeliveryBlockReason Delivery Block
DeliveryDocumentType DeliveryDocumentType Delivery Type
SDDocumentCategory SDDocumentCategory Document Cat.
CompleteDeliveryIsDefined CompleteDeliveryIsDefined Complete Dlv.
OrderCombinationIsAllowed OrderCombinationIsAllowed Order Combinat.
DocumentDate DocumentDate Journal Entry Date
PickDate PickDate
PickTime PickTime
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
TransportationPlanningTime TransportationPlanningTime Tr. Plan. Time
LoadingDate LoadingDate Loading Date
LoadingTime LoadingTime Loading Time
PlannedGoodsMovementDate PlannedGoodsMovementDate
PlannedGoodsMovementTime PlannedGoodsMovementTime
DeliveryDate DeliveryDate Delivery Date
DeliveryTime DeliveryTime TimeOfDelivery
BillingDocumentDate BillingDocumentDate Billing Date
IntercompanyBillingDate IntercompanyBillingDate
ActualGoodsMovementDate ActualGoodsMovementDate
ActualGoodsMovementTime ActualGoodsMovementTime
ProofOfDeliveryDate ProofOfDeliveryDate
ProofOfDeliveryTime ProofOfDeliveryTime
ShippingLocationTimeZone ShippingLocationTimeZone
ReceivingLocationTimeZone ReceivingLocationTimeZone
OverallPickStatus OverallPickStatus
OverallWarehouseActivityStatus OverallWarehouseActivityStatus
OverallPickConfStatus OverallPickConfStatus
OverallPackingStatus OverallPackingStatus
OverallGoodsMovementStatus OverallGoodsMovementStatus
OverallDelivReltdBillgStatus OverallDelivReltdBillgStatus
TransportationPlanningStatus TransportationPlanningStatus
DistrStatusByDecentralizedWrhs DistrStatusByDecentralizedWrhs
OverallProofOfDeliveryStatus OverallProofOfDeliveryStatus
OverallIntcoBillingStatus OverallIntcoBillingStatus
TotalCreditCheckStatus TotalCreditCheckStatus
OverallDeliveryProcessStatus OverallDeliveryProcessStatus
TotalBlockStatus TotalBlockStatus
OverallDelivConfStatus OverallDelivConfStatus
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus
HeaderDelivIncompletionStatus HeaderDelivIncompletionStatus
HeaderPickIncompletionStatus HeaderPickIncompletionStatus
HeaderPackingIncompletionSts HeaderPackingIncompletionSts
HdrGoodsMvtIncompletionStatus HdrGoodsMvtIncompletionStatus
HeaderBillgIncompletionStatus HeaderBillgIncompletionStatus
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts
OvrlItmPackingIncompletionSts OvrlItmPackingIncompletionSts
OvrlItmPickIncompletionSts OvrlItmPickIncompletionSts
OvrlItmDelivIncompletionSts OvrlItmDelivIncompletionSts
OvrlItmGdsMvtIncompletionSts OvrlItmGdsMvtIncompletionSts
DeliveryIsInPlant DeliveryIsInPlant

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_OutboundDeliveryTP.
-- 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_OutboundDeliveryTP AS
SELECT
  OutboundDelivery,
  ShipToParty,
  SoldToParty,
  Supplier,
  ReceivingPlant,
  CustomerGroup,
  Warehouse,
  WarehouseGate,
  WarehouseStagingArea,
  HandlingUnitInStock,
  TotalNumberOfPackage,
  RouteSchedule,
  IncotermsClassification,
  IncotermsTransferLocation,
  BillOfLading,
  GoodsMovementSlipNumber,
  TransportationGroup,
  ShipmentBlockReason,
  ShippingCondition,
  ShippingType,
  SpecialProcessingCode,
  MeansOfTransport,
  MeansOfTransportType,
  MeansOfTransportRefMaterial,
  ExternalTransportSystem,
  FactoryCalendarByCustomer,
  HeaderGrossWeight,
  HeaderNetWeight,
  HeaderWeightUnit,
  HeaderVolume,
  HeaderVolumeUnit,
  IsExportDelivery,
  HeaderBillingBlockReason,
  InternalFinancialDocument,
  DepreciationInPercent,
  PaymentGuaranteeProcedure,
  TransactionCurrency,
  StatisticsCurrency,
  DeliveryDocumentBySupplier,
  ExternalIdentificationType,
  ShippingPoint,
  SalesOrganization,
  SalesOffice,
  SalesDistrict,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  DeliveryVersion,
  DeliveryPriority,
  DeliveryBlockReason,
  DeliveryDocumentType,
  SDDocumentCategory,
  CompleteDeliveryIsDefined,
  OrderCombinationIsAllowed,
  DocumentDate,
  PickDate,
  PickTime,
  TransportationPlanningDate,
  TransportationPlanningTime,
  LoadingDate,
  LoadingTime,
  PlannedGoodsMovementDate,
  PlannedGoodsMovementTime,
  DeliveryDate,
  DeliveryTime,
  BillingDocumentDate,
  IntercompanyBillingDate,
  ActualGoodsMovementDate,
  ActualGoodsMovementTime,
  ProofOfDeliveryDate,
  ProofOfDeliveryTime,
  ShippingLocationTimeZone,
  ReceivingLocationTimeZone,
  OverallPickStatus,
  OverallWarehouseActivityStatus,
  OverallPickConfStatus,
  OverallPackingStatus,
  OverallGoodsMovementStatus,
  OverallDelivReltdBillgStatus,
  TransportationPlanningStatus,
  DistrStatusByDecentralizedWrhs,
  OverallProofOfDeliveryStatus,
  OverallIntcoBillingStatus,
  TotalCreditCheckStatus,
  OverallDeliveryProcessStatus,
  TotalBlockStatus,
  OverallDelivConfStatus,
  HdrGeneralIncompletionStatus,
  HeaderDelivIncompletionStatus,
  HeaderPickIncompletionStatus,
  HeaderPackingIncompletionSts,
  HdrGoodsMvtIncompletionStatus,
  HeaderBillgIncompletionStatus,
  OvrlItmGeneralIncompletionSts,
  OvrlItmPackingIncompletionSts,
  OvrlItmPickIncompletionSts,
  OvrlItmDelivIncompletionSts,
  OvrlItmGdsMvtIncompletionSts,
  DeliveryIsInPlant
FROM R_OutboundDeliveryTP
;