I_DeliveryDocument

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_DeliveryDocument.
-- 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_DeliveryDocument AS
SELECT
  vbeln AS DeliveryDocument,
  vbtyp AS SDDocumentCategory,
  lfart AS DeliveryDocumentType,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  erzet AS CreationTime,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  vstel AS ShippingPoint,
  vkorg AS SalesOrganization,
  vkbur AS SalesOffice,
  autlf AS CompleteDeliveryIsDefined,
  kzazu AS OrderCombinationIsAllowed,
  lprio AS DeliveryPriority,
  lifsk AS DeliveryBlockReason,
  cast(lifnr as md_supplier) AS Supplier,
  lifex AS DeliveryDocumentBySupplier,
  imwrk AS DeliveryIsInPlant,
  werks AS ReceivingPlant,
  lgnum AS Warehouse,
  expkz AS IsExportDelivery,
  ternr AS OrderID,
  btgew AS HeaderGrossWeight,
  ntgew AS HeaderNetWeight,
  gewei AS HeaderWeightUnit,
  volum AS HeaderVolume,
  voleh AS HeaderVolumeUnit,
  lispl AS IsDeliveryForSingleWarehouse,
  xabln AS GoodsIssueOrReceiptSlipNumber,
  lgtor AS WarehouseGate,
  lgbzo AS WarehouseStagingArea,
  trmtyp AS MeansOfTransportRefMaterial,
  sdabw AS SpecialProcessingCode,
  spe_lifex_type AS ExternalIdentificationType,
  dlv_version AS DeliveryVersion,
  berot AS PickedItemsLocation,
  bldat AS DocumentDate,
  comp_grp AS DelivCompGrpSts,
  kodat AS PickingDate,
  kouhr AS PickingTime,
  anzpk AS TotalNumberOfPackage,
  lstel AS LoadingPoint,
  lddat AS LoadingDate,
  lduhr AS LoadingTime,
  bolnr AS BillOfLading,
  vestk AS HandlingUnitInStock,
  kunnr AS ShipToParty,
  vsart AS ShippingType,
  lfdat AS DeliveryDate,
  lfuhr AS DeliveryTime,
  vsbed AS ShippingCondition,
  trspg AS ShipmentBlockReason,
  tddat AS TransportationPlanningDate,
  tduhr AS TransportationPlanningTime,
  route AS ProposedDeliveryRoute,
  routa AS ActualDeliveryRoute,
  aulwe AS RouteSchedule,
  wadat AS PlannedGoodsIssueDate,
  wauhr AS GoodsIssueTime,
  wadat_ist AS ActualGoodsMovementDate,
  spe_wauhr_ist AS ActualGoodsMovementTime,
  inco1 AS IncotermsClassification,
  inco2 AS IncotermsTransferLocation,
  tpsid AS ExternalTransportSystem,
  tragr AS TransportationGroup,
  traid AS MeansOfTransport,
  traty AS MeansOfTransportType,
  ablad AS UnloadingPointName,
  podat AS ProofOfDeliveryDate,
  potim AS ConfirmationTime,
  knfak AS FactoryCalendarByCustomer,
  tzonis AS ShippingLocationTimeZone,
  tzonrc AS ReceivingLocationTimeZone,
  fkdiv AS IntercompanyBillingDate,
  fkdat AS BillingDocumentDate,
  faksk AS HeaderBillingBlockReason,
  lcnum AS InternalFinancialDocument,
  abssc AS PaymentGuaranteeProcedure,
  akprz AS DepreciationPercentage,
  cmngv AS NextShippingDate,
  knkli AS CustomerCreditAccount,
  cmps_te AS CentralCreditChkTechErrSts,
  amtbl AS ReleasedCreditAmount,
  cmwae AS ControllingAreaCurrency,
  cmfre AS CreditBlockReleaseDate,
  kunag AS SoldToParty,
  kdgrp AS CustomerGroup,
  bzirk AS SalesDistrict,
  waerk AS TransactionCurrency,
  stwae AS StatisticsCurrency,
  gbstk AS OverallSDProcessStatus,
  spstg AS TotalBlockStatus,
  bestk AS OverallDelivConfStatus,
  trsta AS TransportationPlanningStatus,
  koquk AS OverallPickingConfStatus,
  kostk AS OverallPickingStatus,
  pkstk AS OverallPackingStatus,
  lvstk AS OverallWarehouseActivityStatus,
  vlstk AS DistrStatusByDecentralizedWrhs,
  wbstk AS OverallGoodsMovementStatus,
  fkstk AS OverallDelivReltdBillgStatus,
  pdstk AS OverallProofOfDeliveryStatus,
  uvall AS HdrGeneralIncompletionStatus,
  uvvlk AS HeaderDelivIncompletionStatus,
  uvpik AS HeaderPickgIncompletionStatus,
  uvpak AS HeaderPackingIncompletionSts,
  uvwak AS HdrGoodsMvtIncompletionStatus,
  uvfak AS HeaderBillgIncompletionStatus,
  uvals AS OvrlItmGeneralIncompletionSts,
  uvpas AS OvrlItmPackingIncompletionSts,
  uvpis AS OvrlItmPickingIncompletionSts,
  uvvls AS OvrlItmDelivIncompletionSts,
  uvwas AS OvrlItmGdsMvtIncompletionSts,
  cmgst AS TotalCreditCheckStatus,
  cmpsc AS MaxDocValueCreditCheckStatus,
  cmpsd AS PaymentTermCreditCheckStatus,
  knumv AS PricingDocument,
  vkoiv AS SalesOrgForIntcoBilling,
  vtwiv AS DistrChnlForIntcoBilling,
  spaiv AS DivisionForIntcoBilling,
  fkaiv AS IntercompanyBillingType,
  pioiv AS FactoryCalendarForIntcoBilling,
  kuniv AS IntercompanyBillingCustomer,
  knump AS DeliveryDocumentCondition,
  netwr AS TotalNetAmount,
  xblnr AS ReferenceDocumentNumber,
  spe_loekz AS DeletionIndicator,
  total_pcsta AS OverallChmlCmplncStatus,
  total_dgsta AS OverallDangerousGoodsStatus,
  total_sdssta AS OverallSafetyDataSheetStatus,
  total_emcst AS OverallTrdCmplncEmbargoSts,
  total_slcst AS OvrlTrdCmplncSnctndListChkSts,
  total_lccst AS OvrlTrdCmplncLegalCtrlChkSts,
  klief AS IsCorrectionDelivery,
  tm_whse_exec AS ReadyForWarehouseExecStatus,
  tm_adv_ship_recv AS DelivAdvncdShipgRcvgRlvnce,
  corr_ind AS DelivIsQtyCrrtnAdvncShipgRcvg,
  total_arc_status AS EU_DeliveryARCStatus,
  ext_act_date_tocd AS IntcoExtActlTransfOfCtrlDteTme,
  ext_plan_date_tocd AS IntcoExtPlndTransfOfCtrlDteTme,
  ext_tzone_tocd AS IntcoExtTransfOfCtrlDteTmeTmzn,
  int_act_date_tocd AS IntcoIntActlTransfOfCtrlDteTme,
  int_plan_date_tocd AS IntcoIntPlndTransfOfCtrlDteTme,
  int_tzone_tocd AS IntcoIntTransfOfCtrlDteTmeTmzn,
  spe_le_scenario AS LogisticsExecutionScenario,
  likp.cmpsi AS FinDocCreditCheckStatus,
  likp.cmpsk AS PaytAuthsnCreditCheckSts,
  likp.cmps_cm AS CentralCreditCheckStatus,
  likp.cmpsj AS ExprtInsurCreditCheckStatus,
  likp.rfm_psst_group AS ShippingGroupNumber
