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