T161

Transparent Table Customizing (protected)
75 Fields 16 CDS Views

Purchasing Document Types

T161 is an SAP database table in S/4HANA. Purchasing Document Types. It contains 75 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
/dmbe/i_Contracttypebuy view from Descriptions for material document types
C_SrcgProjectItemProcessFlow view_entity inner CONSUMPTION Sourcing Project Item Process Flow
I_CntrlPurContrPartnerFuncVH view from BASIC Central Contract Partner Function details
I_FreightContractVH view left_outer BASIC Value Help for Freight Contract
I_PPS_PurchasingDocument view_entity inner BASIC Purchasing Document
I_PPS_PurContrDocType view_entity from BASIC PPS Relevant Purchase Contract Types
I_PPS_PurContrHdrPrtnFuncVH view_entity inner BASIC PPS Purchase Contract Header Partners
I_PPS_PurContrItmPrtnFuncVH view_entity inner BASIC PPS Purchase Contract Item Partners
I_PurchasingDocumentType view from BASIC Purchasing Document Type
I_PurContractClassification view from BASIC Purchase Contract Classification
I_PurContractPartnerFunctionVH view inner COMPOSITE Pur. Contr. Partner Function Value Help
I_SchedgAgrmtPartnerFunctionVH view from BASIC Scheduling Agreement Partner Function VH
Mmim_Purchasing_Document_Types view from Help-View for Purchasing Document Types
P_CRFQCustomizing view from BASIC
P_RFQCustomizing view from BASIC
P_RFQDocumentType view from CONSUMPTION

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bstyp BSTYP Doc. Category
KEY bsart ESART Document Type
bsakz BSAKZ Control
pincr PINCR Item Interval
numki NUMKI NR of Int. Asst
numke NUMKE NR of Ext. Asst
brefn BREFN Field Sel. Key
refba RFBSA Ref. doc. type
abvor ABVOR Rel. Order Qty
stafo STAFO Update Group
upinc UPINC Subitem Interv.
stako STAKO Tm.-dep. conds.
pargr PARGR PartnDet.Proc.
numka NUMKA No. range ALE
hityp HITYP_LH Hierarchy Cat.
lphis LPHIS Release Docu.
gsfrg GSFRG Overall req. rel.
variante TC_VAR Layout
shenq SHENQ Shared lock
kzale KZALE ALE-distr. contr.
abgebot ABGEBOT Glob. perc. bid
kornr KORNR Corr. misc. pr.
umlif UMLIF Supplier
koett KOETT Contract with delivery schedule
ar_object SAEOBJART Document type
koako KOAKO Contract allowed as release order against contract
oicsegi OIA_CSEGI QS permitted
oirfqreq OIH_RFQREQ Prec RFQ / req
wvvkz WVVKZ FP Summar. Docs
xlokz XLOKZ CrossSysTransit
cp_aktive CP_ACTIVE Comm. Plan Act.
cptype CP_TYPE CP Category
fls_rsto FLS_RSTO Enh. Store Ret.
msr_active MSR_ACTIVE Adv. Returns
rdp_profile LOGTRM_RDP_PROFILE RDP Profile
numkc NUMKC SRM Number Range
qtn_fol_doc_draft_autom QUOTE_FOLLOW_DOC_INDICATOR Ind. for Quote Fol.
qtn_fol_doc_active_autom QUOTE_FOLLOW_DOC_INDICATOR Ind. for Quote Fol.
qtn_fol_doc_manually QUOTE_FOLLOW_DOC_INDICATOR Ind. for Quote Fol.
rfq_process_type MM_RFQ_PROCESS_TYPE External Processing
scnr_based_wfl MMPUR_SCBSD_WFL Flexible Workflow
rfx_processing_cd RFX_PROCESSING_CD RFQ Awarding Type
aic_vcm_type MMPUR_AIC_VCM_TYPE_STO VCM Type adv. IC-STO
conf_wfl MMPUR_CONF_WFL Conf Workflow
po_atp_bulk_processing MMPUR_PO_ATP_BULK_PROCESSING ATP Bulk Processing
itmac /SAPSLL/ITMAC Trade Compliance
tolsl METOLSL Tolerance Key
fsh_vas_act FSH_VAS_ACT VAS Active Flag
fsh_vas_kalsm FSH_VAS_KALSM Determination Proc.
fsh_vas_del FSH_VAS_DEL VAS Del. Criteria
fsh_vas_detdt FSH_VAS_DETDT VAS Deter. Date
fsh_excl_return FSH_EXCL_RETURN Excl Ret Items
fsh_var_kalsm FSH_VAR_KALSM Determination Proc.
fsh_dpr_detpro FSH_DPR_DETPRO Determination Proc.
fsh_po_idoc FSH_PO_IDOC GA Creation
fsh_vas_corr FSH_VAS_CORR VAS Qty corr.
fsh_auto_dc FSH_AUTO_DC auto dist.
fsh_vm_act FSH_VM_ACT Variants Optional
rfm_contract_cons RFM_CONTRACT_CONS Cont. Consumption
rfm_contract_detr RFM_CONTRACT_DETR Cont. Determination
mill_omkz MILL_MM_OMKZ Reference chars
cntrl_conf_wfl MMPUR_CNTRL_CONF_WFL Cntrl Conf Workflow
pps_relevant PPS_E_RELEVANT PPS Relevant
smart_num_enabled PPS_E_SMART_NUMBER_ENABLED Smart num
default_doc_ty PPS_E_IS_DEFAULT_DOC_TY Def. Doc Typ
versionexclusionprofile PPS_E_VER_EX_PROF Version Exclusion Pr
modificationprofile PPS_E_MODIF_PROF Modification Prof
options_enabled PPS_E_OPTIONS_ENABLED Opt Enabled
version_reason_reqd PPS_E_VER_REASON_REQD Revision Rsn Reqd
nochangespostapproval PPS_E_NOCHANGESPOSTAPPROVAL No change after app
pubps_relevant PUBPS_E_RELEVANT PUBPS Relevant
sgt_cont_seg_ignore SGT_CONT_SEG_IGNORE Allow Blank Segment
wrf_enable_dateline WRF_ENABLE_DATELINE Enable Dateline
rfm_enable_ods RFM_ENABLE_ODS Enable

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.

