CFIN_AV_PO_ACC

Transparent Table Application Table
44 Fields 3 CDS Views

Account Assignment in Purchasing Document

CFIN_AV_PO_ACC is an SAP database table in S/4HANA. Account Assignment in Purchasing Document. It contains 44 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CFinRpldPurgDocAcctAssgmt view_entity from EXTENSION CFin Rpld PD Acct Assgmt - Extension
I_CFinRpldPurgDocAcctAssgmt view from BASIC CFin Rpld Purg Doc: Account Assignment
R_CFinRpldPurgDocAcctAssgmt view_entity from BASIC CFin Rpld Purg Doc Account Assignment

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
root_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
fins_logsys LOGSYS Logical system
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
zekkn DZEKKN Account Assgmt No.
loekz KLOEK Deletion Ind.
menge MENGE_D Quantity
vproz VPROZ Distribution
netwr BWERT Net Value
sakto SAKNR G/L Account
gsber GSBER Business Area
kostl KOSTL Cost Center
vbeln VBELN_CO SD Document
vbelp POSNR_CO Item
veten ETENR Schedule Line
anln1 ANLN1 Asset
anln2 ANLN2 Sub-number
aufnr AUFNR Order
kokrs KOKRS CO Area
ps_psp_pnr PS_PSP_PNR WBS Element
nplnr NPLNR Network
aufpl CO_AUFPL Plan No.f.Oper.
imkey IMKEY Real Estate Key
aplzl CIM_COUNT Counter
fipos FIPOS Commitment item
fistl FISTL Funds Center
geber BP_GEBER Fund
fkber FKBER Functional Area
dabrz DABRBEZ Reference date
navnw NAVNW Non-deductible
lstar LSTAR Activity Type
grant_nbr GM_GRANT_NBR Grant
budget_pd FM_BUDGET_PERIOD Budget Period
fm_split_batch FMSP_SPLIT_BATCH Dist.Batch No.
menge_f MENGE_F Qty (FP Number)
fmfgus_key FMFG_US_KEY US Govt
wempf WEMPF Recipient
aedat ERDAT Created On
prctr PRCTR Profit Center
paobjnr RKEOBJNR Profit. segment
erkrs ERKRS Operating concern

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.

-- Account Assignment in Purchasing Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AV_PO_ACC (
    MANDT,           -- Client [MANDT]
    DB_KEY,          -- NodeID [/BOBF/CONF_KEY]
    ROOT_KEY,        -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,      -- NodeID [/BOBF/CONF_KEY]
    FINS_LOGSYS,     -- Logical system [LOGSYS]
    EBELN,           -- Purchasing Doc. [EBELN]
    EBELP,           -- Item [EBELP]
    ZEKKN,           -- Account Assgmt No. [DZEKKN]
    LOEKZ,           -- Deletion Ind. [KLOEK]
    MENGE,           -- Quantity [MENGE_D]
    VPROZ,           -- Distribution [VPROZ]
    NETWR,           -- Net Value [BWERT]
    SAKTO,           -- G/L Account [SAKNR]
    GSBER,           -- Business Area [GSBER]
    KOSTL,           -- Cost Center [KOSTL]
    VBELN,           -- SD Document [VBELN_CO]
    VBELP,           -- Item [POSNR_CO]
    VETEN,           -- Schedule Line [ETENR]
    ANLN1,           -- Asset [ANLN1]
    ANLN2,           -- Sub-number [ANLN2]
    AUFNR,           -- Order [AUFNR]
    KOKRS,           -- CO Area [KOKRS]
    PS_PSP_PNR,      -- WBS Element [PS_PSP_PNR]
    NPLNR,           -- Network [NPLNR]
    AUFPL,           -- Plan No.f.Oper. [CO_AUFPL]
    IMKEY,           -- Real Estate Key [IMKEY]
    APLZL,           -- Counter [CIM_COUNT]
    FIPOS,           -- Commitment item [FIPOS]
    FISTL,           -- Funds Center [FISTL]
    GEBER,           -- Fund [BP_GEBER]
    FKBER,           -- Functional Area [FKBER]
    DABRZ,           -- Reference date [DABRBEZ]
    NAVNW,           -- Non-deductible [NAVNW]
    LSTAR,           -- Activity Type [LSTAR]
    GRANT_NBR,       -- Grant [GM_GRANT_NBR]
    BUDGET_PD,       -- Budget Period [FM_BUDGET_PERIOD]
    FM_SPLIT_BATCH,  -- Dist.Batch No. [FMSP_SPLIT_BATCH]
    MENGE_F,         -- Qty (FP Number) [MENGE_F]
    FMFGUS_KEY,      -- US Govt [FMFG_US_KEY]
    WEMPF,           -- Recipient [WEMPF]
    AEDAT,           -- Created On [ERDAT]
    PRCTR,           -- Profit Center [PRCTR]
    PAOBJNR,         -- Profit. segment [RKEOBJNR]
    ERKRS,           -- Operating concern [ERKRS]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More