I_InboundDeliveryTP

DDL: I_INBOUNDDELIVERYTP Type: view_entity TRANSACTIONAL

Inbound Delivery - TP

I_InboundDeliveryTP is a Transactional CDS View that provides data about "Inbound Delivery - TP" in SAP S/4HANA. It reads from 1 data source (R_InboundDeliveryTP) and exposes 94 fields with key field InboundDelivery.

Data Sources (1)

SourceAliasJoin Type
R_InboundDeliveryTP R_InboundDeliveryTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Inbound 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 InboundDelivery view
ObjectModel.representativeKey InboundDelivery view
Metadata.ignorePropagatedAnnotations true view

Fields (94)

KeyFieldSource TableSource FieldDescription
KEY InboundDelivery InboundDelivery LE Delivery
SDDocumentCategory SDDocumentCategory Document Cat.
DeliveryDocumentType DeliveryDocumentType Delivery Type
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
GoodsReceivingPoint GoodsReceivingPoint Goods Rcvg Point
CompleteDeliveryIsDefined CompleteDeliveryIsDefined Complete Dlv.
DeliveryPriority DeliveryPriority Delivery Prior.
DeliveryBlockReason DeliveryBlockReason Delivery Block
DeliveryDocumentBySupplier DeliveryDocumentBySupplier
DeliveryIsInPlant DeliveryIsInPlant
DeliveryVersion DeliveryVersion
DocumentDate DocumentDate Journal Entry Date
ExternalIdentificationType ExternalIdentificationType
GoodsMovementSlipNumber GoodsMovementSlipNumber
HeaderGrossWeight HeaderGrossWeight
HeaderNetWeight HeaderNetWeight
HeaderVolume HeaderVolume
HeaderVolumeUnit HeaderVolumeUnit
HeaderWeightUnit HeaderWeightUnit
IsExportDelivery IsExportDelivery
MeansOfTransportRefMaterial MeansOfTransportRefMaterial
OrderCombinationIsAllowed OrderCombinationIsAllowed Order Combinat.
ReceivingPlant ReceivingPlant Receiving Plant
SpecialProcessingCode SpecialProcessingCode
Supplier Supplier Supplier
Warehouse Warehouse Warehouse No.
WarehouseGate WarehouseGate
WarehouseStagingArea WarehouseStagingArea
TotalNumberOfPackage TotalNumberOfPackage
LoadingDate LoadingDate Loading Date
LoadingTime LoadingTime Loading Time
BillOfLading BillOfLading
HandlingUnitInStock HandlingUnitInStock
DeliveryDate DeliveryDate Delivery Date
DeliveryTime DeliveryTime TimeOfDelivery
ShippingCondition ShippingCondition Shipping Conditions
ShippingType ShippingType Shipping Type
ShipmentBlockReason ShipmentBlockReason
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
TransportationPlanningTime TransportationPlanningTime Tr. Plan. Time
RouteSchedule RouteSchedule Route Schedule
PlannedGoodsMovementDate PlannedGoodsMovementDate
PlannedGoodsMovementTime PlannedGoodsMovementTime
ActualGoodsMovementDate ActualGoodsMovementDate
ActualGoodsMovementTime ActualGoodsMovementTime
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
ExternalTransportSystem ExternalTransportSystem
TransportationGroup TransportationGroup Trans. Group
MeansOfTransport MeansOfTransport
MeansOfTransportType MeansOfTransportType
ProofOfDeliveryDate ProofOfDeliveryDate
ProofOfDeliveryTime ProofOfDeliveryTime
FactoryCalendarByCustomer FactoryCalendarByCustomer
ShippingLocationTimeZone ShippingLocationTimeZone
ReceivingLocationTimeZone ReceivingLocationTimeZone
IntercompanyBillingDate IntercompanyBillingDate
BillingDocumentDate BillingDocumentDate Billing Date
HeaderBillingBlockReason HeaderBillingBlockReason Billing Block
InternalFinancialDocument InternalFinancialDocument
PaymentGuaranteeProcedure PaymentGuaranteeProcedure
DepreciationInPercent DepreciationInPercent
CustomerGroup CustomerGroup Customer Group
TransactionCurrency TransactionCurrency Transaction Currency
StatisticsCurrency StatisticsCurrency
OverallIntcoBillingStatus OverallIntcoBillingStatus
OverallDeliveryProcessStatus OverallDeliveryProcessStatus
TotalBlockStatus TotalBlockStatus
OverallDelivConfStatus OverallDelivConfStatus
TransportationPlanningStatus TransportationPlanningStatus
OverallPutawayConfStatus OverallPutawayConfStatus
OverallPutawayStatus OverallPutawayStatus
OverallPackingStatus OverallPackingStatus
OverallWarehouseActivityStatus OverallWarehouseActivityStatus
DistrStatusByDecentralizedWrhs DistrStatusByDecentralizedWrhs
OverallGoodsMovementStatus OverallGoodsMovementStatus
OverallDelivReltdBillgStatus OverallDelivReltdBillgStatus
OverallProofOfDeliveryStatus OverallProofOfDeliveryStatus
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus
HeaderDelivIncompletionStatus HeaderDelivIncompletionStatus
HeaderPutawayIncompltnStatus HeaderPutawayIncompltnStatus
HeaderPackingIncompletionSts HeaderPackingIncompletionSts
HdrGoodsMvtIncompletionStatus HdrGoodsMvtIncompletionStatus
HeaderBillgIncompletionStatus HeaderBillgIncompletionStatus
OvrlItmDelivIncompletionSts OvrlItmDelivIncompletionSts
OvrlItmGdsMvtIncompletionSts OvrlItmGdsMvtIncompletionSts
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts
OvrlItmPackingIncompletionSts OvrlItmPackingIncompletionSts
OvrlItmPutawayIncompletionSts OvrlItmPutawayIncompletionSts
TotalCreditCheckStatus TotalCreditCheckStatus

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