SKB1CE

G/L Account Master (Company Code) + CELEM | #masterdata | Component: Basic Functions
Column Name Description
MANDT FK Client
BUKRS FK Company Code
SAKNR FK G/L Account Number
Column Name Description
Column Name Description
Column Name Description
DATLZ Date of Last Interest Calculation Run
ERDAT Date on which the Record Was Created
ZINDT Key Date of Last Interest Calculation
Column Name Description
MITKZ Account is Reconciliation Account Show values
WMETH Indicator: Account Managed in External System Show values
XGKON Cash Receipt Account / Cash Disbursement Account Show values
XINTB Indicator: Is Account only Posted to Automatically? Show values
XKRES Indicator: Can Line Items Be Displayed by Account? Show values
XLOEB Indicator: Account Marked for Deletion? Show values
XNKON Indicator: Supplement for Automatic Postings ? Show values
XOPVW Indicator: Open Item Management? Show values
XSPEB Indicator: Is Account Blocked for Posting? Show values
ZINRT Interest Calculation Frequency in Months Show values
XMITK Indicator: Reconcil.Acct Ready for Input at Time of Posting? Show values
XMWNO Indicator: Tax code is not a required field Show values
XSALH Manage Balances in Local Currency Only (Indicator) Show values
XLGCLR Open Item Management by Ledger Group Show values
MGEFL Indicator for Recording Consumption Quantities Show values
KATYP Cost element category Show values
Column Name Description Domain name
BEGRU Authorization Group BRGRU
ERNAM Name of Person who Created the Object USNAM
FIPLS Financial Budget Item FIPLS
MWSKZ Tax Category in Account Master Record SMWSK
STEXT G/L Account Additional Text TEXT50
ALTKT Alternative Account Number in Company Code SAKNR
FIPOS Commitment Item FIPOS
BEWGP Valuation Group CHAR10
COCHANGED Controlling area data changed CHAR1
LAST_CHANGED_TS UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Company Code
  • SKB1CE.MANDT == T001.MANDT
  • SKB1CE.BUKRS == T001.BUKRS
Accounting Clerk Abbreviation
  • Company Code
  • Client
  • Accounting Clerk Abbreviation
  • SKB1CE.BUKRS == T001S.BUKRS
  • SKB1CE.MANDT == T001S.MANDT
  • SKB1CE.BUSAB == T001S.BUSAB
Planning Group
  • SKB1CE.MANDT == T035.MANDT
  • SKB1CE.FDGRV == T035.GRUPP
Planning Level
  • SKB1CE.MANDT == T036.MANDT
  • SKB1CE.FDLEV == T036.EBENE
Field status group
  • ?
  • Field status group
  • Client
  • SKB1CE.[column in domain "FSTVA"] == T004F.BUKRS
  • SKB1CE.FSTAG == T004F.FSTAG
  • SKB1CE.MANDT == T004F.MANDT
Short Key for a House Bank
  • Short Key for a House Bank
  • Company Code
  • SKB1CE.MANDT == T012.MANDT
  • SKB1CE.HBKID == T012.HBKID
  • SKB1CE.BUKRS == T012.BUKRS
ID for Account Details
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • SKB1CE.BUKRS == T012K.BUKRS
  • SKB1CE.HKTID == T012K.HKTID
  • SKB1CE.MANDT == T012K.MANDT
  • SKB1CE.HBKID == T012K.HBKID
Inflation Key
  • ?
  • Inflation Key
Client SKB1CE.MANDT == T000.MANDT
MCA Key SKB1CE.MCAKEY == GLE_MCA_TMCAKEY.MANDT
Recovery Indicator
  • Company Code
  • Recovery Indicator
  • SKB1CE.MANDT == T8JJ.MANDT
  • SKB1CE.BUKRS == T8JJ.BUKRS
  • SKB1CE.RECID == T8JJ.RECID
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • SKB1CE.[column in domain "KTOPL"] == SKA1.KTOPL
  • SKB1CE.MANDT == SKA1.MANDT
  • SKB1CE.SAKNR == SKA1.SAKNR
Tolerance Group for G/L Accounts
  • Company Code
  • Tolerance Group for G/L Accounts
  • SKB1CE.MANDT == T043S.MANDT
  • SKB1CE.BUKRS == T043S.BUKRS
  • SKB1CE.TOGRU == T043S.TOGRU
Interest Indicator
  • Interest Indicator
  • Client
  • SKB1CE.VZSKZ == T056.VZSKZ
  • SKB1CE.MANDT == T056.MANDT
Account Currency
  • SKB1CE.MANDT == TCURC.MANDT
  • SKB1CE.WAERS == TCURC.WAERS
Key for sorting according to assignment numbers SKB1CE.ZUAWA == TZUN.ZUAWA
Other Relations | to Master Data Relations ↑ Join Conditions
Key for Exchange Rate Differences in Foreign Currency Accts
  • ?
  • Client
  • ?
  • Key for Exchange Rate Differences in Foreign Currency Accts
  • SKB1CE.[column in domain "BWBER"] == T030S.CURTP
  • SKB1CE.MANDT == T030S.MANDT
  • SKB1CE.[column in domain "KTOPL"] == T030S.KTOPL
  • SKB1CE.KDFSL == T030S.KDFSL