R_TrdgDocBusinessDataBasic

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_TrdgDocBusinessDataBasic.
-- 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_TrdgDocBusinessDataBasic AS
SELECT
  tkonn AS TradingDocument,
  tposn AS TradingDocumentItem,
  abssc AS PaymentGuaranteeProcedure,
  akprz AS DepreciationPercentage,
  cast( angnr_mm as wb2_suplr_qtan preserving type ) AS SupplierQuotationExternalID,
  bsart AS PurchasingDocumentType,
  cast( bstae_mm as wb2_suplr_conf_ctrl preserving type ) AS SupplierConfirmationControlKey,
  cast( bstdk as wb2_cust_purch_order_date preserving type ) AS CustomerPurchaseOrderDate,
  bstdk_e AS CustPurOrdDateByShipToParty,
  cast( bstkd as wb2_po_by_cust_extd preserving type ) AS PurchaseOrderByCustomer,
  cast( bstkd_e as wb2_po_by_ship_to_party preserving type ) AS PurchaseOrderByShipToParty,
  bstyp AS TrdgDocPurgDocCat,
  dpamt AS DownPaymentAmount,
  dpdat AS DownPaymentDueDate,
  dppct AS DownPaymentPercentageOfTotAmt,
  dptyp AS DownPaymentType,
  cast( ebdat as wb2_purg_doc_dte preserving type ) AS PurchasingDocumentOrderDate,
  edatu_vbak AS TrdgDocSlsReqdDeliveryDate,
  eindt AS TrdgDocPurgReqdDeliveryDate,
  ekgrp AS PurchasingGroup,
  ekorg AS PurchasingOrganization,
  elifn AS Supplier,
  erdat AS CreationDate,
  ernam AS CreatedByUser,
  cast( erzet as wb2_created_at preserving type ) AS CreationTime,
  cast( evers_mm as wb2_purg_shipg_instrn preserving type ) AS TrdgDocPurgShipgInstrn,
  cast( hkla as wb2_purg_deliv_addr preserving type ) AS TrdgDocPurgDelivAddrCat,
  ihran AS QuotationSubmissionDate,
  cast( ihrez as wb2_purg_doc_ext_ref preserving type ) AS TrdgDocPurgDocExtReference,
  inco1_mm AS PurgIncotermsClassification,
  inco1_sd AS SlsIncotermsClassification,
  cast( inco2_l_mm as wb2_inco1_loc_mm preserving type ) AS TrdgDocPurgIncotermsLoc1Text,
  cast( inco2_l_sd as wb2_inco1_loc_sd preserving type ) AS TrdgDocSlsIncotermsLoc1Text,
  cast( inco2_mm as wb2_purg_incoterms2 preserving type ) AS PurgIncotermsTransferLocation,
  inco2_sd AS SlsIncotermsTransferLocation,
  cast( inco3_l_mm as wb2_inco2_loc_mm preserving type ) AS TrdgDocPurgIncotermsLoc2Text,
  cast( inco3_l_sd as wb2_inco2_loc_sd preserving type ) AS TrdgDocSlsIncotermsLoc2Text,
  cast( incov_mm as wb2_inco1_version_mm preserving type ) AS TrdgDocPurgIncotermsVersion,
  cast( incov_sd as wb2_inco1_version_sd preserving type ) AS TrdgDocSalesIncotermsVersion,
  cast( kalsm_mm as wb2_purg_prcg_proced preserving type ) AS TrdgDocPurgPricingProcedure,
  cast( kdatb_mm as wb2_purg_valdty_start_dte preserving type ) AS TrdgDocPurgValidityStartDate,
  cast( kdate_mm as wb2_purg_valdty_end_dte preserving type ) AS TrdgDocPurgValidityEndDate,
  kufix AS FixedExchangeRateIsUsed,
  cast( kurst_mm as wb2_purg_exch_rate_type preserving type ) AS TrdgDocPurgExchangeRateType,
  kzabs_mm AS IsOrderAcknRqd,
  kzazu AS OrderCombinationIsAllowed,
  labnr AS PurgDocOrderAcknNumber,
  lcnum AS InternalFinancialDocument,
  cast( lpein_int as wb2_purg_deliv_date_type preserving type ) AS TrdgDocPurgDeliveryDateType,
  mndid AS SEPAMandate,
  posex_e AS UnderlyingPurchaseOrderItem,
  posplit AS TrdgDocMnlPOSplit,
  cast( prgrs_vbak as wb2_sls_deliv_dte_type preserving type ) AS TrdgDocSlsDeliveryDateType,
  cast( prsdt_mm as wb2_purch_pricing_date preserving type ) AS TrdgDocPurgPricingDate,
  cast( prsdt_sd as wb2_sales_pricing_date preserving type ) AS TrdgDocSalesPricingDate,
  reswk AS SupplyingPlant,
  retpc AS RetentionPercentage,
  cast( telf1_mm as wb2_suplr_tel preserving type ) AS SupplierPhoneNumber,
  termdes_mm AS PaymentTermsName,
  cast( tkrate_mm as wb2_purg_exch_rate_no_cnext preserving type ) AS TrdgDocPurgExchangeRate,
  unsez_mm AS CorrespncInternalReference,
  cast( valdt as wb2_purg_fixedval_date preserving type ) AS TrdgDocPurgFixedValueDate,
  cast( valdtd as wb2_sls_fixedval_date preserving type ) AS TrdgDocSalesFixedValueDate,
  cast( verkf_mm as wb2_suplr_resp_sls_person preserving type ) AS SupplierRespSalesPersonName,
  vsart AS ShippingType,
  cast( waers_purch as wb2_purg_currency preserving type ) AS TrdgDocPurgCurrency,
  cast( werk_mm as wb2_issuing_plant preserving type ) AS IssuingPlant,
  cast( zlsch as wb2_sls_payt_method preserving type ) AS TrdgDocSalesPaymentMethod,
  zterm AS TrdgDocPurgPaymentTerms,
  zterm_sales AS TrdgDocSalesPaymentTerms,
  knumv_mm AS TrdgDocPurgDocCndn,
  cast ( kursk_sd as wb2_sls_exchrate_prcdetn preserving type ) AS TrdgDocPrcDetnExchRate,
  cast( podkz as wb2_rlvt_pod_procg preserving type ) AS TrdgDocIsRlvtPoDProcg
