TBACT_BAS_QUOT

Transparent Table Application Table
18 Fields 3 CDS Views

Basis Market Data

TBACT_BAS_QUOT is an SAP database table in S/4HANA. Basis Market Data. It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_BasisPriceQuotation view from BASIC
P_Tbat_Basis_DeliveryPeriods view inner BASIC
P_Tbat_Basis_Quot_Max view from BASIC

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY basis_type TBAC_BASIS_TYPE Basis Type
KEY basis_id TBAC_BASIS_ID Basis ID
KEY dcsid TBA_DCSID DCS ID
KEY mic TBA_MIC MIC
KEY delivery_from TBAC_DELIVERY_FROM Delivery Start Date
KEY delivery_to TBAC_DELIVERY_TO Delivery End Date
KEY pricetype TBA_PRICETYPE Price Type
KEY pricedate TBA_PRICEDATE Price Date
KEY pricetime TBA_PRICETIME Price Time
KEY validfrom TBA_TIMESTAMP Valid From
keydate TBA_KEYDATE Maturity Key Date
contract_code TBA_CONTRACT_CODE Contr. Maturity Code
price TBAC_PRICE Quotation Price
uom TBA_UOM Quotation UoM
currency TBA_CURRENCY Currency
createdby TBA_CRUSER Entered By
deletion_ind TBA_PRICEQUOT_DELETION_IND Quotation Deleted

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Basis Market Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TBACT_BAS_QUOT (
    CLIENT,         -- Client [MANDT]
    BASIS_TYPE,     -- Basis Type [TBAC_BASIS_TYPE]
    BASIS_ID,       -- Basis ID [TBAC_BASIS_ID]
    DCSID,          -- DCS ID [TBA_DCSID]
    MIC,            -- MIC [TBA_MIC]
    DELIVERY_FROM,  -- Delivery Start Date [TBAC_DELIVERY_FROM]
    DELIVERY_TO,    -- Delivery End Date [TBAC_DELIVERY_TO]
    PRICETYPE,      -- Price Type [TBA_PRICETYPE]
    PRICEDATE,      -- Price Date [TBA_PRICEDATE]
    PRICETIME,      -- Price Time [TBA_PRICETIME]
    VALIDFROM,      -- Valid From [TBA_TIMESTAMP]
    KEYDATE,        -- Maturity Key Date [TBA_KEYDATE]
    CONTRACT_CODE,  -- Contr. Maturity Code [TBA_CONTRACT_CODE]
    PRICE,          -- Quotation Price [TBAC_PRICE]
    UOM,            -- Quotation UoM [TBA_UOM]
    CURRENCY,       -- Currency [TBA_CURRENCY]
    CREATEDBY,      -- Entered By [TBA_CRUSER]
    DELETION_IND,   -- Quotation Deleted [TBA_PRICEQUOT_DELETION_IND]
    PRIMARY KEY (CLIENT, BASIS_TYPE, BASIS_ID, DCSID, MIC, DELIVERY_FROM, DELIVERY_TO, PRICETYPE, PRICEDATE, PRICETIME, VALIDFROM)
);

Learn More