R_TrdgDocHeaderBasic

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_TrdgDocHeaderBasic.
-- 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_TrdgDocHeaderBasic AS
SELECT
  tkonn AS TradingDocument,
  tctyp AS TradingDocumentType,
  tccat AS TrdgDocCategory,
  btbsta AS TrdgDocApplicationStatus,
  auart AS SalesDocumentType,
  ernam AS CreatedByUser,
  aenam AS LastChangedByUser,
  tksachb AS TrdgDocPersonResponsible,
  erdat AS CreationDate,
  cast( erzeit as wb2_created_at preserving type ) AS CreationTime,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  budat AS TrdgDocDate,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  vkgrp AS SalesGroup,
  vkbur AS SalesOffice,
  kunnr AS SoldToParty,
  kvgr1_sd AS AdditionalCustomerGroup1,
  kvgr2_sd AS AdditionalCustomerGroup2,
  kvgr3_sd AS AdditionalCustomerGroup3,
  kvgr4_sd AS AdditionalCustomerGroup4,
  kvgr5_sd AS AdditionalCustomerGroup5,
  kkber AS CreditControlArea,
  vbtyp_sd AS SDDocumentCategory,
  cast (audat as wb2_sales_document_date preserving type ) AS SalesDocumentDate,
  augru AS SalesOrderReason,
  submi_sd AS SDDocumentCollectiveNumber,
  bsark_sd AS CustomerPurchaseOrderType,
  bstzd_sd AS CustomerPurchaseOrderSuplmnt,
  angdt_sd AS BindingPeriodValidityStartDate,
  bnddt_sd AS BindingPeriodValidityEndDate,
  cast( guebg as wb2_sls_valdty_start_dte preserving type ) AS TrdgDocSlsValidityStartDate,
  cast( gueen as wb2_sls_valdty_end_dte preserving type ) AS TrdgDocSlsValidityEndDate,
  cast( abrvw as wb2_prod_usge_cat preserving type ) AS TrdgDocProdUsgeCat,
  exnum AS ForeignTrade,
  bname_sd AS TrdgDocSlsPersonName,
  cast( telf1_sd as wb2_cust_tel preserving type ) AS PhoneNumber1,
  cast( mahza_sd as wb2_sls_nrof_contacts preserving type ) AS TrdgDocSlsNrOfFollowUps,
  xblnr_sd AS DocumentReferenceID,
  pricing_type AS TrdgDocPricingType,
  tkwaers AS TrdgDocCurrency,
  netwr_sd AS TrdgDocTotalNetAmount,
  cast( tkrate as wb2_tkrate_no_cnext preserving type ) AS TrdgDocExchangeRate,
  kurst AS TrdgDocExchangeRateType,
  wkurs_dat AS TrdgDocExchangeRateDate,
  sdwrs AS TrdgDocSalesCurrency,
  cast( tkrate_sd as wb2_sls_exch_rate_no_cnext preserving type ) AS TrdgDocSalesExchangeRate,
  cast( kurst_sd as wb2_sls_exch_rate_type preserving type ) AS TrdgDocSalesExchangeRateType,
  cast( prsdt_sd as wb2_sls_prcg_dte preserving type ) AS TrdgDocSalesPricingDate,
  cast( kalsm_sd as wb2_sls_prcg_proced preserving type ) AS TrdgDocSalesPricingProcedure,
  taxk1_sd AS CustomerTaxClassification1,
  taxk2_sd AS CustomerTaxClassification2,
  taxk3_sd AS CustomerTaxClassification3,
  taxk4_sd AS CustomerTaxClassification4,
  taxk5_sd AS CustomerTaxClassification5,
  taxk6_sd AS CustomerTaxClassification6,
  taxk7_sd AS CustomerTaxClassification7,
  taxk8_sd AS CustomerTaxClassification8,
  taxk9_sd AS CustomerTaxClassification9,
  vsbed_sd AS ShippingCondition,
  autlf_sd AS CompleteDeliveryIsDefined,
  lifsk_sd AS DeliveryBlockReason,
  company_code AS CompanyCode,
  faksk_sd AS HeaderBillingBlockReason,
  kokrs AS ControllingArea,
  knkli AS CustomerCreditAccount,
  grupp AS CustomerCreditGroup,
  sbgrp AS CreditRepresentativeGroup,
  ctlpc AS CustomerRiskCategory,
  cmwae AS ControllingAreaCurrency,
  cmfre AS CreditBlockReleaseDate,
  cmnup AS NextCreditCheckDate,
  cmngv AS NextShippingDate,
  amtbl AS ReleasedCreditAmount,
  cast( wbpch as wb2_tc_last_changed_cat preserving type ) AS TrdgDocLastChangedCategory,
  cast( kurrf as wb2_acc_exchange_rate preserving type ) AS AccountingExchangeRate,
  ihrez_sd AS TrdgDocSlsExternalReference,
  cast( complete as wb2_doc_is_complete preserving type ) AS TrdgDocIsComplete,
  mahdt_sd AS LastCustomerContactDate,
  quan_complete AS TrdgDocQuantityIsComplete,
  tc_released AS TrdgDocReleaseStatus,
  tkonn_ex AS TrdgDocExternalIdentifier,
  cast( use_case as wb2_bus_proc_cat preserving type ) AS TrdgDocBusProcessCategory,
  cast( we_kunnr as wb2_goods_receiver preserving type ) AS TradingDocumentGoodsReceiver,
  stceg_l AS VATRegistrationCountry,
  landtx AS TaxDepartureCountry,
  xegdr AS IsEUTriangularDeal,
  dummy_wbhk_incl_eew_ps AS TrdgDocHdrIsExtended,
  succ_arch AS TrdgDocSuccessorArchived,
  cast( consol_it_exist as wb2_consol_item_exist preserving type ) AS TrdgDocHasCnsldtdItem,
  set_variant AS TrdgDocVarContrSettlmt,
  in_approval AS TrdgDocIsInApproval,
  kalsm_ch AS TrdgDocBatDetnProcedure,
  cast( pf_status as wb2_tc_procg_status preserving type ) AS TrdgDocProcgStatus,
  pf_last_action AS TrdgDocProcessingLastAction,
  pf_last_order AS TrdgDocProcgLastSequence,
  tew_type AS TradingProcessVariantType,
  cast ( ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  created_from AS TrdgDocSrceDocType,
  purpose AS TrdgDocPurpose,
  cast( bstnk as wb2_po_by_customer preserving type) AS TrdgDocPOByCustomer,
  cast( bstdk as wb2_cust_purch_order_date preserving type ) AS CustomerPurchaseOrderDate,
  abssc AS PaymentGuaranteeProcedure,
  lcnum AS InternalFinancialDocument,
  akprz AS DepreciationPercentage,
  logsys AS LogicalSystem,
  cast( lfspg as wb2_addl_expns_blk_rsn preserving type ) AS TrdgDocAddlExpnsBlkRsn,
  cast( lfspg as wb2_suplr_billg_blk_rsn preserving type ) AS TrdgDocSuplrBillgBlkRsn,
  cast( knumv_sd as wb2_sls_doc_cndn preserving type ) AS SalesDocumentCondition,
  output_control AS TrdgDocOutputControl
FROM wbhk
LEFT OUTER JOIN R_TrdgDocType AS _TradingDocumentType ON TradingDocumentType = _TradingDocumentType.TradingDocumentType  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocCategory AS _TrdgDocCategory ON TrdgDocCategory = _TrdgDocCategory.TrdgDocCategory  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocApplicationStatus AS _TrdgDocApplStatus ON TrdgDocApplicationStatus = _TrdgDocApplStatus.TrdgDocApplicationStatus  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocProcgStatus AS _TrdgDocProcgStatus ON TrdgDocProcgStatus = _TrdgDocProcgStatus.TrdgDocProcgStatus  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocSuccssrArchived AS _TrdgDocSuccssrArchived ON TrdgDocSuccessorArchived = _TrdgDocSuccssrArchived.TrdgDocSuccessorArchived  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocLastChgdCat AS _TrdgDocLastChgdCat ON TrdgDocLastChangedCategory = _TrdgDocLastChgdCat.TrdgDocLastChangedCategory  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocVarContrSettlmt AS _TrdgDocVarContrSettlmt ON TrdgDocVarContrSettlmt = _TrdgDocVarContrSettlmt.TrdgDocVarContrSettlmt  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocHasCnsldtdItem AS _TrdgDocHasCnsldtdItem ON TrdgDocHasCnsldtdItem = _TrdgDocHasCnsldtdItem.TrdgDocHasCnsldtdItem  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocPricingType AS _TrdgDocPricingType ON TrdgDocPricingType = _TrdgDocPricingType.TrdgDocPricingType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- 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_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _OrganizationDivision ON OrganizationDivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1 ON AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2 ON AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3 ON AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4 ON AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5 ON AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5  -- association [0..1]
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SalesOrderReason ON SalesOrderReason = _SalesOrderReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_CustomerPurchaseOrderType AS _CustomerPurchaseOrderType ON CustomerPurchaseOrderType = _CustomerPurchaseOrderType.CustomerPurchaseOrderType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TrdgDocCurrency ON TrdgDocCurrency = _TrdgDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TrdgDocSalesCurrency ON TrdgDocSalesCurrency = _TrdgDocSalesCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _HeaderBillingBlockReason ON HeaderBillingBlockReason = _HeaderBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _TrdgDocExchangeRateType ON TrdgDocExchangeRateType = _TrdgDocExchangeRateType.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _TrdgDocSlsExchangeRateType ON TrdgDocSalesExchangeRateType = _TrdgDocSlsExchangeRateType.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN I_SlsPricingProcedure AS _TrdgDocSlsPricingProcedure ON TrdgDocSalesPricingProcedure = _TrdgDocSlsPricingProcedure.PricingProcedure  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_SalesArea AS _SalesArea ON SalesOrganization = _SalesArea.SalesOrganization  -- association [0..*]
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_CustomerSalesArea AS _CustomerSalesArea ON SoldToParty = _CustomerSalesArea.Customer AND SalesOrganization = _CustomerSalesArea.SalesOrganization AND DistributionChannel = _CustomerSalesArea.DistributionChannel AND OrganizationDivision = _CustomerSalesArea.Division  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocReleaseStatus AS _TrdgDocReleaseStatus ON TrdgDocReleaseStatus = _TrdgDocReleaseStatus.TrdgDocReleaseStatus  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocBusProcCategory AS _TrdgDocBusProcCategory ON TrdgDocBusProcessCategory = _TrdgDocBusProcCategory.TrdgDocBusProcessCategory  -- association [0..1]
LEFT OUTER JOIN R_TrdgProcessVariantType AS _TradingProcessVariantType ON TradingProcessVariantType = _TradingProcessVariantType.TradingProcessVariantType  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementInternalID ON WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocPurpose AS _TrdgDocPurpose ON TrdgDocPurpose = _TrdgDocPurpose.TrdgDocPurpose  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocSrceDocType AS _TrdgDocSrceDocType ON TrdgDocSrceDocType = _TrdgDocSrceDocType.TrdgDocSrceDocType  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocIsComplete AS _TrdgDocIsComplete ON TrdgDocIsComplete = _TrdgDocIsComplete.TrdgDocIsComplete  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderType AS _SalesOrderType ON SalesDocumentType = _SalesOrderType.SalesOrderType  -- association [0..1]
LEFT OUTER JOIN I_MatlUsageIndicator AS _MatlUsageIndicator ON TrdgDocProdUsgeCat = _MatlUsageIndicator.MatlUsageIndicator  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxDepartureCountry ON TaxDepartureCountry = _TaxDepartureCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _VATRegistrationCountry ON VATRegistrationCountry = _VATRegistrationCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_TrdgDocAddlExpnsBlkRsnVH AS _TrdgDocAddlExpnsBlkRsn ON TrdgDocAddlExpnsBlkRsn = _TrdgDocAddlExpnsBlkRsn.TrdgDocAddlExpnsBlkRsn  -- association [0..1]
LEFT OUTER JOIN I_TrdgDocSuplrBillgBlkRsn AS _TrdgDocSuplrBillgBlkRsn ON TrdgDocSuplrBillgBlkRsn = _TrdgDocSuplrBillgBlkRsn.TrdgDocSuplrBillgBlkRsn  -- association [0..1]
;