FROM wbhd
LEFT OUTER JOIN R_TrdgDocPurgDelivAddrCat AS _TrdgDocPurgDelivAddrCat ON TrdgDocPurgDelivAddrCat = _TrdgDocPurgDelivAddrCat.TrdgDocPurgDelivAddrCat  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocPurgDocCat AS _TrdgDocPurgDocCat ON TrdgDocPurgDocCat = _TrdgDocPurgDocCat.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TrdgDocPurgCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _TrdgDocPurgExchangeRateType ON TrdgDocPurgExchangeRateType = _TrdgDocPurgExchangeRateType.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _PurgIncotermsClassification ON PurgIncotermsClassification = _PurgIncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _SlsIncotermsClassification ON SlsIncotermsClassification = _SlsIncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_ShippingInstruction AS _ShippingInstruction ON TrdgDocPurgShipgInstrn = _ShippingInstruction.ShippingInstruction  -- association [0..1]
LEFT OUTER JOIN I_SupplierConfControlKey AS _SupplierConfControlKey ON SupplierConfirmationControlKey = _SupplierConfControlKey.SupplierConfirmationControlKey  -- association [0..1]
LEFT OUTER JOIN I_PaymentGuaranteeProcedure AS _PaymentGuaranteeProcedure ON PaymentGuaranteeProcedure = _PaymentGuaranteeProcedure.PaymentGuaranteeProcedure  -- association [0..1]
LEFT OUTER JOIN I_ShippingType AS _ShippingType ON ShippingType = _ShippingType.ShippingType  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _TrdgDocPurgPaymentTerms ON TrdgDocPurgPaymentTerms = _TrdgDocPurgPaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _TrdgDocSalesPaymentTerms ON TrdgDocSalesPaymentTerms = _TrdgDocSalesPaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _TrdgDocPurgIncotermsVersion ON TrdgDocPurgIncotermsVersion = _TrdgDocPurgIncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _TrdgDocSlsIncotermsVersion ON TrdgDocSalesIncotermsVersion = _TrdgDocSlsIncotermsVersion.IncotermsVersion  -- association [0..1]
;