SAFT_NOA_SUPLOG

Transparent Table Application Table
36 Fields 1 CDS Views

SAFT NO Supplier Temporary Log

SAFT_NOA_SUPLOG is an SAP database table in S/4HANA. SAFT NO Supplier Temporary Log. It contains 36 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_NO_SAFTSupplierLog view_entity from BASIC SAFT NO Supplier Temporary Log

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY statryrptgentity SRF_REPORTING_ENTITY Reporting Entity
KEY statryrptcategory SRF_REP_CAT_ID Report ID
KEY statryrptrunid SRF_REPORT_RUN_ID Report Run ID
KEY saftmodule SAFT_MODULE SAFT Mod
KEY ledger FINS_LEDGER Ledger
KEY companycode FIS_BUKRS Company Code
KEY fiscalyear FIS_GJAHR_NO_CONV Fiscal Year
KEY supplier FIS_LIFNR Supplier
KEY accountingdocument FIS_BELNR Journal Entry
KEY ledgergllineitem FIS_DOCLN Journal Entry Item
no_saftsupplierid SAFTN_NO_SUPPLIER_ID Supplier ID
suppliervatregistration FARP_STCEG VAT Registration No.
bpsuppliername SUPPLIERNAME_2 Supplier Name
suppliername SUPPLIERNAME Supplier Name
businesspartner BU_PARTNER Bus. Partner
businesspartneruuid BU_PARTNER_GUID BP GUID
taxnumber1 STCD1 Tax Number 1
taxnumber2 STCD2 Tax Number 2
vatregistration FARP_STCEG VAT Registration No.
reportingvatregistration FIES_ECSL_REPORTING_VAT Reporting VAT Number
banknumber BANKK Bank Key
bankaccount BANKN Bank Account
cityname TEXT40 Name
postalcode CHAR10 Character Field with Length 10
region CHAR3 3-Byte field
streetname TEXT60 Text
addresstypedesc TEXT20 Description
regionname BEZEI20 Description
housenumber AD_HSNM1 House Number
country LAND1 Country/Reg.
pobox AD_POBX PO Box
poboxpostalcode AD_PSTCD2 PO Box Post Cde
isonetimeaccount XCPDK One-time acct
itemisreportingrelevant GLO_REPORTING_ITEM Item Reporting Relv
_dataaging DATA_TEMPERATURE Data Aging

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.

-- SAFT NO Supplier Temporary Log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFT_NOA_SUPLOG (
    MANDT,                     -- Client [MANDT]
    STATRYRPTGENTITY,          -- Reporting Entity [SRF_REPORTING_ENTITY]
    STATRYRPTCATEGORY,         -- Report ID [SRF_REP_CAT_ID]
    STATRYRPTRUNID,            -- Report Run ID [SRF_REPORT_RUN_ID]
    SAFTMODULE,                -- SAFT Mod [SAFT_MODULE]
    LEDGER,                    -- Ledger [FINS_LEDGER]
    COMPANYCODE,               -- Company Code [FIS_BUKRS]
    FISCALYEAR,                -- Fiscal Year [FIS_GJAHR_NO_CONV]
    SUPPLIER,                  -- Supplier [FIS_LIFNR]
    ACCOUNTINGDOCUMENT,        -- Journal Entry [FIS_BELNR]
    LEDGERGLLINEITEM,          -- Journal Entry Item [FIS_DOCLN]
    NO_SAFTSUPPLIERID,         -- Supplier ID [SAFTN_NO_SUPPLIER_ID]
    SUPPLIERVATREGISTRATION,   -- VAT Registration No. [FARP_STCEG]
    BPSUPPLIERNAME,            -- Supplier Name [SUPPLIERNAME_2]
    SUPPLIERNAME,              -- Supplier Name [SUPPLIERNAME]
    BUSINESSPARTNER,           -- Bus. Partner [BU_PARTNER]
    BUSINESSPARTNERUUID,       -- BP GUID [BU_PARTNER_GUID]
    TAXNUMBER1,                -- Tax Number 1 [STCD1]
    TAXNUMBER2,                -- Tax Number 2 [STCD2]
    VATREGISTRATION,           -- VAT Registration No. [FARP_STCEG]
    REPORTINGVATREGISTRATION,  -- Reporting VAT Number [FIES_ECSL_REPORTING_VAT]
    BANKNUMBER,                -- Bank Key [BANKK]
    BANKACCOUNT,               -- Bank Account [BANKN]
    CITYNAME,                  -- Name [TEXT40]
    POSTALCODE,                -- Character Field with Length 10 [CHAR10]
    REGION,                    -- 3-Byte field [CHAR3]
    STREETNAME,                -- Text [TEXT60]
    ADDRESSTYPEDESC,           -- Description [TEXT20]
    REGIONNAME,                -- Description [BEZEI20]
    HOUSENUMBER,               -- House Number [AD_HSNM1]
    COUNTRY,                   -- Country/Reg. [LAND1]
    POBOX,                     -- PO Box [AD_POBX]
    POBOXPOSTALCODE,           -- PO Box Post Cde [AD_PSTCD2]
    ISONETIMEACCOUNT,          -- One-time acct [XCPDK]
    ITEMISREPORTINGRELEVANT,   -- Item Reporting Relv [GLO_REPORTING_ITEM]
    _DATAAGING,                -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, SAFTMODULE, LEDGER, COMPANYCODE, FISCALYEAR, SUPPLIER, ACCOUNTINGDOCUMENT, LEDGERGLLINEITEM)
);

Learn More