-- Purchasing Document Types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T161 (
    MANDT,                     -- Client [MANDT]
    BSTYP,                     -- Doc. Category [BSTYP]
    BSART,                     -- Document Type [ESART]
    BSAKZ,                     -- Control [BSAKZ]
    PINCR,                     -- Item Interval [PINCR]
    NUMKI,                     -- NR of Int. Asst [NUMKI]
    NUMKE,                     -- NR of Ext. Asst [NUMKE]
    BREFN,                     -- Field Sel. Key [BREFN]
    REFBA,                     -- Ref. doc. type [RFBSA]
    ABVOR,                     -- Rel. Order Qty [ABVOR]
    STAFO,                     -- Update Group [STAFO]
    UPINC,                     -- Subitem Interv. [UPINC]
    STAKO,                     -- Tm.-dep. conds. [STAKO]
    PARGR,                     -- PartnDet.Proc. [PARGR]
    NUMKA,                     -- No. range ALE [NUMKA]
    HITYP,                     -- Hierarchy Cat. [HITYP_LH]
    LPHIS,                     -- Release Docu. [LPHIS]
    GSFRG,                     -- Overall req. rel. [GSFRG]
    VARIANTE,                  -- Layout [TC_VAR]
    SHENQ,                     -- Shared lock [SHENQ]
    KZALE,                     -- ALE-distr. contr. [KZALE]
    ABGEBOT,                   -- Glob. perc. bid [ABGEBOT]
    KORNR,                     -- Corr. misc. pr. [KORNR]
    UMLIF,                     -- Supplier [UMLIF]
    KOETT,                     -- Contract with delivery schedule [KOETT]
    AR_OBJECT,                 -- Document type [SAEOBJART]
    KOAKO,                     -- Contract allowed as release order against contract [KOAKO]
    OICSEGI,                   -- QS permitted [OIA_CSEGI]
    OIRFQREQ,                  -- Prec RFQ / req [OIH_RFQREQ]
    WVVKZ,                     -- FP Summar. Docs [WVVKZ]
    XLOKZ,                     -- CrossSysTransit [XLOKZ]
    CP_AKTIVE,                 -- Comm. Plan Act. [CP_ACTIVE]
    CPTYPE,                    -- CP Category [CP_TYPE]
    FLS_RSTO,                  -- Enh. Store Ret. [FLS_RSTO]
    MSR_ACTIVE,                -- Adv. Returns [MSR_ACTIVE]
    RDP_PROFILE,               -- RDP Profile [LOGTRM_RDP_PROFILE]
    NUMKC,                     -- SRM Number Range [NUMKC]
    QTN_FOL_DOC_DRAFT_AUTOM,   -- Ind. for Quote Fol. [QUOTE_FOLLOW_DOC_INDICATOR]
    QTN_FOL_DOC_ACTIVE_AUTOM,  -- Ind. for Quote Fol. [QUOTE_FOLLOW_DOC_INDICATOR]
    QTN_FOL_DOC_MANUALLY,      -- Ind. for Quote Fol. [QUOTE_FOLLOW_DOC_INDICATOR]
    RFQ_PROCESS_TYPE,          -- External Processing [MM_RFQ_PROCESS_TYPE]
    SCNR_BASED_WFL,            -- Flexible Workflow [MMPUR_SCBSD_WFL]
    RFX_PROCESSING_CD,         -- RFQ Awarding Type [RFX_PROCESSING_CD]
    AIC_VCM_TYPE,              -- VCM Type adv. IC-STO [MMPUR_AIC_VCM_TYPE_STO]
    CONF_WFL,                  -- Conf Workflow [MMPUR_CONF_WFL]
    PO_ATP_BULK_PROCESSING,    -- ATP Bulk Processing [MMPUR_PO_ATP_BULK_PROCESSING]
    ITMAC,                     -- Trade Compliance [/SAPSLL/ITMAC]
    TOLSL,                     -- Tolerance Key [METOLSL]
    FSH_VAS_ACT,               -- VAS Active Flag [FSH_VAS_ACT]
    FSH_VAS_KALSM,             -- Determination Proc. [FSH_VAS_KALSM]
    FSH_VAS_DEL,               -- VAS Del. Criteria [FSH_VAS_DEL]
    FSH_VAS_DETDT,             -- VAS Deter. Date [FSH_VAS_DETDT]
    FSH_EXCL_RETURN,           -- Excl Ret Items [FSH_EXCL_RETURN]
    FSH_VAR_KALSM,             -- Determination Proc. [FSH_VAR_KALSM]
    FSH_DPR_DETPRO,            -- Determination Proc. [FSH_DPR_DETPRO]
    FSH_PO_IDOC,               -- GA Creation [FSH_PO_IDOC]
    FSH_VAS_CORR,              -- VAS Qty corr. [FSH_VAS_CORR]
    FSH_AUTO_DC,               -- auto dist. [FSH_AUTO_DC]
    FSH_VM_ACT,                -- Variants Optional [FSH_VM_ACT]
    RFM_CONTRACT_CONS,         -- Cont. Consumption [RFM_CONTRACT_CONS]
    RFM_CONTRACT_DETR,         -- Cont. Determination [RFM_CONTRACT_DETR]
    MILL_OMKZ,                 -- Reference chars [MILL_MM_OMKZ]
    CNTRL_CONF_WFL,            -- Cntrl Conf Workflow [MMPUR_CNTRL_CONF_WFL]
    PPS_RELEVANT,              -- PPS Relevant [PPS_E_RELEVANT]
    SMART_NUM_ENABLED,         -- Smart num [PPS_E_SMART_NUMBER_ENABLED]
    DEFAULT_DOC_TY,            -- Def. Doc Typ [PPS_E_IS_DEFAULT_DOC_TY]
    VERSIONEXCLUSIONPROFILE,   -- Version Exclusion Pr [PPS_E_VER_EX_PROF]
    MODIFICATIONPROFILE,       -- Modification Prof [PPS_E_MODIF_PROF]
    OPTIONS_ENABLED,           -- Opt Enabled [PPS_E_OPTIONS_ENABLED]
    VERSION_REASON_REQD,       -- Revision Rsn Reqd [PPS_E_VER_REASON_REQD]
    NOCHANGESPOSTAPPROVAL,     -- No change after app [PPS_E_NOCHANGESPOSTAPPROVAL]
    PUBPS_RELEVANT,            -- PUBPS Relevant [PUBPS_E_RELEVANT]
    SGT_CONT_SEG_IGNORE,       -- Allow Blank Segment [SGT_CONT_SEG_IGNORE]
    WRF_ENABLE_DATELINE,       -- Enable Dateline [WRF_ENABLE_DATELINE]
    RFM_ENABLE_ODS,            -- Enable [RFM_ENABLE_ODS]
    PRIMARY KEY (MANDT, BSTYP, BSART)
);

Learn More