_PAYMENTPROPOSALHEADER

_PAYMENTPROPOSALHEADER is an SAP database table in S/4HANA. It contains 61 fields.

Fields (61)

KeyField CDS FieldsUsed in Views
AccountingClerk AccountingClerk 1
AddressID AddressID 1
BankAccountHolderName BankAccountHolderName 1
BankChainBank1ControlKey BankChainBank1ControlKey 1
BankChainBank1DetailReference BankChainBank1DetailReference 1
BankChainBank2ControlKey BankChainBank2ControlKey 1
BankChainBank2DetailReference BankChainBank2DetailReference 1
BankChainBank3ControlKey BankChainBank3ControlKey 1
BankChainBank3DetailReference BankChainBank3DetailReference 1
BankControlKey BankControlKey 1
BankInternalID BankInternalID 1
BankPaymentGroupingOrigin BankPaymentGroupingOrigin 1
BillOfExchangeIssueDate BillOfExchangeIssueDate 1
BusinessArea BusinessArea 1
BusinessPlace BusinessPlace 1
Country Country 1
CustomerAdditionalName CustomerAdditionalName 1
DataExchangeInstruction1 DataExchangeInstruction1 1
DataExchangeInstruction2 DataExchangeInstruction2 1
DataExchangeInstruction3 DataExchangeInstruction3 1
DataExchangeInstruction4 DataExchangeInstruction4 1
DataExchangeInstructionKey DataExchangeInstructionKey 1
DirectDebitType DirectDebitType 1
District District 1
EDIPaymentAdviceStatus EDIPaymentAdviceStatus 1
EDIPaymentOrderStatus EDIPaymentOrderStatus 1
ExchangeRate ExchangeRate 1
FunctionalCurrency FunctionalCurrency 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 2
LostCashDiscountInCoCodeCrcy LostCashDiscountInCoCodeCrcy 1
LostCashDiscountInTransacCrcy LostCashDiscountInTransacCrcy 1
NumberOfPaidItems NumberOfPaidItems 1
NumberOfTextLines NumberOfTextLines 1
PayeeBankCountry PayeeBankCountry 1
PayeeLanguage PayeeLanguage 1
PayeePaymentSystem PayeePaymentSystem 1
PayeePOBox PayeePOBox 1
PayeePOBoxPostalCode PayeePOBoxPostalCode 1
PayeePostalCode PayeePostalCode 1
PayeeTitle PayeeTitle 1
PaymentMethod PaymentMethod 2
PaymentReason PaymentReason 1
PaymentRequestPaymentGroup PaymentRequestPaymentGroup 1
PaymentRunIsProposal PaymentRunIsProposal 1
PersonnelNumber PersonnelNumber 1
POBox POBox 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
PostingDate PostingDate 3
Region Region 1
SendingCompanyCode SendingCompanyCode 1
SEPAMandateUUID SEPAMandateUUID 1
SEPASequenceType SEPASequenceType 1
StreetAddressName StreetAddressName 1
SupplierAdditionalName SupplierAdditionalName 1
SupplierCityName SupplierCityName 1
SupplierClerkIDBySupplier SupplierClerkIDBySupplier 1
SupplierCountry SupplierCountry 1
SWIFTTransactionReferenceUUID SWIFTTransactionReferenceUUID 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PAYMENTPROPOSALHEADER (
    ACCOUNTINGCLERK,
    ADDRESSID,
    BANKACCOUNTHOLDERNAME,
    BANKCHAINBANK1CONTROLKEY,
    BANKCHAINBANK1DETAILREFERENCE,
    BANKCHAINBANK2CONTROLKEY,
    BANKCHAINBANK2DETAILREFERENCE,
    BANKCHAINBANK3CONTROLKEY,
    BANKCHAINBANK3DETAILREFERENCE,
    BANKCONTROLKEY,
    BANKINTERNALID,
    BANKPAYMENTGROUPINGORIGIN,
    BILLOFEXCHANGEISSUEDATE,
    BUSINESSAREA,
    BUSINESSPLACE,
    COUNTRY,
    CUSTOMERADDITIONALNAME,
    DATAEXCHANGEINSTRUCTION1,
    DATAEXCHANGEINSTRUCTION2,
    DATAEXCHANGEINSTRUCTION3,
    DATAEXCHANGEINSTRUCTION4,
    DATAEXCHANGEINSTRUCTIONKEY,
    DIRECTDEBITTYPE,
    DISTRICT,
    EDIPAYMENTADVICESTATUS,
    EDIPAYMENTORDERSTATUS,
    EXCHANGERATE,
    FUNCTIONALCURRENCY,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    LOSTCASHDISCOUNTINCOCODECRCY,
    LOSTCASHDISCOUNTINTRANSACCRCY,
    NUMBEROFPAIDITEMS,
    NUMBEROFTEXTLINES,
    PAYEEBANKCOUNTRY,
    PAYEELANGUAGE,
    PAYEEPAYMENTSYSTEM,
    PAYEEPOBOX,
    PAYEEPOBOXPOSTALCODE,
    PAYEEPOSTALCODE,
    PAYEETITLE,
    PAYMENTMETHOD,
    PAYMENTREASON,
    PAYMENTREQUESTPAYMENTGROUP,
    PAYMENTRUNISPROPOSAL,
    PERSONNELNUMBER,
    POBOX,
    POBOXDEVIATINGCITYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    POSTINGDATE,
    REGION,
    SENDINGCOMPANYCODE,
    SEPAMANDATEUUID,
    SEPASEQUENCETYPE,
    STREETADDRESSNAME,
    SUPPLIERADDITIONALNAME,
    SUPPLIERCITYNAME,
    SUPPLIERCLERKIDBYSUPPLIER,
    SUPPLIERCOUNTRY,
    SWIFTTRANSACTIONREFERENCEUUID
);