CFIN_AV_PO_ACC_S

Transparent Table Application Table
42 Fields 2 CDS Views

Service Account Assignment in Purchasing Document

CFIN_AV_PO_ACC_S is an SAP database table in S/4HANA. Service Account Assignment in Purchasing Document. It contains 42 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CFinRpldPurgDocSrvcAcctAsgt view_entity from EXTENSION CFin Rpld PD Srvc AcctAssgmt - Extension
R_CFinRpldPurgDocSrvcAcctAsgt view_entity from BASIC CFin Rpld Purg Doc Service AcctAssgmt

Fields (42)

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
packno PACKNO Package number
zekkn DZEKKN Account Assgmt No.
bekkn BEKKN SeqNo.PO AccAss
loekz KLOEK Deletion Ind.
aedat ERDAT Created On
wproz WPROZ Percentage
netwr KNETWR Acct Assgt Val.
sakto SAKNR G/L Account
gsber GSBER Business Area
kostl KOSTL Cost Center
vbeln VBELN SD Document
vbelp POSNR_VA Sales Doc. Item
veten ETENR Schedule Line
anln1 ANLN1 Asset
anln2 ANLN2 Subnumber
aufnr AUFNR Order
kokrs KOKRS CO Area
paobjnr RKEOBJNR Profit. segment
prctr PRCTR Profit Center
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_SRV Non-ded. input tax
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.
fmfgus_key FMFG_US_KEY US Govt
erkrs ERKRS Operating concern
dummy_avposrvcacct_incl_eew_ps CFD_DUMMY Dummy

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.

-- Service 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_S (
    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]
    PACKNO,                          -- Package number [PACKNO]
    ZEKKN,                           -- Account Assgmt No. [DZEKKN]
    BEKKN,                           -- SeqNo.PO AccAss [BEKKN]
    LOEKZ,                           -- Deletion Ind. [KLOEK]
    AEDAT,                           -- Created On [ERDAT]
    WPROZ,                           -- Percentage [WPROZ]
    NETWR,                           -- Acct Assgt Val. [KNETWR]
    SAKTO,                           -- G/L Account [SAKNR]
    GSBER,                           -- Business Area [GSBER]
    KOSTL,                           -- Cost Center [KOSTL]
    VBELN,                           -- SD Document [VBELN]
    VBELP,                           -- Sales Doc. Item [POSNR_VA]
    VETEN,                           -- Schedule Line [ETENR]
    ANLN1,                           -- Asset [ANLN1]
    ANLN2,                           -- Subnumber [ANLN2]
    AUFNR,                           -- Order [AUFNR]
    KOKRS,                           -- CO Area [KOKRS]
    PAOBJNR,                         -- Profit. segment [RKEOBJNR]
    PRCTR,                           -- Profit Center [PRCTR]
    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-ded. input tax [NAVNW_SRV]
    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]
    FMFGUS_KEY,                      -- US Govt [FMFG_US_KEY]
    ERKRS,                           -- Operating concern [ERKRS]
    DUMMY_AVPOSRVCACCT_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More