DEMO_PURCH_DOC

Transparent Table Application Table
13 Fields 2 CDS Views

Purchase Document

DEMO_PURCH_DOC is an SAP database table in S/4HANA. Purchase Document. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
DEMO_CDS_FUNCTION_1 view_entity from CDS view entity, function
Demo_Cds_Purch_Doc view_entity from CDS view entity, purchase document

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY purchasedocument purchdocde Purchase Doc ID
description abap.sstring Description
status abap.char Approval Status
priority abap.char Priority
price abap.curr
currency abap.cuky
purchasingorganization abap.char Purchasing Organization
purchasedocumentimageurl abap.sstring Purchase Document Image URL
crea_date_time timestampl Time Stamp
crea_uname uname User Name
lchg_date_time timestampl Time Stamp
lchg_uname uname User Name

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.

-- Purchase Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEMO_PURCH_DOC (
    CLIENT,                    -- abap.clnt
    PURCHASEDOCUMENT,          -- Purchase Doc ID [purchdocde]
    DESCRIPTION,               -- Description [abap.sstring]
    STATUS,                    -- Approval Status [abap.char]
    PRIORITY,                  -- Priority [abap.char]
    PRICE,                     -- abap.curr
    CURRENCY,                  -- abap.cuky
    PURCHASINGORGANIZATION,    -- Purchasing Organization [abap.char]
    PURCHASEDOCUMENTIMAGEURL,  -- Purchase Document Image URL [abap.sstring]
    CREA_DATE_TIME,            -- Time Stamp [timestampl]
    CREA_UNAME,                -- User Name [uname]
    LCHG_DATE_TIME,            -- Time Stamp [timestampl]
    LCHG_UNAME,                -- User Name [uname]
    PRIMARY KEY (CLIENT, PURCHASEDOCUMENT)
);

Learn More