R_TrdgDocItem

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_TrdgDocItem.
-- 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_TrdgDocItem AS
SELECT
  BusinessDataBasic.PaymentGuaranteeProcedure AS PaymentGuaranteeProcedure,
  BusinessDataBasic.DepreciationPercentage AS DepreciationPercentage,
  BusinessDataBasic.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  BusinessDataBasic.PurchasingDocumentType AS PurchasingDocumentType,
  BusinessDataBasic.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  BusinessDataBasic.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  BusinessDataBasic.CustPurOrdDateByShipToParty AS CustPurOrdDateByShipToParty,
  BusinessDataBasic.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  BusinessDataBasic.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  BusinessDataBasic.TrdgDocPurgDocCat AS TrdgDocPurgDocCat,
  BusinessDataBasic.DownPaymentDueDate AS DownPaymentDueDate,
  BusinessDataBasic.DownPaymentPercentageOfTotAmt AS DownPaymentPercentageOfTotAmt,
  BusinessDataBasic.DownPaymentType AS DownPaymentType,
  BusinessDataBasic.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  BusinessDataBasic.TrdgDocSlsReqdDeliveryDate AS TrdgDocSlsReqdDeliveryDate,
  BusinessDataBasic.TrdgDocPurgReqdDeliveryDate AS TrdgDocPurgReqdDeliveryDate,
  BusinessDataBasic.PurchasingGroup AS PurchasingGroup,
  BusinessDataBasic.PurchasingOrganization AS PurchasingOrganization,
  BusinessDataBasic.Supplier AS Supplier,
  BusinessDataBasic.TrdgDocPurgShipgInstrn AS TrdgDocPurgShipgInstrn,
  BusinessDataBasic.TrdgDocPurgDelivAddrCat AS TrdgDocPurgDelivAddrCat,
  BusinessDataBasic.QuotationSubmissionDate AS QuotationSubmissionDate,
  BusinessDataBasic.TrdgDocPurgDocExtReference AS TrdgDocPurgDocExtReference,
  BusinessDataBasic.PurgIncotermsClassification AS PurgIncotermsClassification,
  BusinessDataBasic.SlsIncotermsClassification AS SlsIncotermsClassification,
  BusinessDataBasic.TrdgDocPurgIncotermsLoc1Text AS TrdgDocPurgIncotermsLoc1Text,
  BusinessDataBasic.TrdgDocSlsIncotermsLoc1Text AS TrdgDocSlsIncotermsLoc1Text,
  BusinessDataBasic.PurgIncotermsTransferLocation AS PurgIncotermsTransferLocation,
  BusinessDataBasic.SlsIncotermsTransferLocation AS SlsIncotermsTransferLocation,
  BusinessDataBasic.TrdgDocPurgIncotermsLoc2Text AS TrdgDocPurgIncotermsLoc2Text,
  BusinessDataBasic.TrdgDocSlsIncotermsLoc2Text AS TrdgDocSlsIncotermsLoc2Text,
  BusinessDataBasic.TrdgDocPurgIncotermsVersion AS TrdgDocPurgIncotermsVersion,
  BusinessDataBasic.TrdgDocSalesIncotermsVersion AS TrdgDocSalesIncotermsVersion,
  BusinessDataBasic.TrdgDocPurgPricingProcedure AS TrdgDocPurgPricingProcedure,
  BusinessDataBasic.TrdgDocPurgValidityStartDate AS TrdgDocPurgValidityStartDate,
  BusinessDataBasic.TrdgDocPurgValidityEndDate AS TrdgDocPurgValidityEndDate,
  BusinessDataBasic.FixedExchangeRateIsUsed AS FixedExchangeRateIsUsed,
  BusinessDataBasic.TrdgDocPurgExchangeRateType AS TrdgDocPurgExchangeRateType,
  BusinessDataBasic.IsOrderAcknRqd AS IsOrderAcknRqd,
  BusinessDataBasic.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  BusinessDataBasic.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  BusinessDataBasic.InternalFinancialDocument AS InternalFinancialDocument,
  BusinessDataBasic.TrdgDocPurgDeliveryDateType AS TrdgDocPurgDeliveryDateType,
  BusinessDataBasic.SEPAMandate AS SEPAMandate,
  BusinessDataBasic.UnderlyingPurchaseOrderItem AS UnderlyingPurchaseOrderItem,
  BusinessDataBasic.TrdgDocMnlPOSplit AS TrdgDocMnlPOSplit,
  BusinessDataBasic.TrdgDocSlsDeliveryDateType AS TrdgDocSlsDeliveryDateType,
  BusinessDataBasic.TrdgDocPurgPricingDate AS TrdgDocPurgPricingDate,
  BusinessDataBasic.TrdgDocSalesPricingDate AS TrdgDocSalesPricingDate,
  BusinessDataBasic.SupplyingPlant AS SupplyingPlant,
  BusinessDataBasic.RetentionPercentage AS RetentionPercentage,
  BusinessDataBasic.SupplierPhoneNumber AS SupplierPhoneNumber,
  BusinessDataBasic.PaymentTermsName AS PaymentTermsName,
  BusinessDataBasic.TrdgDocPurgExchangeRate AS TrdgDocPurgExchangeRate,
  BusinessDataBasic.CorrespncInternalReference AS CorrespncInternalReference,
  BusinessDataBasic.TrdgDocPurgFixedValueDate AS TrdgDocPurgFixedValueDate,
  BusinessDataBasic.TrdgDocSalesFixedValueDate AS TrdgDocSalesFixedValueDate,
  BusinessDataBasic.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  BusinessDataBasic.ShippingType AS ShippingType,
  BusinessDataBasic.IssuingPlant AS IssuingPlant,
  BusinessDataBasic.TrdgDocSalesPaymentMethod AS TrdgDocSalesPaymentMethod,
  BusinessDataBasic.TrdgDocPurgPaymentTerms AS TrdgDocPurgPaymentTerms,
  BusinessDataBasic.TrdgDocSalesPaymentTerms AS TrdgDocSalesPaymentTerms,
  BusinessDataBasic.TrdgDocPurgDocCndn AS TrdgDocPurgDocCndn,
  BusinessDataBasic.TrdgDocPrcDetnExchRate AS TrdgDocPrcDetnExchRate,
  BusinessDataBasic.TrdgDocIsRlvtPoDProcg AS TrdgDocIsRlvtPoDProcg,
  BusinessDataBasic._Supplier AS _Supplier,
  TrdgDocItemBasic.TradingDocument AS TradingDocument,
  TrdgDocItemBasic.TradingDocumentItem AS TradingDocumentItem,
  TrdgDocItemBasic.TrdgDocItemCategory AS TrdgDocItemCategory,
  TrdgDocItemBasic.Product AS Product,
  TrdgDocItemBasic.TrdgDocItemText AS TrdgDocItemText,
  TrdgDocItemBasic.ProductGroup AS ProductGroup,
  TrdgDocItemBasic.TrdgDocReltdDocItmValnType AS TrdgDocReltdDocItmValnType,
  TrdgDocItemBasic.Plant AS Plant,
  TrdgDocItemBasic.StorageLocation AS StorageLocation,
  TrdgDocItemBasic.Batch AS Batch,
  TrdgDocItemBasic.OrganizationDivision AS OrganizationDivision,
  TrdgDocItemBasic.BusinessArea AS BusinessArea,
  TrdgDocItemBasic.CreatedByUser AS CreatedByUser,
  TrdgDocItemBasic.CreationDate AS CreationDate,
  TrdgDocItemBasic.CreationTime AS CreationTime,
  TrdgDocItemBasic.TrdgDocPurgQuantity AS TrdgDocPurgQuantity,
  TrdgDocItemBasic.TrdgDocPurgQuantityUnit AS TrdgDocPurgQuantityUnit,
  TrdgDocItemBasic.TrdgDocSalesQuantity AS TrdgDocSalesQuantity,
  TrdgDocItemBasic.TrdgDocSlsQuantityUnit AS TrdgDocSlsQuantityUnit,
  TrdgDocItemBasic.TrdgDocSlsToBaseQtyNmrtr AS TrdgDocSlsToBaseQtyNmrtr,
  TrdgDocItemBasic.TrdgDocSlsToBaseQtyDnmntr AS TrdgDocSlsToBaseQtyDnmntr,
  TrdgDocItemBasic.BaseUnit AS BaseUnit,
  TrdgDocItemBasic.TrdgDocPurgToBaseQtyNmrtr AS TrdgDocPurgToBaseQtyNmrtr,
  TrdgDocItemBasic.TrdgDocPurgToBaseQtyDnmntr AS TrdgDocPurgToBaseQtyDnmntr,
  TrdgDocItemBasic.TrdgDocPurgToOrdQtyNmrtr AS TrdgDocPurgToOrdQtyNmrtr,
  TrdgDocItemBasic.TrdgDocPurgToOrdQtyDnmntr AS TrdgDocPurgToOrdQtyDnmntr,
  TrdgDocItemBasic.TrdgDocSlsToOrdQtyNmrtr AS TrdgDocSlsToOrdQtyNmrtr,
  TrdgDocItemBasic.TrdgDocSlsToOrdQtyDnmntr AS TrdgDocSlsToOrdQtyDnmntr,
  TrdgDocItemBasic.TrdgDocPurgCurrency AS TrdgDocPurgCurrency,
  TrdgDocItemBasic.TrdgDocSalesCurrency AS TrdgDocSalesCurrency,
  TrdgDocItemBasic.TrdgDocSlsWeightUnit AS TrdgDocSlsWeightUnit,
  TrdgDocItemBasic.TrdgDocSlsGrossWeight AS TrdgDocSlsGrossWeight,
  TrdgDocItemBasic.TrdgDocSlsNetWeight AS TrdgDocSlsNetWeight,
  TrdgDocItemBasic.TrdgDocSlsVolumeUnit AS TrdgDocSlsVolumeUnit,
  TrdgDocItemBasic.TrdgDocSlsVolume AS TrdgDocSlsVolume,
  TrdgDocItemBasic.TrdgDocPurgGrossWeight AS TrdgDocPurgGrossWeight,
  TrdgDocItemBasic.TrdgDocPurgNetWeight AS TrdgDocPurgNetWeight,
  TrdgDocItemBasic.TrdgDocPurgVolume AS TrdgDocPurgVolume,
  TrdgDocItemBasic.TrdgDocSlsPriceUnit AS TrdgDocSlsPriceUnit,
  TrdgDocItemBasic.TrdgDocPurgPriceUnit AS TrdgDocPurgPriceUnit,
  TrdgDocItemBasic.TrdgDocPurgNetPriceQuantity AS TrdgDocPurgNetPriceQuantity,
  TrdgDocItemBasic.TrdgDocSlsNetPriceQuantity AS TrdgDocSlsNetPriceQuantity,
  TrdgDocItemBasic.TrdgDocSalesNetPriceAmount AS TrdgDocSalesNetPriceAmount,
  TrdgDocItemBasic.TrdgDocPurgNetPriceAmount AS TrdgDocPurgNetPriceAmount,
  TrdgDocItemBasic.TrdgDocSlsItemNetAmount AS TrdgDocSlsItemNetAmount,
  TrdgDocItemBasic.TrdgDocPurgItemNetAmount AS TrdgDocPurgItemNetAmount,
  TrdgDocItemBasic.TrdgDocSlsItmNetAmtInSlsCrcy AS TrdgDocSlsItmNetAmtInSlsCrcy,
  TrdgDocItemBasic.TrdgDocPurgItmNetAmtInPOCrcy AS TrdgDocPurgItmNetAmtInPOCrcy,
  TrdgDocItemBasic.TrdgDocPurgSubtotal1Amount AS TrdgDocPurgSubtotal1Amount,
  TrdgDocItemBasic.TrdgDocPurgSubtotal2Amount AS TrdgDocPurgSubtotal2Amount,
  TrdgDocItemBasic.TrdgDocPurgSubtotal3Amount AS TrdgDocPurgSubtotal3Amount,
  TrdgDocItemBasic.TrdgDocPurgSubtotal4Amount AS TrdgDocPurgSubtotal4Amount,
  TrdgDocItemBasic.TrdgDocPurgSubtotal5Amount AS TrdgDocPurgSubtotal5Amount,
  TrdgDocItemBasic.TrdgDocPurgSubtotal6Amount AS TrdgDocPurgSubtotal6Amount,
  TrdgDocItemBasic.TrdgDocSlsSubtotal1Amount AS TrdgDocSlsSubtotal1Amount,
  TrdgDocItemBasic.TrdgDocSlsSubtotal2Amount AS TrdgDocSlsSubtotal2Amount,
  TrdgDocItemBasic.TrdgDocSlsSubtotal3Amount AS TrdgDocSlsSubtotal3Amount,
  TrdgDocItemBasic.TrdgDocSlsSubtotal4Amount AS TrdgDocSlsSubtotal4Amount,
  TrdgDocItemBasic.TrdgDocSlsSubtotal5Amount AS TrdgDocSlsSubtotal5Amount,
  TrdgDocItemBasic.TrdgDocSlsSubtotal6Amount AS TrdgDocSlsSubtotal6Amount,
  TrdgDocItemBasic.SlsUnlmtdOvrdelivIsAllwd AS SlsUnlmtdOvrdelivIsAllwd,
  TrdgDocItemBasic.SlsOvrdelivTolLmtRatioInPct AS SlsOvrdelivTolLmtRatioInPct,
  TrdgDocItemBasic.SlsUndrdelivTolLmtRatioInPct AS SlsUndrdelivTolLmtRatioInPct,
  TrdgDocItemBasic.PurgUnlmtdOvrdelivIsAllwd AS PurgUnlmtdOvrdelivIsAllwd,
  TrdgDocItemBasic.PurgOvrdelivTolLmtRatioInPct AS PurgOvrdelivTolLmtRatioInPct,
  TrdgDocItemBasic.PurgUndrdelivTolLmtRatioInPct AS PurgUndrdelivTolLmtRatioInPct,
  TrdgDocItemBasic.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  TrdgDocItemBasic.ProductHierarchyNode AS ProductHierarchyNode,
  TrdgDocItemBasic.ProductUsedByCustomer AS ProductUsedByCustomer,
  TrdgDocItemBasic.ProductTaxClassification1 AS ProductTaxClassification1,
  TrdgDocItemBasic.ProductTaxClassification2 AS ProductTaxClassification2,
  TrdgDocItemBasic.ProductTaxClassification3 AS ProductTaxClassification3,
  TrdgDocItemBasic.ProductTaxClassification4 AS ProductTaxClassification4,
  TrdgDocItemBasic.ProductTaxClassification5 AS ProductTaxClassification5,
  TrdgDocItemBasic.ProductTaxClassification6 AS ProductTaxClassification6,
  TrdgDocItemBasic.ProductTaxClassification7 AS ProductTaxClassification7,
  TrdgDocItemBasic.ProductTaxClassification8 AS ProductTaxClassification8,
  TrdgDocItemBasic.ProductTaxClassification9 AS ProductTaxClassification9,
  TrdgDocItemBasic.InternationalArticleNumber AS InternationalArticleNumber,
  TrdgDocItemBasic.ProfitCenter AS ProfitCenter,
  TrdgDocItemBasic.CostCenter AS CostCenter,
  TrdgDocItemBasic.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  TrdgDocItemBasic.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  TrdgDocItemBasic.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  TrdgDocItemBasic.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  TrdgDocItemBasic.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  TrdgDocItemBasic.ItemBillingBlockReason AS ItemBillingBlockReason,
  TrdgDocItemBasic.MaxNmbrOfPartialDelivery AS MaxNmbrOfPartialDelivery,
  TrdgDocItemBasic.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  TrdgDocItemBasic.TrdgDocSlsShippingPoint AS TrdgDocSlsShippingPoint,
  TrdgDocItemBasic.TradingDocumentPurchasingRoute AS TradingDocumentPurchasingRoute,
  TrdgDocItemBasic.TradingDocumentSalesRoute AS TradingDocumentSalesRoute,
  TrdgDocItemBasic.TrdgDocPurgShippingCondition AS TrdgDocPurgShippingCondition,
  TrdgDocItemBasic.TrdgDocPurgShippingPoint AS TrdgDocPurgShippingPoint,
  TrdgDocItemBasic.TrdgDocPurgTaxCode AS TrdgDocPurgTaxCode,
  TrdgDocItemBasic.ValuationCategory AS ValuationCategory,
  TrdgDocItemBasic.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  TrdgDocItemBasic.AccountAssignmentCategory AS AccountAssignmentCategory,
  TrdgDocItemBasic.GoodsReceiptLatestCreationDate AS GoodsReceiptLatestCreationDate,
  TrdgDocItemBasic.BatchClassification AS BatchClassification,
  TrdgDocItemBasic.TradingDocumentBusinessItem AS TradingDocumentBusinessItem,
  TrdgDocItemBasic.TrdgDocItemIsExtended AS TrdgDocItemIsExtended,
  TrdgDocItemBasic.TrdgDocItemIsDeleted AS TrdgDocItemIsDeleted,
  TrdgDocItemBasic.TrdgPortfolioInternalID AS TrdgPortfolioInternalID,
  TrdgDocItemBasic.TrdgDocItmPrtfloDetnDate AS TrdgDocItmPrtfloDetnDate,
  TrdgDocItemBasic.TrdgDocRefDocument AS TrdgDocRefDocument,
  TrdgDocItemBasic.TrdgDocRefDocItem AS TrdgDocRefDocItem,
  TrdgDocItemBasic.TrdgDocReferenceDocumentType AS TrdgDocReferenceDocumentType,
  TrdgDocItemBasic.TrdgDocAddlRefDocument AS TrdgDocAddlRefDocument,
  TrdgDocItemBasic.TrdgDocAddlRefDocItem AS TrdgDocAddlRefDocItem,
  TrdgDocItemBasic.TrdgDocAddlRefDocumentType AS TrdgDocAddlRefDocumentType,
  TrdgDocItemBasic.TrdgDocBusinessScenario AS TrdgDocBusinessScenario,
  TrdgDocItemBasic.TrdgDocAssociationGroup AS TrdgDocAssociationGroup,
  TrdgDocItemBasic.SupplierProductID AS SupplierProductID,
  TrdgDocItemBasic.TrdgDocOriglReqdProd AS TrdgDocOriglReqdProd,
  TrdgDocItemBasic.TradingDocumentHigherLevelItem AS TradingDocumentHigherLevelItem,
  TrdgDocItemBasic.TrdgDocPrcDetnIsIncomplete AS TrdgDocPrcDetnIsIncomplete,
  TrdgDocItemBasic.TrdgDocPurgBOMItmQty AS TrdgDocPurgBOMItmQty,
  TrdgDocItemBasic.TrdgDocSlsBOMItmQty AS TrdgDocSlsBOMItmQty,
  TrdgDocItemBasic.QuantityIsFixed AS QuantityIsFixed,
  TrdgDocItemBasic.TrdgDocBOMKeyDate AS TrdgDocBOMKeyDate,
  TrdgDocItemBasic.BillOfMaterialCategory AS BillOfMaterialCategory,
  TrdgDocItemBasic.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  TrdgDocItemBasic.TrdgDocPrcgRefProduct AS TrdgDocPrcgRefProduct,
  TrdgDocItemBasic.TrdgDocProdUsgeCat AS TrdgDocProdUsgeCat,
  TrdgDocItemBasic.TrdgDocSlsItmEffctvAmount AS TrdgDocSlsItmEffctvAmount,
  TrdgDocItemBasic.TrdgDocPurgItmEffctvAmount AS TrdgDocPurgItmEffctvAmount,
  TrdgDocItemBasic.TrdgDocSlsIsCshDiscGrntd AS TrdgDocSlsIsCshDiscGrntd,
  TrdgDocItemBasic.TrdgDocPurgIsCshDiscGrntd AS TrdgDocPurgIsCshDiscGrntd,
  TrdgDocItemBasic.TrdgDocPredecessorDocument AS TrdgDocPredecessorDocument,
  TrdgDocItemBasic.TrdgDocPredecessorItem AS TrdgDocPredecessorItem,
  TrdgDocItemBasic.TrdgDocPrdcssrDocumentType AS TrdgDocPrdcssrDocumentType,
  TrdgDocItemBasic.TrdgDocPurgTaxAmount AS TrdgDocPurgTaxAmount,
  TrdgDocItemBasic.TrdgDocSlsTaxAmount AS TrdgDocSlsTaxAmount,
  TrdgDocItemBasic.TrdgDocHdggRlvt AS TrdgDocHdggRlvt,
  TrdgDocItemBasic.TrdgDocCndnCnsldtnCat AS TrdgDocCndnCnsldtnCat,
  TrdgDocItemBasic.TrdgDocCndnIsCnsldtd AS TrdgDocCndnIsCnsldtd,
  TrdgDocItemBasic.TrdgDocSTOPostingLogic AS TrdgDocSTOPostingLogic,
  TrdgDocItemBasic.TrdgDocSettlementMode AS TrdgDocSettlementMode,
  TrdgDocItemBasic.IssuingStorageLocation AS IssuingStorageLocation,
  TrdgDocItemBasic.TrdgDocPurgTaxJurisdiction AS TrdgDocPurgTaxJurisdiction,
  TrdgDocItemBasic.PaymentGuaranteeForm AS PaymentGuaranteeForm,
  TrdgDocItemBasic.DownPaymentAmount AS DownPaymentAmount,
  TrdgDocItemBasic.SupplierTotalGrossAmount AS SupplierTotalGrossAmount,
  TrdgDocItemBasic.TrdgDocBOMProfile AS TrdgDocBOMProfile,
  TrdgDocItemBasic.AlternativeBillOfMaterial AS AlternativeBillOfMaterial,
  TrdgDocItemBasic.TrdgDocPurgRiskRelevancy AS TrdgDocPurgRiskRelevancy,
  TrdgDocItemBasic.TrdgDocSlsRiskRelevancy AS TrdgDocSlsRiskRelevancy,
  TrdgDocItemBasic.TrdgDocSlsClfnObjInternalID AS TrdgDocSlsClfnObjInternalID,
  TrdgDocItemBasic.TrdgDocPurgClfnObjInternalID AS TrdgDocPurgClfnObjInternalID,
  TrdgDocItemBasic.TrdgDocProdSizeOrDimnDesc AS TrdgDocProdSizeOrDimnDesc,
  TrdgDocItemBasic.TrdgDocItemIsComplete AS TrdgDocItemIsComplete,
  TrdgDocItemBasic.TradingDocumentInternalOrder AS TradingDocumentInternalOrder,
  TrdgDocItemBasic.TrdgDocItemBlockCode AS TrdgDocItemBlockCode,
  TrdgDocItemBasic.TrdgDocPurgTaxCountry AS TrdgDocPurgTaxCountry,
  TrdgDocItemBasic.TrdgDocPurgTaxDate AS TrdgDocPurgTaxDate,
  TrdgDocItemBasic.TrdgDocCurrency AS TrdgDocCurrency,
  TrdgDocItemBasic.ControllingArea AS ControllingArea,
  TrdgDocItemBasic.TrdgDocBillOfMaterial AS TrdgDocBillOfMaterial,
  TrdgDocItemBasic.TrdgDocPurchaseOrderItem AS TrdgDocPurchaseOrderItem,
  TrdgDocItemBasic.TrdgDocCommodityDefinition AS TrdgDocCommodityDefinition,
  TrdgDocItemBasic.TrdgDocIsItemRelevant AS TrdgDocIsItemRelevant,
  TrdgDocItemBasic._BaseUnit AS _BaseUnit,
  TrdgDocItemBasic._Batch AS _Batch,
  TrdgDocItemBasic._BusinessArea AS _BusinessArea,
  TrdgDocItemBasic._ControllingArea AS _ControllingArea,
  TrdgDocItemBasic._CostCenter AS _CostCenter,
  TrdgDocItemBasic._CreatedByUser AS _CreatedByUser,
  TrdgDocItemBasic._ItemBillingBlockReason AS _ItemBillingBlockReason,
  TrdgDocItemBasic._OriginallyRequestedProduct AS _OriginallyRequestedProduct,
  TrdgDocItemBasic._Plant AS _Plant,
  TrdgDocItemBasic._Product AS _Product,
  TrdgDocItemBasic._ProductGroup AS _ProductGroup,
  TrdgDocItemBasic._ProductHierarchyNode AS _ProductHierarchyNode,
  TrdgDocItemBasic._PurgDocumentItemCategory AS _PurgDocumentItemCategory,
  TrdgDocItemBasic._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  TrdgDocItemBasic._SalesSpcfcProductGroup1 AS _SalesSpcfcProductGroup1,
  TrdgDocItemBasic._SalesSpcfcProductGroup2 AS _SalesSpcfcProductGroup2,
  TrdgDocItemBasic._SalesSpcfcProductGroup3 AS _SalesSpcfcProductGroup3,
  TrdgDocItemBasic._SalesSpcfcProductGroup4 AS _SalesSpcfcProductGroup4,
  TrdgDocItemBasic._SalesSpcfcProductGroup5 AS _SalesSpcfcProductGroup5,
  TrdgDocItemBasic._StorageLocation AS _StorageLocation,
  TrdgDocItemBasic._TradingDocumentSalesRoute AS _TradingDocumentSalesRoute,
  TrdgDocItemBasic._TrdgDocAddlRefDocItem AS _TrdgDocAddlRefDocItem,
  TrdgDocItemBasic._TrdgDocAddlRefDocument AS _TrdgDocAddlRefDocument,
  TrdgDocItemBasic._TrdgDocAddlRefDocumentType AS _TrdgDocAddlRefDocumentType,
  TrdgDocItemBasic._TrdgDocCndnCnsldtnCat AS _TrdgDocCndnCnsldtnCat,
  TrdgDocItemBasic._TrdgDocIsHdggRlvt AS _TrdgDocIsHdggRlvt,
  TrdgDocItemBasic._TrdgDocItemBlockCode AS _TrdgDocItemBlockCode,
  TrdgDocItemBasic._TrdgDocItemCategory AS _TrdgDocItemCategory,
  TrdgDocItemBasic._TrdgDocItemIsComplete AS _TrdgDocItemIsComplete,
  TrdgDocItemBasic._TrdgDocPrcDetnIsIncmplt AS _TrdgDocPrcDetnIsIncmplt,
  TrdgDocItemBasic._TrdgDocPrdcssrDocType AS _TrdgDocPrdcssrDocType,
  TrdgDocItemBasic._TrdgDocPurgCurrency AS _TrdgDocPurgCurrency,
  TrdgDocItemBasic._TrdgDocPurgQuantityUnit AS _TrdgDocPurgQuantityUnit,
  TrdgDocItemBasic._TrdgDocPurgRskRelevancy AS _TrdgDocPurgRskRelevancy,
  TrdgDocItemBasic._TrdgDocPurgShipgCondition AS _TrdgDocPurgShipgCondition,
  TrdgDocItemBasic._TrdgDocPurgShippingPoint AS _TrdgDocPurgShippingPoint,
  TrdgDocItemBasic._TrdgDocRefDocItem AS _TrdgDocRefDocItem,
  TrdgDocItemBasic._TrdgDocRefDocument AS _TrdgDocRefDocument,
  TrdgDocItemBasic._TrdgDocRefDocumentType AS _TrdgDocRefDocumentType,
  TrdgDocItemBasic._TrdgDocSettlementMode AS _TrdgDocSettlementMode,
  TrdgDocItemBasic._TrdgDocSlsQuantityUnit AS _TrdgDocSlsQuantityUnit,
  TrdgDocItemBasic._TrdgDocSlsShippingPoint AS _TrdgDocSlsShippingPoint,
  TrdgDocItemBasic._TrdgDocSlsVolumeUnit AS _TrdgDocSlsVolumeUnit,
  TrdgDocItemBasic._TrdgDocSlsWeightUnit AS _TrdgDocSlsWeightUnit
