BDEF_CDS_ROOT_FOR_TEST

DDL: BDEF_CDS_ROOT_FOR_TEST SQL: BDEF_TEST_TABL Type: view Package: SWB_RAP_TEST_OBJ
40 Fields 1 Data Sources

Used for behavior definition tests.

BDEF_CDS_ROOT_FOR_TEST is a CDS View that provides data about "Used for behavior definition tests." in SAP S/4HANA. It reads from 1 data source (SEPM_I_SalesOrder) and exposes 40 fields with key field SalesOrderUUID. Part of development package SWB_RAP_TEST_OBJ.

Data Sources (1)

SourceAliasJoin Type
SEPM_I_SalesOrder SalesOrder from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName BDEF_TEST_TABL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
EndUserText.label Used for behavior definition tests. view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderUUID SEPM_I_SalesOrder SalesOrderUUID
SalesOrder SEPM_I_SalesOrder SalesOrder SD Document
CreatedByUser SEPM_I_SalesOrder CreatedByUser User Name
CreationDateTime SEPM_I_SalesOrder CreationDateTime Timestamp
LastChangedByUser SEPM_I_SalesOrder LastChangedByUser User Name
LastChangedDateTime SEPM_I_SalesOrder LastChangedDateTime Time Stamp
IsCreatedByBusinessPartner SEPM_I_SalesOrder IsCreatedByBusinessPartner Value
IsLastChangedByBusinessPartner SEPM_I_SalesOrder IsLastChangedByBusinessPartner Value
ShortTextGroupUUID SEPM_I_SalesOrder ShortTextGroupUUID Node Key
CustomerUUID SEPM_I_SalesOrder CustomerUUID NodeID
TransactionCurrency SEPM_I_SalesOrder TransactionCurrency Transaction Currency
GrossAmountInTransacCurrency SEPM_I_SalesOrder GrossAmountInTransacCurrency Tax-Inclusive Amount
NetAmountInTransactionCurrency SEPM_I_SalesOrder NetAmountInTransactionCurrency Tax-Exclusive Amount
TaxAmountInTransactionCurrency SEPM_I_SalesOrder TaxAmountInTransactionCurrency VAT Amount Type
SalesOrderLifeCycleStatus SEPM_I_SalesOrder SalesOrderLifeCycleStatus Status
SalesOrderBillingStatus SEPM_I_SalesOrder SalesOrderBillingStatus SO Confirmation
SalesOrderDeliveryStatus SEPM_I_SalesOrder SalesOrderDeliveryStatus SO Ordering
SalesOrderOverallStatus SEPM_I_SalesOrder SalesOrderOverallStatus Overall Sts
Opportunity SEPM_I_SalesOrder Opportunity Opportunity ID
CustomerContactUUID SEPM_I_SalesOrder CustomerContactUUID Customer Contact Key
ShipToPartyAddressUUID SEPM_I_SalesOrder ShipToPartyAddressUUID Node Key
BillToPartyAddressUUID SEPM_I_SalesOrder BillToPartyAddressUUID Node Key
SalesOrderPaymentMethod SEPM_I_SalesOrder SalesOrderPaymentMethod Pymt Meth.
SalesOrderPaymentTerms SEPM_I_SalesOrder SalesOrderPaymentTerms Terms of Paymnt
_BillingStatus _BillingStatus
_BillToPartyAddress _BillToPartyAddress
_CreatedByUser _CreatedByUser
_Customer _Customer
_CustomerContact _CustomerContact
_CustomerV2 _CustomerV2
_DeliveryStatus _DeliveryStatus
_Item _Item
_LastChangedByUser _LastChangedByUser
_LifeCycleStatus _LifeCycleStatus
_OverallStatus _OverallStatus
_PaymentMethod _PaymentMethod
_PaymentTerms _PaymentTerms
_ShipToPartyAddress _ShipToPartyAddress
_ShortTextGroup _ShortTextGroup
_TransactionCurrency _TransactionCurrency

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 BDEF_CDS_ROOT_FOR_TEST.
-- 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: BDEF_TEST_TABL

CREATE VIEW BDEF_CDS_ROOT_FOR_TEST AS
SELECT
  SalesOrder.SalesOrderUUID AS SalesOrderUUID,
  SalesOrder.SalesOrder AS SalesOrder,
  SalesOrder.CreatedByUser AS CreatedByUser,
  SalesOrder.CreationDateTime AS CreationDateTime,
  SalesOrder.LastChangedByUser AS LastChangedByUser,
  SalesOrder.LastChangedDateTime AS LastChangedDateTime,
  SalesOrder.IsCreatedByBusinessPartner AS IsCreatedByBusinessPartner,
  SalesOrder.IsLastChangedByBusinessPartner AS IsLastChangedByBusinessPartner,
  SalesOrder.ShortTextGroupUUID AS ShortTextGroupUUID,
  SalesOrder.CustomerUUID AS CustomerUUID,
  SalesOrder.TransactionCurrency AS TransactionCurrency,
  SalesOrder.GrossAmountInTransacCurrency AS GrossAmountInTransacCurrency,
  SalesOrder.NetAmountInTransactionCurrency AS NetAmountInTransactionCurrency,
  SalesOrder.TaxAmountInTransactionCurrency AS TaxAmountInTransactionCurrency,
  SalesOrder.SalesOrderLifeCycleStatus AS SalesOrderLifeCycleStatus,
  SalesOrder.SalesOrderBillingStatus AS SalesOrderBillingStatus,
  SalesOrder.SalesOrderDeliveryStatus AS SalesOrderDeliveryStatus,
  SalesOrder.SalesOrderOverallStatus AS SalesOrderOverallStatus,
  SalesOrder.Opportunity AS Opportunity,
  SalesOrder.CustomerContactUUID AS CustomerContactUUID,
  SalesOrder.ShipToPartyAddressUUID AS ShipToPartyAddressUUID,
  SalesOrder.BillToPartyAddressUUID AS BillToPartyAddressUUID,
  SalesOrder.SalesOrderPaymentMethod AS SalesOrderPaymentMethod,
  SalesOrder.SalesOrderPaymentTerms AS SalesOrderPaymentTerms
FROM SEPM_I_SalesOrder AS SalesOrder
;

Learn More