FROM likp
LEFT OUTER JOIN I_DeliveryDocumentItem AS _Item ON DeliveryDocument = _Item.DeliveryDocument  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentPartner AS _Partner ON DeliveryDocument = _Partner.SDDocument  -- association [1..*]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocumentType AS _DeliveryDocumentType ON DeliveryDocumentType = _DeliveryDocumentType.DeliveryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ReceivingPlant ON ReceivingPlant = _ReceivingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Warehouse AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_MfgOrder AS _OrderID ON OrderID = _OrderID.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HeaderWeightUnit ON HeaderWeightUnit = _HeaderWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HeaderVolumeUnit ON HeaderVolumeUnit = _HeaderVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_WarehouseGate AS _WarehouseGate ON Warehouse = _WarehouseGate.Warehouse AND WarehouseGate = _WarehouseGate.WarehouseGate  -- association [0..1]
LEFT OUTER JOIN I_WarehouseStagingArea AS _WarehouseStagingArea ON Warehouse = _WarehouseStagingArea.Warehouse AND WarehouseStagingArea = _WarehouseStagingArea.WarehouseStagingArea  -- association [0..1]
LEFT OUTER JOIN I_Material AS _MeansOfTransportRefMaterial ON MeansOfTransportRefMaterial = _MeansOfTransportRefMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_SpecialProcessingCode AS _SpecialProcessingCode ON SpecialProcessingCode = _SpecialProcessingCode.SpecialProcessingCode  -- association [0..1]
LEFT OUTER JOIN I_LoadingPoint AS _LoadingPoint ON LoadingPoint = _LoadingPoint.LoadingPoint AND ShippingPoint = _LoadingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_HandlingUnitInStock AS _HandlingUnitInStock ON HandlingUnitInStock = _HandlingUnitInStock.HandlingUnitInStock  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_ShippingType AS _ShippingType ON ShippingType = _ShippingType.ShippingType  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_ShipmentBlockReason AS _ShipmentBlockReason ON ShipmentBlockReason = _ShipmentBlockReason.ShipmentBlockReason  -- association [0..1]
LEFT OUTER JOIN I_Route AS _ProposedDeliveryRoute ON ProposedDeliveryRoute = _ProposedDeliveryRoute.Route  -- association [0..1]
LEFT OUTER JOIN I_Route AS _ActualDeliveryRoute ON ActualDeliveryRoute = _ActualDeliveryRoute.Route  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_TransportationGroup AS _TransportationGroup ON TransportationGroup = _TransportationGroup.TransportationGroup  -- association [0..1]
LEFT OUTER JOIN I_MeansOfTransportType AS _MeansOfTransportType ON MeansOfTransportType = _MeansOfTransportType.MeansOfTransportType  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _HeaderBillingBlockReason ON HeaderBillingBlockReason = _HeaderBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_PaymentGuaranteeProcedure AS _PaymentGuaranteeProcedure ON PaymentGuaranteeProcedure = _PaymentGuaranteeProcedure.PaymentGuaranteeProcedure  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_OverallSDProcessStatus AS _OverallSDProcessStatus ON OverallSDProcessStatus = _OverallSDProcessStatus.OverallSDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_TotalBlockStatus AS _TotalBlockStatus ON TotalBlockStatus = _TotalBlockStatus.TotalBlockStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallDelivConfStatus AS _OverallDelivConfStatus ON OverallDelivConfStatus = _OverallDelivConfStatus.OverallDelivConfStatus  -- association [0..1]
LEFT OUTER JOIN I_TransportationPlanningSts AS _TransportationPlanningSts ON TransportationPlanningStatus = _TransportationPlanningSts.TransportationPlanningStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallPickingConfStatus AS _OverallPickingConfStatus ON OverallPickingConfStatus = _OverallPickingConfStatus.OverallPickingConfStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallPickingStatus AS _OverallPickingStatus ON OverallPickingStatus = _OverallPickingStatus.OverallPickingStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallPackingStatus AS _OverallPackingStatus ON OverallPackingStatus = _OverallPackingStatus.OverallPackingStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlWarehouseActyStatus AS _OvrlWarehouseActyStatus ON OverallWarehouseActivityStatus = _OvrlWarehouseActyStatus.OverallWarehouseActivityStatus  -- association [0..1]
LEFT OUTER JOIN I_DistrStatusByDectrlzdWrhs AS _DistrStatusByDectrlzdWrhs ON DistrStatusByDecentralizedWrhs = _DistrStatusByDectrlzdWrhs.DistrStatusByDecentralizedWrhs  -- association [0..1]
LEFT OUTER JOIN I_OverallGoodsMovementStatus AS _OverallGoodsMovementStatus ON OverallGoodsMovementStatus = _OverallGoodsMovementStatus.OverallGoodsMovementStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallDelivReltdBillgSts AS _OverallDelivReltdBillgStatus ON OverallDelivReltdBillgStatus = _OverallDelivReltdBillgStatus.OverallDelivReltdBillgStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallDelivReltdBillgSts AS _OverallIntcoBillingStatus ON OverallIntcoBillingStatus = _OverallIntcoBillingStatus.OverallDelivReltdBillgStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallProofOfDelivStatus AS _OverallProofOfDeliveryStatus ON OverallProofOfDeliveryStatus = _OverallProofOfDeliveryStatus.OverallProofOfDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_HdrGenIncompletionStatus AS _HdrGeneralIncompletionStatus ON HdrGeneralIncompletionStatus = _HdrGeneralIncompletionStatus.HdrGeneralIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_HdrDelivIncompletionStatus AS _HeaderDelivIncompletionStatus ON HeaderDelivIncompletionStatus = _HeaderDelivIncompletionStatus.HeaderDelivIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_HdrPickgIncompltnStatus AS _HeaderPickgIncompletionStatus ON HeaderPickgIncompletionStatus = _HeaderPickgIncompletionStatus.HeaderPickgIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_HdrPackingIncompltnStatus AS _HeaderPackingIncompletionSts ON HeaderPackingIncompletionSts = _HeaderPackingIncompletionSts.HeaderPackingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_HdrGoodsMvtIncompltnStatus AS _HdrGoodsMvtIncompletionStatus ON HdrGoodsMvtIncompletionStatus = _HdrGoodsMvtIncompletionStatus.HdrGoodsMvtIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_HdrBillgIncompletionStatus AS _HeaderBillgIncompletionStatus ON HeaderBillgIncompletionStatus = _HeaderBillgIncompletionStatus.HeaderBillgIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmGenIncompletionSts AS _OvrlItmGeneralIncompletionSts ON OvrlItmGeneralIncompletionSts = _OvrlItmGeneralIncompletionSts.OvrlItmGeneralIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmPackingIncompltnSts AS _OvrlItmPackingIncompletionSts ON OvrlItmPackingIncompletionSts = _OvrlItmPackingIncompletionSts.OvrlItmPackingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmPickingIncompltnSts AS _OvrlItmPickingIncompletionSts ON OvrlItmPickingIncompletionSts = _OvrlItmPickingIncompletionSts.OvrlItmPickingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmDelivIncompletionSts AS _OvrlItmDelivIncompletionSts ON OvrlItmDelivIncompletionSts = _OvrlItmDelivIncompletionSts.OvrlItmDelivIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmGdsMvtIncompltnSts AS _OvrlItmGdsMvtIncompletionSts ON OvrlItmGdsMvtIncompletionSts = _OvrlItmGdsMvtIncompletionSts.OvrlItmGdsMvtIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_TotalCreditCheckStatus AS _TotalCreditCheckStatus ON TotalCreditCheckStatus = _TotalCreditCheckStatus.TotalCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_FinDocCreditCheckStatus AS _FinDocCreditCheckStatus ON FinDocCreditCheckStatus = _FinDocCreditCheckStatus.FinDocCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_PaytAuthsnCreditCheckSts AS _PaytAuthsnCreditCheckSts ON PaytAuthsnCreditCheckSts = _PaytAuthsnCreditCheckSts.PaytAuthsnCreditCheckSts  -- association [0..1]
LEFT OUTER JOIN I_CentralCreditCheckStatus AS _CentralCreditCheckStatus ON CentralCreditCheckStatus = _CentralCreditCheckStatus.CentralCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_ExprtInsurCreditCheckStatus AS _ExprtInsurCreditCheckStatus ON ExprtInsurCreditCheckStatus = _ExprtInsurCreditCheckStatus.ExprtInsurCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_CentralCreditChkTechErrSts AS _CentralCreditChkTechErrSts ON CentralCreditChkTechErrSts = _CentralCreditChkTechErrSts.CentralCreditChkTechErrSts  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerCreditAccount ON CustomerCreditAccount = _CustomerCreditAccount.Customer  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON ControllingAreaCurrency = _ControllingAreaCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_MaxDocValueCreditCheckSts AS _MaxDocValueCreditCheckStatus ON MaxDocValueCreditCheckStatus = _MaxDocValueCreditCheckStatus.MaxDocValueCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermCreditCheckSts AS _PaymentTermCreditCheckStatus ON PaymentTermCreditCheckStatus = _PaymentTermCreditCheckStatus.PaymentTermCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentHeader AS _MaterialDocumentHeader ON DeliveryDocument = _MaterialDocumentHeader.DeliveryDocument  -- association [0..*]
LEFT OUTER JOIN I_OverallSDProcessStatusText AS _OverallSDProcessStatusText ON OverallSDProcessStatus = _OverallSDProcessStatusText.OverallSDProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_PackingStatusText AS _PackingStatusText ON OverallPackingStatus = _PackingStatusText.PackingStatus  -- association [0..*]
LEFT OUTER JOIN I_OverallDelivChmlCmplncSts AS _OverallChmlCmplncStatus ON OverallChmlCmplncStatus = _OverallChmlCmplncStatus.OverallChmlCmplncStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlDelivDngrsGdsSts AS _OverallDangerousGoodsStatus ON OverallDangerousGoodsStatus = _OverallDangerousGoodsStatus.OverallDangerousGoodsStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlDelivSftyDataShtSts AS _OvrlSftyDataSheetSts ON OverallSafetyDataSheetStatus = _OvrlSftyDataSheetSts.OverallSafetyDataSheetStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlTradeCmplncEmbargoStatus AS _OverallTrdCmplncEmbargoSts ON OverallTrdCmplncEmbargoSts = _OverallTrdCmplncEmbargoSts.OverallTrdCmplncEmbargoSts  -- association [0..1]
LEFT OUTER JOIN I_OvTrdCmplncSnctndListChkSts AS _OvrlTrdCmplncSnctndListChkSts ON OvrlTrdCmplncSnctndListChkSts = _OvrlTrdCmplncSnctndListChkSts.OvrlTrdCmplncSnctndListChkSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlTrdCmplncLegalCtrlChkSts AS _OvrlTrdCmplncLegalCtrlChkSts ON OvrlTrdCmplncLegalCtrlChkSts = _OvrlTrdCmplncLegalCtrlChkSts.OvrlTrdCmplncLegalCtrlChkSts  -- association [0..1]
LEFT OUTER JOIN I_ExciseTaxStatus AS _ExciseTaxStatus ON EU_DeliveryARCStatus = _ExciseTaxStatus.EU_ARCStatus  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _ExternalTCOTimezone ON IntcoExtTransfOfCtrlDteTmeTmzn = _ExternalTCOTimezone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _InternalTCOTimezone ON IntcoIntTransfOfCtrlDteTmeTmzn = _InternalTCOTimezone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_WarehouseExecutionStatus AS _WarehouseExecutionStatus ON ReadyForWarehouseExecStatus = _WarehouseExecutionStatus.ReadyForWarehouseExecStatus  -- association [0..1]
LEFT OUTER JOIN I_AdvShipReceiveRlvnce AS _DelivAdvncdShipgRcvgRlvnce ON DelivAdvncdShipgRcvgRlvnce = _DelivAdvncdShipgRcvgRlvnce.DelivAdvncdShipgRcvgRlvnce  -- association [0..1]
LEFT OUTER JOIN I_LogisticsExecutionScenario AS _LogisticsExecScenario ON LogisticsExecutionScenario = _LogisticsExecScenario.LogisticsExecutionScenario  -- association [0..1]
LEFT OUTER JOIN E_DeliveryDocument AS _Extension ON DeliveryDocument = _Extension.DeliveryDocument  -- association [0..1]
;