FROM R_TrdgDocItemBasic AS TrdgDocItemBasic
INNER JOIN R_TrdgDocBusinessDataBasic AS BusinessDataBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_TrdgDocItemPartner AS _TrdgDocItemPartner ON TrdgDocItemBasic.TradingDocument = _TrdgDocItemPartner.TradingDocument AND TrdgDocItemBasic.TradingDocumentItem = _TrdgDocItemPartner.TradingDocumentItem  -- association [0..*]
LEFT OUTER JOIN R_TrdgDocItmSlsPrcgElmnt AS _SalesItemPricingElement ON TrdgDocItemBasic.TradingDocument = _SalesItemPricingElement.PricingDocument AND TrdgDocItemBasic.TradingDocumentItem = _SalesItemPricingElement.PricingDocumentItem  -- association [0..*]
LEFT OUTER JOIN R_TrdgDocItmPurgPrcgElmnt AS _PurgItemPricingElement ON TrdgDocItemBasic.TradingDocument = _PurgItemPricingElement.TradingDocument AND TrdgDocItemBasic.TradingDocumentItem = _PurgItemPricingElement.PricingDocumentItem  -- association [0..*]
LEFT OUTER JOIN R_TrdgDocScheduleLine AS _TrdgDocScheduleLine ON TrdgDocItemBasic.TradingDocument = _TrdgDocScheduleLine.TradingDocument AND TrdgDocItemBasic.TradingDocumentItem = _TrdgDocScheduleLine.TradingDocumentItem  -- association [0..*]
LEFT OUTER JOIN R_TrdgDoc AS _TrdgDoc ON TradingDocument = _TrdgDoc.TradingDocument  -- association [1..1]
;