/SAPAPO/TPSRC

Transparent Table Application Table
59 Fields 2 CDS Views

Contracts: External Procurement

/SAPAPO/TPSRC is an SAP database table in S/4HANA. Contracts: External Procurement. It contains 59 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
/sapapo/pds_sel_help view left_outer Selection of PDS
ScmPrd_Tpsrc_M view from Product Scm redirect for TPSRC_M

Fields (59)

KeyField Data ElementDescription DomainTypeLength
KEY mandt /sapapo/mandt Client
KEY bzqid /sapapo/bzqid GUIDSoS
logsy /sapapo/logsrcsys Log. Source Syst.
tdsrc /sapapo/doc_src Source Category
ebeln /sapapo/ebeln Purchasing Doc. No.
ebelp /sapapo/ebelp Document Item
ekorg /sapapo/ekorg Purchasing Org.
matid /sapapo/matid Product ID
locfr /sapapo/locid Location ID
locto /sapapo/locid Location ID
valfr /sapapo/scc_valfromtstmp Start
valto /sapapo/scc_valtotstmp End
consi /sapapo/consi Ind.: Consign.
subco /sapapo/subco Ind.: Subcontr.
spec_stock_logsy /sapapo/ciflogsysk Log.Sys. Prod.Alloc.
sp_stk_ind /sapapo/sobkz Special Stock
spec_stock /sapapo/sskey Special Stock
abueb /sapapo/erpro RC Profile
csint /sapapo/snpcsint GUID
apoms /sapapo/apoms SA Proc. Control
bzq_active /sapapo/bzq_active Proc. Rel. Active
addrnumber ad_addrnum Address Number
plifz /sapapo/pwb_plifz Plnd Deliv.Time
bstme /sapapo/bstme Order Unit
meins /sapapo/meins Base Unit
umrez /sapapo/umrez Numerator
umren /sapapo/umren Denominat.
lcrel /sapapo/lcrel LC Relevance
fabkz /sapapo/fabkz Sched. Agr. Forecast
webrl /sapapo/webrl Internet Rel.
idnlf /sapapo/idnlf Vendor Material
lgbzo /sapapo/lgbzo Staging Area
cfprof /sapapo/cmds_mm_cfprof Confirm. Profile
process /sapapo/cmds_mm_process Process
abdat /sapapo/abdat Reconcil. Date
abftz /sapapo/abftz Agr. Cum. Qty.
etfz1 /sapapo/etfz1 Firm Zone
etfz2 /sapapo/etfz2 Trade-Off Zone
plant_dp /sapapo/plant_dp Plant-Dep. Source
ship_locto /sapapo/ship_locto Ship-To Loc. (GUID
use_plifz /sapapo/plifzflg Flag for Planned DT
varpuom /sapapo/varpuom Variable Order Un.
measgrsup /sapapo/measgrsup Unit of Meas. Group
ekgrp /sapapo/ekgrp Purch. Group
process_type_ich /sapapo/process_type_ich Proc. Type SNC
source_list /sapapo/xfeld Checkbox field
prord /sapapo/rdpro Rounding Prfl.
procyc /sapapo/procyc Proc. Cycle Profile
cq_abftz_chg /sapapo/xfeld Checkbox field
cq_ctrltype /sapapo/cq_control_type Control Category
cq_resrfdat /sapapo/cq_reset_ref_date Field is obsolete and can be replaced in table /SAPAPO/TPSRC
cq_respldat /sapapo/cq_reset_plan_date Field is obsolete and can be replaced in /SAPAPO/TPSRC
cq_respldat_chg /sapapo/cq_respldat_chg Field is obsolete and can be replaced
cq_nocq /sapapo/xfeld Checkbox field
kunnr /sapapo/custnr CustomerNoPlant
uebto /sapapo/uebto Overdeliv. Tol.
untto /sapapo/untto Underdel. Tol.
setup_cost /sapapo/fixcost Fixed Costs
uebtk /sapapo/uebtk_pur Unlimited

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.

-- Contracts: External Procurement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SAPAPO/TPSRC (
    MANDT,             -- Client [/sapapo/mandt]
    BZQID,             -- GUIDSoS [/sapapo/bzqid]
    LOGSY,             -- Log. Source Syst. [/sapapo/logsrcsys]
    TDSRC,             -- Source Category [/sapapo/doc_src]
    EBELN,             -- Purchasing Doc. No. [/sapapo/ebeln]
    EBELP,             -- Document Item [/sapapo/ebelp]
    EKORG,             -- Purchasing Org. [/sapapo/ekorg]
    MATID,             -- Product ID [/sapapo/matid]
    LOCFR,             -- Location ID [/sapapo/locid]
    LOCTO,             -- Location ID [/sapapo/locid]
    VALFR,             -- Start [/sapapo/scc_valfromtstmp]
    VALTO,             -- End [/sapapo/scc_valtotstmp]
    CONSI,             -- Ind.: Consign. [/sapapo/consi]
    SUBCO,             -- Ind.: Subcontr. [/sapapo/subco]
    SPEC_STOCK_LOGSY,  -- Log.Sys. Prod.Alloc. [/sapapo/ciflogsysk]
    SP_STK_IND,        -- Special Stock [/sapapo/sobkz]
    SPEC_STOCK,        -- Special Stock [/sapapo/sskey]
    ABUEB,             -- RC Profile [/sapapo/erpro]
    CSINT,             -- GUID [/sapapo/snpcsint]
    APOMS,             -- SA Proc. Control [/sapapo/apoms]
    BZQ_ACTIVE,        -- Proc. Rel. Active [/sapapo/bzq_active]
    ADDRNUMBER,        -- Address Number [ad_addrnum]
    PLIFZ,             -- Plnd Deliv.Time [/sapapo/pwb_plifz]
    BSTME,             -- Order Unit [/sapapo/bstme]
    MEINS,             -- Base Unit [/sapapo/meins]
    UMREZ,             -- Numerator [/sapapo/umrez]
    UMREN,             -- Denominat. [/sapapo/umren]
    LCREL,             -- LC Relevance [/sapapo/lcrel]
    FABKZ,             -- Sched. Agr. Forecast [/sapapo/fabkz]
    WEBRL,             -- Internet Rel. [/sapapo/webrl]
    IDNLF,             -- Vendor Material [/sapapo/idnlf]
    LGBZO,             -- Staging Area [/sapapo/lgbzo]
    CFPROF,            -- Confirm. Profile [/sapapo/cmds_mm_cfprof]
    PROCESS,           -- Process [/sapapo/cmds_mm_process]
    ABDAT,             -- Reconcil. Date [/sapapo/abdat]
    ABFTZ,             -- Agr. Cum. Qty. [/sapapo/abftz]
    ETFZ1,             -- Firm Zone [/sapapo/etfz1]
    ETFZ2,             -- Trade-Off Zone [/sapapo/etfz2]
    PLANT_DP,          -- Plant-Dep. Source [/sapapo/plant_dp]
    SHIP_LOCTO,        -- Ship-To Loc. (GUID [/sapapo/ship_locto]
    USE_PLIFZ,         -- Flag for Planned DT [/sapapo/plifzflg]
    VARPUOM,           -- Variable Order Un. [/sapapo/varpuom]
    MEASGRSUP,         -- Unit of Meas. Group [/sapapo/measgrsup]
    EKGRP,             -- Purch. Group [/sapapo/ekgrp]
    PROCESS_TYPE_ICH,  -- Proc. Type SNC [/sapapo/process_type_ich]
    SOURCE_LIST,       -- Checkbox field [/sapapo/xfeld]
    PRORD,             -- Rounding Prfl. [/sapapo/rdpro]
    PROCYC,            -- Proc. Cycle Profile [/sapapo/procyc]
    CQ_ABFTZ_CHG,      -- Checkbox field [/sapapo/xfeld]
    CQ_CTRLTYPE,       -- Control Category [/sapapo/cq_control_type]
    CQ_RESRFDAT,       -- Field is obsolete and can be replaced in table /SAPAPO/TPSRC [/sapapo/cq_reset_ref_date]
    CQ_RESPLDAT,       -- Field is obsolete and can be replaced in /SAPAPO/TPSRC [/sapapo/cq_reset_plan_date]
    CQ_RESPLDAT_CHG,   -- Field is obsolete and can be replaced [/sapapo/cq_respldat_chg]
    CQ_NOCQ,           -- Checkbox field [/sapapo/xfeld]
    KUNNR,             -- CustomerNoPlant [/sapapo/custnr]
    UEBTO,             -- Overdeliv. Tol. [/sapapo/uebto]
    UNTTO,             -- Underdel. Tol. [/sapapo/untto]
    SETUP_COST,        -- Fixed Costs [/sapapo/fixcost]
    UEBTK,             -- Unlimited [/sapapo/uebtk_pur]
    PRIMARY KEY (MANDT, BZQID)
);

Learn More