T047

Transparent Table Customizing Table
8 Fields 4 CDS Views

Company Code Dunning Control

T047 is an SAP database table in S/4HANA. Company Code Dunning Control. It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPAddlCustCompanyCodeTP view left_outer TRANSACTIONAL BO view for Company Code of Customers
I_BPAddlSuplrCompanyCodeTP view left_outer TRANSACTIONAL BO view for Company Code for Suppliers
I_BusinessPartnerCustCoTP view left_outer TRANSACTIONAL BO view for customer companycode
I_BusinessPartnerSuplrCoTP view left_outer TRANSACTIONAL Association View for Supplier CoCode

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
xmabe XMABE_047 Dun.by Dun.Area
xstmv XSTMV_047 By Dunning Lev.
rbukm RBUKM Ref.CoCode
smhnk SMHNK Sort.Var. MHNK
smhnd SMHND Sort.Var. MHND
mbukrs MBUKRS Dunn.Com.Code

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.

-- Company Code Dunning Control
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T047 (
    MANDT,   -- Client [MANDT]
    BUKRS,   -- Company Code [BUKRS]
    XMABE,   -- Dun.by Dun.Area [XMABE_047]
    XSTMV,   -- By Dunning Lev. [XSTMV_047]
    RBUKM,   -- Ref.CoCode [RBUKM]
    SMHNK,   -- Sort.Var. MHNK [SMHNK]
    SMHND,   -- Sort.Var. MHND [SMHND]
    MBUKRS,  -- Dunn.Com.Code [MBUKRS]
    PRIMARY KEY (MANDT, BUKRS)
);

Learn More