_BASIC

_BASIC is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY CashPoolAssignment CashPoolAssignment,CshPoolAssgmtHierNode 2
KEY RespyMgmtTeamID RespyMgmtTeamID 1
BankAccountCurrency BankAccountCurrency 1
BankAccountInternalID BankAccountInternalID 2
BankCountry BankCountry 1
CashPool CashPool 2
CashPoolAssgmtIsDeleted CashPoolAssgmtIsDeleted 2
CashPoolAssgmtIsHeadBkAcct CashPoolAssgmtIsHeadBkAcct 2
CashPoolAssgmtValdtyEndDte CashPoolAssgmtValdtyEndDte 2
CashPoolAssgmtValdtyStrtDte CashPoolAssgmtValdtyStrtDte 2
CashPoolAssignmentText CashPoolAssignmentText 2
CashPoolCreatedByUser CashPoolCreatedByUser 1
CashPoolCreationDateTime CashPoolCreationDateTime 1
CashPoolLastChangeDateTime CashPoolLastChangeDateTime 1
CashPoolLastChangedByUser CashPoolLastChangedByUser 1
CompanyCode CompanyCode 1
lvorm deletionFlag 1
wrkst materialBasic 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _BASIC (
    CASHPOOLASSIGNMENT,
    RESPYMGMTTEAMID,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTINTERNALID,
    BANKCOUNTRY,
    CASHPOOL,
    CASHPOOLASSGMTISDELETED,
    CASHPOOLASSGMTISHEADBKACCT,
    CASHPOOLASSGMTVALDTYENDDTE,
    CASHPOOLASSGMTVALDTYSTRTDTE,
    CASHPOOLASSIGNMENTTEXT,
    CASHPOOLCREATEDBYUSER,
    CASHPOOLCREATIONDATETIME,
    CASHPOOLLASTCHANGEDATETIME,
    CASHPOOLLASTCHANGEDBYUSER,
    COMPANYCODE,
    LVORM,
    WRKST,
    PRIMARY KEY (CASHPOOLASSIGNMENT, RESPYMGMTTEAMID)
);