I_DeliveryDocumentType

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_DeliveryDocumentType.
-- 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.
-- SQL view name: ILEDELIVDOCTYPE

CREATE VIEW I_DeliveryDocumentType AS
SELECT
  lfart AS DeliveryDocumentType,
  vbtyp AS SDDocumentCategory,
  aufer AS PrecedingDocumentRequirement,
  itmac AS TradeComplianceIsActive,
  numki AS NumberRangeForIntIDAssignment,
  numke AS NumberRangeForExtIDAssignment,
  incpo AS IncrementItemNumber,
  daart AS DefaultOrderType,
  reglg AS StorageLocationRule,
  txtgr AS TextDeterminationProcedure,
  routf AS RouteDetermination,
  lnspl AS DeliveryIsSplitByWarehouse,
  dsfad AS DeliveryIsSplitByPartner,
  averp AS DeliveryIsPackedAutomatically,
  pm_item_gen AS DelivItmsAreGnrtdForPackggMatl,
  pargr AS PartnerDeterminationProcedure,
  neute AS RescheduleDeliveries,
  int_tocd_offset AS IntTransfOfControlDateOffset,
  int_tocd_offset_unit AS IntTransfOfCtrlDateOffsetUnit,
  ext_tocd_offset AS ExtTransfOfControlDateOffset,
  ext_tocd_offset_unit AS ExtTransfOfCtrlDateOffsetUnit,
  j_1adoccls AS AR_ElectronicDocDocumentClass
FROM tvlk
LEFT OUTER JOIN I_DeliveryDocumentTypeText AS _Text ON DeliveryDocumentType = _Text.DeliveryDocumentType  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SDDocumentType ON DefaultOrderType = _SDDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_TextDeterminationProcedure AS _TextDeterminationProcedure ON TextDeterminationProcedure = _TextDeterminationProcedure.TextDeterminationProcedure AND _TextDeterminationProcedure.TextObjectCategory = 'VBBK'  -- association [0..1]
LEFT OUTER JOIN I_PartDeterminationProcedure AS _PartnerDeterminationProcedure ON PartnerDeterminationProcedure = _PartnerDeterminationProcedure.PartnerDeterminationProcedure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ExtTransfOfCtrlDateOffsetUnit ON ExtTransfOfCtrlDateOffsetUnit = _ExtTransfOfCtrlDateOffsetUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _IntTransfOfCtrlDateOffsetUnit ON IntTransfOfCtrlDateOffsetUnit = _IntTransfOfCtrlDateOffsetUnit.UnitOfMeasure  -- association [0..1]
;