J_1BNFEPHARMA

Transparent Table Application Table
6 Fields 1 CDS Views

Medicines and Pharmaceutical Raw Material

J_1BNFEPHARMA is an SAP database table in S/4HANA. Medicines and Pharmaceutical Raw Material. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_NFePharmaceutical view from BASIC Brazil Nota Fiscal Pharma Items

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY docnum j_1bdocnum Document Number
KEY itmnum j_1bitmnum Item Number
cprodanvisa j_1bnfe_anvisa_product_code ANVISA Cod
vpmc j_1b_consumer_max_price Max Price
exemp_reason j_1bnfe_exemp_reason ANVISA Exemp. Reas.

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.

-- Medicines and Pharmaceutical Raw Material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BNFEPHARMA (
    MANDT,         -- Client [mandt]
    DOCNUM,        -- Document Number [j_1bdocnum]
    ITMNUM,        -- Item Number [j_1bitmnum]
    CPRODANVISA,   -- ANVISA Cod [j_1bnfe_anvisa_product_code]
    VPMC,          -- Max Price [j_1b_consumer_max_price]
    EXEMP_REASON,  -- ANVISA Exemp. Reas. [j_1bnfe_exemp_reason]
    PRIMARY KEY (MANDT, DOCNUM, ITMNUM)
);

Learn More